It Activates the Microsoft Script Editor window.Ĩ. ALT + Letter Keys Shortcut Shortcut Keyĭisplays the Remove Duplicates dialog boxįormat Cells dialog box with the Number tab selected.įormat Cells dialog box with the Font tab selected.įormat number with a thousand’s comma (,) separatorĮxpand the Insert Form Controls and ActiveX Controls drop-down menuĪdd or Remove the vertical interior border. It Displays the drop-down menu for the corresponding smart tag. Inserts a new worksheet into the active workbook Insert Chart (It Creates a chart of the data in the current range)ħ. ALT + SHIFT + Function Keys Shortcut Shortcut Key Maximize or restore currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize currently selected workbook window It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. In a PivotTable report, select the entire PivotTable report.It is also used to switch between absolute/relative refs AllĪlt+Shift+F1 New worksheet Insert, Worksheet AllĬtrl+` Toggle Value/Formula display Tools, Options, View, Formulas AllĬtrl+Shift+A Insert argument names into formula No direct equivalent AllĪlt+Down arrow Display AutoComplete list None Excel 95Īlt+’ Format Style dialog box Format, Style AllĬtrl+Shift+~ General format Format, Cells, Number, Category, General AllĬtrl+Shift+! Comma format Format, Cells, Number, Category, Number Time format Format, Cells, Number, Category, Time AllĬtrl+Shift+# Date format Format, Cells, Number, Category, Date AllĬtrl+Shift+$ Currency format Format, Cells, Number, Category, Currency AllĬtrl+Shift+% Percent format Format, Cells, Number, Category, Percentage AllĬtrl+Shift+^ Exponential format Format, Cells, Number, Category, AllĬtrl+Shift+& Place outline border around selected cells Format, Cells, Border AllĬtrl+Shift+_ Remove outline border Format, Cells, Border AllĬtrl+Shift+* Select the current region around the active cell. In versions prior to 97 - Insert, Macro, 4.0 Macro AllĪlt+F8 Macro dialog box Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions Excel 97/2000 +Īlt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Excel 97/2000 +Ĭtrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create AllĬtrl+Shift+F6 Previous Window Window. AllĬtrl+F9 Minimize workbook XL, Minimize AllĬtrl+F10 Maximize or restore window XL, Maximize AllĬtrl+F11 Inset 4.0 Macro sheet None in Excel 97. Shift+Ctrl+F6 Previous workbook window Window. Shift+F11 New worksheet Insert, Worksheet AllĬtrl+F3 Define name Insert, Names, Define AllĬtrl+F5 XL, Restore window size Restore AllĬtrl+F6 Next workbook window Window. None Excel 97/2000 +Ĭtrl+Alt+Shift+F9 Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Shift+F9 Calculate active worksheet Tools, Options, Calculation, Calc Sheet AllĬtrl+Alt+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Shift+F4 Find Next Edit, Find, Find Next All Shift+F3 Paste function into formula Insert, Function All Shift+F2 Edit cell comment Insert, Edit Comments All Shift+F1 What’s This? Help, What’s This? All Shift Hold down shift for additional functions in Excel’s menu none Excel 97/2000 + Allį4 While typing a formula, switch between absolute/relative refs None Allį9 Recalculate all workbooks Tools, Options, Calculation, Calc Now AllĬtrl+" Copy Value from Cell Above Edit, Paste Special, Value AllĬtrl+’ Copy Formula from Cell Above Edit, Copy All
Shortcut keyĚction Menu equivalent comments versionĬtrl+B Bold Format, Cells, Font, Font Style, Bold AllĬtrl+I Italic Format, Cells, Font, Font Style, Italic AllĬtrl+K Insert Hyperlink Insert, Hyperlink Excel 97/2000 +Ĭtrl+U Underline Format, Cells, Font, Underline, Single Allį4 Repeat last action Edit, Repeat. > is an icon, but am looking for keyboard shortcut) > Is there a keyboard shortcut to delete selected rows? (PS: I know that there
0 kommentar(er)
