Microsoft Excel Shortcut Keys

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