Action Menu equivalent comments Version
Ctrl+A - Select All None All
Ctrl+B - Bold Format, Cells, Font, Font Style, Bold All
Ctrl+C - Copy Edit, Copy All
Ctrl+D - Fill down Edit, Fill, Down All
Ctrl+F - Find Edit, Find All
Ctrl+G - Go to Edit, Go to All
Ctrl+H - Replace Edit, Replace All
Ctrl+I - Italic Format, Cells, Font, Font Style, Italic All
Ctrl+K - Insert Hyperlink Insert, Hyperlink Excel 97/2000
Ctrl+N - New Workbook File, New All
Ctrl+O - Open File, Open All
Ctrl+P - Print File, Print All
Ctrl+R - Fill Right Edit, Fill Right All
Ctrl+S - save File, Save All
Ctrl+U - Underline Format, Cells, Font, Underline, Single All
Ctrl+V - Paste Edit, Paste All
Ctrl W - Close File, Close Excel 97/2000
Ctrl+X - Cut Edit, Cut All
Ctrl+Y - Repeat Edit, Repeat All
Ctrl+Z - Undo Edit, Undo All
F1 - Help Help, Contents and Index All
F2 - Edit None All
F3 - Paste Name Insert, Name, Paste All
F4 - Repeat last action Edit, Repeat. Works while not in Edit mode. All
F4 - While typing a formula, switch between absolute/relative refs None All
F5 - Go to Edit, Go to All
F6 - Next Pane None All
F7 - Spell check Tools, Spelling All
F8 - Extend mode None All
F9 - Recalculate all workbooks Tools, Options, Calculation, Calc,Now All
F10 - Activate Menu bar N/A All
F11 - New Chart Insert, Chart All
F12 - Save As File, Save As All
Ctrl+: - Insert Current Time None All
Ctrl+; - Insert Current Date None All
Ctrl+" - Copy Value from Cell above Edit, Paste Special, Value All
Ctrl+' - Copy Formula from Cell above Edit, Copy All
Shift - Hold down shift for additional functions in Excel's menu none Excel 97/2000
Shift+F1 - What's This? Help, What's This? All
Shift+F2 - Edit cell comment Insert, Edit Comments All
Shift+F3 - Paste function into formula Insert, Function All
Shift+F4 - Find Next Edit, Find, Find Next All
Shift+F5 - Find Edit, Find, Find Next All
Shift+F6 - Previous Pane None All
Shift+F8 - Add to selection None All
Shift+F9 - Calculate active worksheet Calc Sheet All
Shift+F10 - Display shortcut menu None All
Shift+F11 - New worksheet Insert, Worksheet All
Shift+F12 - save File, Save All
Ctrl+F3 - Define name Insert, Names, Define All
Ctrl+F4 - Close File, Close All
Ctrl+F5 - XL, Restore window size Restore All
Ctrl+F6 - Next workbook window Window ... All
Shift+Ctrl+F6 - Previous workbook window Window ... All
Ctrl+F7 - Move window XL, Move All
Ctrl+F8 - Resize window XL, Size All
Ctrl+F9 - Minimize workbook XL, Minimize All
Ctrl+F10 - Maximize or restore window XL, Maximize All
Ctrl+F11 - Inset 4.0 Macro sheet none in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro All
Ctrl+F12 - File Open File, Open All
Alt+F1 - Insert Chart Insert, Chart... All
Alt+F2 - Save As File, Save As All
Alt+F4 - Exit File, Exit All
Alt+F8 - Macro dialog box Tools, Macro, Macros in Excel 97 Tools, Macros - in earlier versions Excel 97/2000
Alt+F11 - Visual Basic Editor Tools, Macro, Visual Basic Editor Excel 97/2000
Ctrl+Shift+F3 - Create name by using names of row and column labels Insert, Name, Create All
Ctrl+Shift+F6 - Previous Window Window ... All
Ctrl+Shift+F12 - Print File, Print All
Alt+Shift+F1 - New worksheet Insert, Worksheet All
Alt+Shift+F2 - Save File, Save All
Alt+= - AutoSum No direct equivalent All
Ctrl+` - Toggle Value/Formula display Tools, Options, View, Formulas All
Ctrl+Shift+A - Insert argument names into formula No direct equivalent All
Alt+Down arrow - Display AutoComplete list None Excel 95
Alt+' - Format Style dialog box Format, Style All
Ctrl+Shift+~ - General format Format, Cells, Number, Category, General All
Ctrl+Shift+! - Comma format Format, Cells, Number, Category, Number All
Ctrl+Shift+@ - Time format Format, Cells, Number, Category, and Time All
Ctrl+Shift+# - Date format Format, Cells, Number, Category, and Date All
Ctrl+Shift+$ - Currency format Format, Cells, Number, Category, Currency All
Ctrl+Shift+% - Percent format Format, Cells, Number, Category, and Percentage All
Ctrl+Shift+^ - Exponential format Format, Cells, Number, Category, All
Ctrl+Shift+& - Place outline border around selected cells Format, Cells, Border All
Ctrl+Shift+_ - Remove outline border Format, Cells, and Border All
Ctrl+Shift+* - Select current region Edit, Go to, Special, Current Region All
Ctrl++ - Insert Insert, (Rows, Columns, or Cells) Depends on selection All
Ctrl+- - Delete Delete, (Rows, Columns, or Cells) Depends on selection All
Ctrl+1 - Format cells dialog box Format, Cells All
Ctrl+2 - Bold Formats, Cells, Font, Font Style, Bold All
Ctrl+3 - Italic Formats, Cells, Font, Font Style, Italic All
Ctrl+4 - Underline Format, Cells, Font, Font Style, Underline All
Ctrl+5 - Strikethrough Format, Cells, Font, Effects, Strikethrough All
Ctrl+6 - Show/Hide objects Tools, Options, View, Objects, Show All/Hide All
Ctrl+7 - Show/Hide Standard toolbar View, Toolbars, Standard All
Ctrl+8 - Toggle Outline symbols None All
Ctrl+9 - Hide rows Format, Row, Hide All
Ctrl+0 - Hide columns Format, Column, Hide All
Ctrl+Shift+( - Unhide rows Format, Row, Unhide All
Ctrl+Shift+) - Unhide columns Format, Column, Unhide All
Alt or F10 - Activate the menu None All
Ctrl+Tab - In toolbar: next toolbar None Excel 97/2000
Shift+Ctrl+Tab - In toolbar: previous toolbar None Excel 97/2000
Ctrl+Tab - In a workbook: activate next workbook none
No comments:
Post a Comment