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)
