xcel shortcuts Shortcut key
Action
Menu equivalent comments None Format, Cells, Font, Font Style, Bold Edit, Copy Edit, Fill, Down Edit, Find Edit, Goto Edit, Replace Format, Cells, Font, Font Style, Italic
Ctrl+A
Select All
Ctrl+B
Bold
Ctrl+C Ctrl+D Ctrl+F Ctrl+G Ctrl+H
Copy Fill Down Find Goto Replace
Ctrl+I
Italic
Ctrl+K
Insert Hyperlink
Insert, Hyperlink
Ctrl+N Ctrl+O Ctrl+P Ctrl+R Ctrl+S
New Workbook Open Print Fill Right Save
Ctrl+U
Underline
Ctrl+V
Paste
File, New File, Open File, Print Edit, Fill Right File, Save Format, Cells, Font, Underline, Single Edit, Paste
Ctrl W
Close
File, Close
Ctrl+X Ctrl+Y Ctrl+Z
Cut Repeat Undo
F1
Help
F2 F3
Edit Paste Name
F4
Repeat last action
Edit, Cut Edit, Repeat Edit, Undo Help, Contents and Index None Insert, Name, Paste Edit, Repeat. Works while not in Edit mode.
F5 F6 F7 F8
While typing a formula, switch between absolute/relative refs Goto Next Pane Spell check Extend mode
F9
Recalculate all workbooks
F10 F11 F12 Ctrl+: Ctrl+;
Activate Menubar New Chart Save As Insert Current Time Insert Current Date
Ctrl+"
Copy Value from Cell Above
Ctrl+’
Copy Formula from Cell Above
F4
Shift Shift+F1 Shift+F2 Shift+F3 Shift+F4
version All All All All All All All All Excel 97/2000 + All All All All All All All Excel 97/2000 + All All All All All All All
None
All
Edit, Goto None Tools, Spelling None Tools, Options, Calculation, Calc Now N/A Insert, Chart File, Save As None None Edit, Paste Special, Value Edit, Copy
All All All All All All All All All All All All
All Excel Hold down shift for additional functions in Excel’s none 97/2000 menu + What’s This? Help, What’s This? This? All Edit cell comment Insert, Edit Comments All Paste function into formula Insert, Function All Find Next Edit, Find, Find Next All
Shift+F5 Shift+F6 Shift+F8
Find Previous Pane Add to selection
Shift+F9
Calculate active worksheet
Shift+F10 Shift+F11 Shift+F12 Ctrl+F3 Ctrl+F4 Ctrl+F5 Ctrl+F6 Shift+Ctrl+F6 Ctrl+F7 Ctrl+F8 Ctrl+F9 Ctrl+F10
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Display shortcut menu New worksheet Save Define name Close XL, Restore window size Next workbook window Previous workbook window Move window Resize window Minimize workbook Maximize or restore window
Ctrl+F11
Inset 4.0 Macro sheet
Ctrl+F12 Alt+F1 Alt+F2 Alt+F4
File Open Insert Chart Save As Exit
Alt+F8
Macro dialog box
Ctrl+Alt+F9
Ctrl+Alt+Shift+F9
Alt+F11
Visual Basic Editor
Ctrl+Shift+F6 Ctrl+Shift+F12 Alt+Shift+F1 Alt+Shift+F2 Alt+=
Create name by using names of row and column labels Previous Window Print New worksheet Save AutoSum
Ctrl+`
Toggle Value/Formula display
Ctrl+Shift+A Alt+Down arrow Alt+’
Insert argument names into formula Display AutoComplete list Format Style dialog box
Ctrl+Shift+~
General format
Ctrl+Shift+!
Comma format
Ctrl+Shift+@
Time format
Ctrl+Shift+#
Date format
Ctrl+Shift+$
Currency format
Ctrl+Shift+F3
Edit, Find, Find Next None None Tools, Options, Calculation, Calc Sheet None
None None Insert, Worksheet File, Save Insert, Names, Define File, Close Restore Window, ... Window, ... XL, Move XL, Size XL, Minimize XL, Maximize None in Excel 97. In versions prior to 97 Insert, Macro, 4.0 Macro File, Open Insert, Chart... File, Save As File, Exit Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
All All All All Excel 97/2000 + Excel 97/2000 + All All All All All All All All All All All All All All All All All All Excel 97/2000 +
Tools, Macro, Visual Basic Editor
Excel 97/2000 +
Insert, Name, Create
All
Window, ... File, Print Insert, Worksheet File, Save No direct equivalent Tools, Options, View, Formulas No direct equivalent None Format, Style Format, Cells, Number, Category, General Format, Cells, Number, Category, Number Format, Cells, Number, Category, Time Format, Cells, Number, Category, Date Format, Cells, Number, Category, Currency
All All All All All All All Excel 95 All All All All All All
Format, Cells, Number, Category, Percentage Format, Cells, Number, Category, Format, Cells, Border Format, Cells, Border
Ctrl+Shift+%
Percent format
Ctrl+Shift+^
Exponential format
Ctrl+Shift+& Ctrl+Shift+_
Place outline border around selected cells All Remove outline border All Select the current region around the active cell. In a Edit, Goto, Special, PivotTable report, select the entire PivotTable All Current Region report. Insert, (Rows, Columns, Insert or Cells) Depends on All selection Delete, (Rows, Delete Columns, or Cells) All Depends on selection Format cells dialog box Format, Cells All Format, Cells, Font, Bold All Font Style, Bold Format, Cells, Font, Italic All Font Style, Italic Format, Cells, Font, Underline All Font Style, Underline Format, Cells, Font, Strikethrough All Effects, Strikethrough Tools, Options, View, Show/Hide objects All Objects, Show All/Hide View, Toolbars, Show/Hide Standard toolbar All Stardard Toggle Outline symbols None All Hide rows Format, Row, Hide All Hide columns Format, Column, Hide All Unhide rows Format, Row, Unhide All Format, Column, Unhide columns All Unhide Activate the menu None All Excel In toolbar: next toolbar None 97/2000 In a workbook: activate next workbook + Excel In toolbar: previous toolbar None 97/2000 In a workbook: activate previous workbook + Excel Next tool None 97/2000 + Excel Previous tool None 97/2000 + Excel Do the command None 97/2000 + Excel Start a new line in the same cell. None 97/2000 + Excel Fill the selected cell range with the current entry. None 97/2000 + Font Drop Down List Format, Cells, Font All Before Font tab of Format Cell Dialog box Format, Cells, Font 97/2000 Point size Drop Down List Format, Cells, Font All
Ctrl+Shift+*
Ctrl++
Ctrl+Ctrl+1 Ctrl+2 Ctrl+3 Ctrl+4 Ctrl+5 Ctrl+6 Ctrl+7 Ctrl+8 Ctrl+9 Ctrl+0 Ctrl+Shift+( Ctrl+Shift+) Alt or F10 Ctrl+Tab
Shift+Ctrl+Tab
Tab
Shift+Tab
Enter
Alt+Enter
Ctrl+Enter Shift+Ctrl+F Shift+Ctrl+F+F Shift+Ctrl+P
All All
Ctrl+Spacebar
Select the entire column
None
Shift+Spacebar
Select the entire row
None
Select the array containing the active cell. Select all cells that contain comments. In a selected row, select the cells that don’t match CTRL+\ the formula or static value in the active cell. In a selected column, select the cells that don’t CTRL+SHIFT+| match the formula or static value in the active cell. Select all cells directly referenced by formulas in CTRL+[ the selection. Select all cells directly or indirectly referenced by CTRL+SHIFT+{ formulas in the selection. Select cells that contain formulas that directly CTRL+] reference the active cell. Select cells that contain formulas that directly or CTRL+SHIFT+} indirectly reference the active cell. Select the visible cells in the current selection. ALT+; With multiple cells selected, select only the active SHIFT+BACKSPACE cell. Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time CTRL+SHIFT+SPACEBAR selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet Reapply the filter and sort on the current range so Data, Reapply Ctrl+Alt+L that changes you've made are included Displays the Paste Special dialog box. Available Home, Paste, only after you have cut or copied an object, text, or Ctrl+Alt+V Paste Special... cell contents on a worksheet or in another program. Shortcut key Action Menu equivalent comments Select All None Ctrl+A Format, Cells, Font, Font Bold Ctrl+B Style, Bold Copy Edit, Copy Ctrl+C Fill Down Edit, Fill, Down Ctrl+D Find Edit, Find Ctrl+F Goto Edit, Goto Ctrl+G Replace Edit, Replace Ctrl+H Format, Cells, Font, Font Italic Ctrl+I Style, Italic
Excel 97/2000 + Excel 97/2000 +
CTRL+/ CTRL+SHIFT+O
Ctrl+K
Insert Hyperlink
Insert, Hyperlink
Ctrl+N Ctrl+O Ctrl+P Ctrl+R Ctrl+S
New Workbook Open Print Fill Right Save
Ctrl+U
Underline
Ctrl+V
Paste
File, New File, Open File, Print Edit, Fill Right File, Save Format, Cells, Font, Underline, Single Edit, Paste
Ctrl W
Close
File, Close
Ctrl+X
Cut
Edit, Cut
Excel 2007+ Excel 2007+ version All All All All All All All All Excel 97/2000 + All All All All All All All Excel 97/2000 + All
Ctrl+Y Ctrl+Z F1 F2 F3
Repeat Undo Help Edit Paste Name
F4
Repeat last action
F5 F6 F7 F8
While typing a formula, switch between absolute/relative refs Goto Next Pane Spell check Extend mode
F9
Recalculate all workbooks
F10 F11 F12 Ctrl+: Ctrl+; Ctrl+" Ctrl+'
Shift+F1 Shift+F2 Shift+F3 Shift+F4 Shift+F5 Shift+F6 Shift+F8
Activate Menubar New Chart Save As Insert Current Time Insert Current Date Copy Value from Cell Above Copy Formula from Cell Above Hold down shift for additional functions in Excel's menu What's This? Edit cell comment Paste function into formula Find Next Find Previous Pane Add to selection
Shift+F9
Calculate active worksheet
F4
Shift
Edit, Repeat Edit, Undo Help, Contents and Index None Insert, Name, Paste Edit, Repeat. Works while not in Edit mode.
All All All All All All
None
All
Edit, Goto None Tools, Spelling None Tools, Options, Calculation, Calc Now N/A Insert, Chart File, Save As None None Edit, Paste Special, Value Edit, Copy
All All All All
none Help, What's This? Insert, Edit Comments Insert, Function Edit, Find, Find Next Edit, Find, Find Next None None Tools, Options, Calculation, Calc Sheet
All All All All All All All All Excel 97/2000 + All All All All All All All All
Calculate all worksheets in all open workbooks, Excel regardless of whether they have changed since the last None Ctrl+Alt+F9 97/2000 + calculation. Rechecks dependent formulas and then calculates all Excel None Ctrl+Alt+Shift+F9cells in all open workbooks, including cells not 97/2000 + marked as needing to be calculated. Display shortcut menu None All Shift+F10 New worksheet Insert, Worksheet All Shift+F11 Save File, Save All Shift+F12 Define name Insert, Names, Define All Ctrl+F3 Close File, Close All Ctrl+F4 XL, Restore window size Restore All Ctrl+F5 Next workbook window Window, ... All Ctrl+F6 Previous workbook window Window, ... All Shift+Ctrl+F6 Move window XL, Move All Ctrl+F7 Resize window XL, Size All Ctrl+F8 Minimize workbook XL, Minimize All Ctrl+F9 Maximize or restore window XL, Maximize All Ctrl+F10 None in Excel 97. In versions Inset 4.0 Macro sheet prior to 97 - Insert, Macr o, 4.0 All Ctrl+F11 Macro File Open File, Open All Ctrl+F12 Insert Chart Insert, Chart... All Alt+F1 Save As File, Save As All Alt+F2 Exit File, Exit All Alt+F4 Tools, Macro, Macros in Excel Excel Macro dialog box Alt+F8 97 Tools,Macros - in earlier 97/2000 +
versions Tools, Macro, Visual Basic Excel Visual Basic Editor Alt+F11 Editor 97/2000 + Create name by using names of row and column labels Insert, Name, Create All Ctrl+Shift+F3 Previous Window Window, ... All Ctrl+Shift+F6 File, Print All Ctrl+Shift+F12 Print New worksheet Insert, Worksheet All Alt+Shift+F1 Save File, Save All Alt+Shift+F2 AutoSum No direct equivalent All Alt+= Tools, Options, View, Toggle Value/Formula display All Ctrl+` Formulas Insert argument names into formula No direct equivalent All Ctrl+Shift+A None Excel 95 Alt+Down arrow Display AutoComplete list Format Style dialog box Format, Style All Alt+' Format, Cells, Number, General format All Ctrl+Shift+~ Category, General Format, Cells, Number, Comma format All Ctrl+Shift+! Category, Number Format, Cells, Number, Time format All Ctrl+Shift+@ Category, Time Format, Cells, Number, Date format All Ctrl+Shift+# Category, Date Format, Cells, Number, Currency format All Ctrl+Shift+$ Category, Currency Format, Cells, Number, Percent format All Ctrl+Shift+% Category, Percentage Format, Cells, Number, Exponential format All Ctrl+Shift+^ Category, Place outline border around selected cells Format, Cells, Border All Ctrl+Shift+& Remove outline border Format, Cells, Border All Ctrl+Shift+_ Edit, Goto, Special, Current Select current region All Ctrl+Shift+* Region Insert, (Rows, Columns, or Insert All Ctrl++ Cells) Depends on selection Delete, (Rows, Columns, or Delete All Ctrl+Cells) Depends on selection Format cells dialog box Format, Cells All Ctrl+1 Format, Cells, Font, Font Bold All Ctrl+2 Style, Bold Format, Cells, Font, Font Italic All Ctrl+3 Style, Italic Format, Cells, Font, Font Underline All Ctrl+4 Style, Underline Format, Cells, Font, Effects, Strikethrough All Ctrl+5 Strikethrough Tools, Options, View, Objects, Show/Hide objects All Ctrl+6 Show All/Hide Show/Hide Standard toolbar View, Toolbars, Stardard All Ctrl+7 Toggle Outline symbols None All Ctrl+8 Hide rows Format, Row, Hide All Ctrl+9 Hide columns Format, Column, Hide All Ctrl+0 Unhide rows Format, Row, Unhide All Ctrl+Shift+( Unhide columns Format, Column, Unhide All Ctrl+Shift+) Activate the menu None All Alt or F10 Excel In toolbar: next toolbar None Ctrl+Tab 97/2000 + Excel None Shift+Ctrl+Tab In toolbar: previous toolbar 97/2000 + Excel In a workbook: activate next workbook None Ctrl+Tab 97/2000 +
Shift+Ctrl+Tab
In a workbook: activate previous workbook
None
Tab
Next tool
None
Shift+Tab
Previous tool
None
Enter
Do the command
None
Alt+Enter
Start a new line in the same cell.
None
Ctrl+Enter
Fill the selected cell range with the current entry.
None
Shift+Ctrl+F
Font Drop Down List
Format, Cells, Font
Shift+Ctrl+F+F
Font tab of Format Cell Dialog box
Format, Cells, Font
Point size Drop Down List Format, Cells, Font Shift+Ctrl+P A special thanks goes out to Shane Devenshire who provided most of the shortcuts in this list!
Excel 97/2000 + Excel 97/2000 + Excel 97/2000 + Excel 97/2000 + Excel 97/2000 + Excel 97/2000 + All Before 97/2000 All
References:
Microsoft Office: Excel shortcut and function keys Microsoft Office Assistance: Work with the keyboard (with video)
back to top Shortcuts for the Visual Basic Editor Shortcut key F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 Shift+F2 Shift+F3 Shift+F7 Shift+F8 Shift+F9 Shift+F10 Ctrl+F2 Ctrl+F4 Ctrl+F8 Ctrl+F10 Alt+F4 Alt+F6 Alt+F11 Ctrl+Shift+F2 Ctrl+Shift+F8 Ctrl+Shift+F9 Insert Delete Home End Page Up
Action Help View Object Browser Find Next Properies Window Run Sub/Form or Run Macro Switch Split Windows View Code Window Step Into Toggle Breakpoint Activate Menu Bar View definition Find Previous View Object Step Over Quick Watch Show Right Click Menu Focus To Object Box Close Window Run To Cursor Activate Menu Bar Close VBE Switch Between Last 2 Windows Return To Application Go to last position Step Out Clear All Breakpoints Toggle Insert Mode Delete Move to beginning of line Move to end of line Page Up
Menu equivalent comments Help View, Object Browser View, Properties Window Run, Run Macro View, Code Debug, Step Into Debug, Toggle Breakpoint View, Definition View, Object Debug, Step Over Debug, Quick Watch
Debug, Run To Cursor File, Close and Return to Microsoft Excel
View, Last Position Debug, Step Out Debug, Clear All Breakpoints Edit, Clear
Page Down Left Arrow Right Arrow Up Arrow Down Arrow Tab Enter BackSpace Shift+Insert Shift+Home Shift+End Shift+Page Up Shift+Page Down Shift+Left Arrow Shift+Right Arrow Shift+Up Arrow Shift+Down Arrow Shift+Tab Alt+Spacebar Alt+Tab Alt+BackSpace Ctrl+A Ctrl+C Ctrl+E Ctrl+F Ctrl+G Ctrl+H Ctrl+I Ctrl+J Ctrl+L Ctrl+M Ctrl+N Ctrl+P Ctrl+R Ctrl+S Ctrl+T Ctrl+V Ctrl+X Ctrl+Y Ctrl+Z Ctrl+Insert Ctrl+Delete Ctrl+Home Ctrl+End Ctrl+Page Up Ctrl+Page Down Ctrl+Left Arrow Ctrl+Right Arrow Ctrl+Up Arrow Ctrl+Down Arrow Ctrl+Spacebar Ctrl+Tab Ctrl+BackSpace Ctrl+Shift+I Ctrl+Shift+J
Page Down Left Right Up Down Indent New Line Delete Prev Char Paste Select To Start Of Line Select To End Of Line Select To Top Of Module Select To End Of Module Extend Selection Left 1 Char Extend Selection Right 1 Char Extend Selection Up Extend Selection Down Outdent System Menu Cycle Applications Undo Select All Copy Export Module Find Immediate Window Replace Turn On Quick Info List Properties/Methods Show Call Stack Import File New Line Print Project Explorer Save Show Available Components Paste Cut Cut Entire Line Undo Copy Delete To End Of Word Top Of Module End Of Module Top Of Current Procedure End Of Current Procedure Move one word to left Move one word to right Previous Procedure Next Procedure Complete Word Cycle Windows Delete To Start Of Word Parameter Info List Constants
Edit, Indent
Edit, Paste
Edit, Outdent
Edit, Select All Edit, Copy File, Export File Edit, Find… View, Immediate Window Edit, Replace… Edit, Quikc Info Edit, List Properties/Methods File, Import File File, Print View, Project Explorer File, Save Insert, Components... Edit, Paste Edit, Cut Edit, Undo Edit, Copy
Edit, Complete Word
Edit, Parameter Info Edit, List Constants
