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)
