Shift+Ctrl+F+F Font tab of Format Cell Dialog box Format, Cells, Font Before 97/2000 Shift+Ctrl+F Font Drop Down List Format, Cells, Font All None Excel 97/2000 +Ĭtrl+Enter Fill the selected cell range with the current entry. Shift+Tab Previous tool None Excel 97/2000 +Įnter Do the command None Excel 97/2000 +Īlt+Enter Start a new line in the same cell. In a workbook: activate previous workbook None Excel 97/2000 + Shift+Ctrl+Tab In toolbar: previous toolbar In a workbook: activate next workbook None Excel 97/2000 + Edit, Goto, Special, Current Region AllĬtrl++ Insert Insert, (Rows, Columns, or Cells) Depends on selection AllĬtrl+- Delete Delete, (Rows, Columns, or Cells) Depends on selection AllĬtrl+1 Format cells dialog box Format, Cells AllĬtrl+2 Bold Format, Cells, Font, Font Style, Bold AllĬtrl+3 Italic Format, Cells, Font, Font Style, Italic AllĬtrl+4 Underline Format, Cells, Font, Font Style, Underline AllĬtrl+5 Strikethrough Format, Cells, Font, Effects, Strikethrough AllĬtrl+6 Show/Hide objects Tools, Options, View, Objects, Show All/Hide AllĬtrl+7 Show/Hide Standard toolbar View, Toolbars, Stardard AllĬtrl+0 Hide columns Format, Column, Hide AllĬtrl+Shift+( Unhide rows Format, Row, Unhide AllĬtrl+Shift+) Unhide columns Format, Column, Unhide All In a PivotTable report, select the entire PivotTable report. 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 Ctrl+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.
0 kommentar(er)
