A-Z of Excel Shortcut keys

V1.1120815 Shortcut key Action Ctrl+A Select All Ctrl+B Bold Ctrl+C Copy Ctrl+D Fill Down Ctrl+F Find Ctrl+G Goto Ctrl+H Replace Ctrl+I Italic Ctrl+K Insert Hyperlink Ctrl+N New Workbook Ctrl+O Open Ctrl+P Print Ctrl+R Fill Right Ctrl+S Save Ctrl+U Underline Ctrl+V Paste Ctrl W Close Ctrl+X Cut Ctrl+Y Repeat Ctrl+Z Undo F1 Help F2 Edit F3 Paste Name F4 Repeat last action F4 While typing a formula, switch between absolute/relative refs F5 Goto F6 Next Pane F7 Spell check F8 Extend mode F9 Recalculate all workbooks F10 Activate Menubar F11 New Chart F12 Save As Ctrl+: Insert Current Time Ctrl+; Insert Current Date Ctrl+\" Copy Value from Cell Above Ctrl+’ Copy Formula from Cell Above Shift Hold down shift for additional functions in Excel’s menu Shift+F1 What’s This? Shift+F2 Edit cell comment Shift+F3 Paste function into formula Shift+F4 Find Next Shift+F5 Find Shift+F6 Previous Pane Shift+F8 Add to selection Shift+F9 Calculate active worksheet

Shortcut key Action Ctrl+Alt+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since Ctrl+Alt+Shift+F9 the last calculation. Rechecks dependent formulas and then Shift+F10 calculates all cells in all open workbooks, Shift+F11 including cells not marked as needing to be Shift+F12 calculated. Ctrl+F3 Display shortcut menu Ctrl+F4 New worksheet Ctrl+F5 Save Ctrl+F6 Define name Shift+Ctrl+F6 Close Ctrl+F7 XL, Restore window size Ctrl+F8 Next workbook window Ctrl+F9 Previous workbook window Ctrl+F10 Move window Ctrl+F11 Resize window Ctrl+F12 Minimize workbook Alt+F1 Maximize or restore window Alt+F2 Inset 4.0 Macro sheet Alt+F4 File Open Alt+F8 Insert Chart Alt+F11 Save As Ctrl+Shift+F3 Exit Macro dialog box Ctrl+Shift+F6 Visual Basic Editor Ctrl+Shift+F12 Create name by using names of row and column Alt+Shift+F1 labels Alt+Shift+F2 Previous Window Alt+= Print Ctrl+` New worksheet Ctrl+Shift+A Save Alt+Down arrow AutoSum Alt+’ Toggle Value/Formula display Ctrl+Shift+~ Insert argument names into formula Ctrl+Shift+! Display AutoComplete list Ctrl+Shift+@ 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+_ Percent format Ctrl+Shift+* Exponential format Place outline border around selected cells Ctrl++ Remove outline border Ctrl+- Select the current region around the active cell. Ctrl+1 In a PivotTable report, select the entire Ctrl+2 PivotTable report. Ctrl+3 Insert Ctrl+4 Delete Format cells dialog box Bold Italic Underline

Shortcut key Action Ctrl+5 Strikethrough Ctrl+6 Show/Hide objects Ctrl+7 Show/Hide Standard toolbar Ctrl+8 Toggle Outline symbols Ctrl+9 Hide rows Ctrl+0 Hide columns Ctrl+Shift+( Unhide rows Ctrl+Shift+) Unhide columns Alt or F10 Activate the menu Ctrl+Tab In toolbar: next toolbar In a workbook: activate next workbook Shift+Ctrl+Tab In toolbar: previous toolbar In a workbook: activate previous workbook Tab Next tool Shift+Tab Previous tool Enter Do the command Alt+Enter Start a new line in the same cell. Ctrl+Enter Fill the selected cell range with the current entry. Shift+Ctrl+F Font Drop Down List Shift+Ctrl+F+F Font tab of Format Cell Dialog box Shift+Ctrl+P Point size Drop Down List Ctrl+Spacebar Select the entire column Shift+Spacebar Select the entire row CTRL+/ Select the array containing the active cell. CTRL+SHIFT+O Select all cells that contain comments. CTRL+\\ In a selected row, select the cells that don’t match the formula or static value in the active CTRL+SHIFT+| cell. In a selected column, select the cells that don’t CTRL+[ match the formula or static value in the active cell. CTRL+SHIFT+{ Select all cells directly referenced by formulas in the selection. CTRL+] Select all cells directly or indirectly referenced by formulas in the selection. CTRL+SHIFT+} Select cells that contain formulas that directly reference the active cell. ALT+; Select cells that contain formulas that directly SHIFT+BACKSPACE or indirectly reference the active cell. Select the visible cells in the current selection. CTRL+SHIFT+SPACEBAR With multiple cells selected, select only the active cell. Ctrl+A Selects the entire worksheet. If the worksheet Ctrl+B contains data, CTRL+SHIFT+SPACEBAR selects Ctrl+C the current region. Pressing Ctrl+D CTRL+SHIFT+SPACEBAR a second time selects Ctrl+F the entire worksheet. When an object is Ctrl+G selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet Select All Bold Copy Fill Down Find Goto

Shortcut key Action Ctrl+H Replace Ctrl+I Italic Ctrl+K Insert Hyperlink Ctrl+N New Workbook Ctrl+O Open Ctrl+P Print Ctrl+R Fill Right Ctrl+S Save Ctrl+U Underline Ctrl+V Paste Ctrl W Close Ctrl+X Cut Ctrl+Y Repeat Ctrl+Z Undo F1 Help F2 Edit F3 Paste Name F4 Repeat last action F4 While typing a formula, switch between absolute/relative refs F5 Goto F6 Next Pane F7 Spell check F8 Extend mode F9 Recalculate all workbooks F10 Activate Menubar F11 New Chart F12 Save As Ctrl+: Insert Current Time Ctrl+; Insert Current Date Ctrl+\" Copy Value from Cell Above Ctrl+' Copy Formula from Cell Above Shift Hold down shift for additional functions in Excel's menu Shift+F1 What's This? Shift+F2 Edit cell comment Shift+F3 Paste function into formula Shift+F4 Find Next Shift+F5 Find Shift+F6 Previous Pane Shift+F8 Add to selection Shift+F9 Calculate active worksheet Ctrl+Alt+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since Ctrl+Alt+Shift+F9 the last calculation. Rechecks dependent formulas and then Shift+F10 calculates all cells in all open workbooks, Shift+F11 including cells not marked as needing to be Shift+F12 calculated. Ctrl+F3 Display shortcut menu Ctrl+F4 New worksheet Ctrl+F5 Save Define name Close XL, Restore window size

Shortcut key Action Ctrl+F6 Next workbook window Shift+Ctrl+F6 Previous workbook window Ctrl+F7 Move window Ctrl+F8 Resize window Ctrl+F9 Minimize workbook Ctrl+F10 Maximize or restore window Ctrl+F11 Inset 4.0 Macro sheet Ctrl+F12 File Open Alt+F1 Insert Chart Alt+F2 Save As Alt+F4 Exit Alt+F8 Macro dialog box Alt+F11 Visual Basic Editor Ctrl+Shift+F3 Create name by using names of row and column labels Ctrl+Shift+F6 Previous Window Ctrl+Shift+F12 Print Alt+Shift+F1 New worksheet Alt+Shift+F2 Save Alt+= AutoSum Ctrl+` Toggle Value/Formula display Ctrl+Shift+A Insert argument names into formula Alt+Down arrow Display AutoComplete list Alt+' 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+% Percent format Ctrl+Shift+^ Exponential format Ctrl+Shift+& Place outline border around selected cells Ctrl+Shift+_ Remove outline border Ctrl+Shift+* Select current region Ctrl++ Insert Ctrl+- Delete Ctrl+1 Format Cells dialog box Ctrl+2 Bold Ctrl+3 Italic Ctrl+4 Underline Ctrl+5 Strikethrough Ctrl+6 Show/Hide objects Ctrl+7 Show/Hide Standard Toolbar Ctrl+8 Toggle Outline symbols Ctrl+9 Hide rows Ctrl+0 Hide columns Ctrl+Shift+( Unhide rows Ctrl+Shift+) Unhide Columns Alt or F10 Activate the menu Ctrl+Tab In toolbar: next toolbar Shift+Ctrl+Tab In toolbar: previous toolbar Ctrl+Tab In a workbook: activate next workbook Shift+Ctrl+Tab In a workbook: activate previous workbook Tab Next tool Shift+Tab Previous tool

Shortcut key Action Enter Do the command Alt+Enter Start a new line in the same cell. Ctrl+Enter Fill the selected cell range with the current entry. Shift+Ctrl+F Font Drop Down List Shift+Ctrl+F+F Font tab of Format Cell Dialog box Shift+Ctrl+P Point Size Drop Down List Shortcuts for the Visual Basic Editor Shortcut key Action F1 Help F2 View Object Browser F3 Find Next F4 Properties Window F5 Run Sub/Form or Run Macro F6 Switch Split Windows F7 View Code Window F8 Step Into F9 Toggle Breakpoint F10 Activate Menu Bar Shift+F2 View Definition Shift+F3 Find Previous Shift+F7 View Object Shift+F8 Step Over Shift+F9 Quick Watch Shift+F10 Show Right Click Menu Ctrl+F2 Focus To Object Box Ctrl+F4 Close Window Ctrl+F8 Run To Cursor Ctrl+F10 Activate Menu Bar Alt+F4 Close VBE Alt+F6 Switch Between Last 2 Windows Alt+F11 Return To Application Ctrl+Shift+F2 Go to last position Ctrl+Shift+F8 Step Out Ctrl+Shift+F9 Clear All Breakpoints Insert Toggle Insert Mode Delete Delete Home Move to beginning of line End Move to end of line Page Up Page Up Page Down Page Down Left Arrow Left Right Arrow Right Up Arrow Up Down Arrow Down Tab Indent Enter New Line BackSpace Delete Prev Char Shift+Insert Paste Shift+Home Select To Start Of Line Shift+End Select To End Of Line Shift+Page Up Select To Top Of Module Shift+Page Down Select To End Of Module

Shift+Left Arrow Extend Selection Left 1 Char Shift+Right Arrow Extend Selection Right 1 Char Shift+Up Arrow Extend Selection Up Shift+Down Arrow Extend Selection Down Shift+Tab Outdent Alt+Spacebar System Menu Alt+Tab Cycle Applications Alt+BackSpace Undo Ctrl+A Select All Ctrl+C Copy Ctrl+E Export Module Ctrl+F Find Ctrl+G Immediate Window Ctrl+H Replace Ctrl+I Turn On Quick Info Ctrl+J List Properties/Methods Ctrl+L Show Call Stack Ctrl+M Import File Ctrl+N New Line Ctrl+P Print Ctrl+R Project Explorer Ctrl+S Save Ctrl+T Show Available Components Ctrl+V Paste Ctrl+X Cut Ctrl+Y Cut Entire Line Ctrl+Z Undo Ctrl+Insert Copy Ctrl+Delete Delete To End Of Word Ctrl+Home Top Of Module Ctrl+End End Of Module Ctrl+Page Up Top Of Current Procedure Ctrl+Page Down End Of Current Procedure Ctrl+Left Arrow Move one word to left Ctrl+Right Arrow Move one word to right Ctrl+Up Arrow Previous Procedure Ctrl+Down Arrow Next Procedure Ctrl+Spacebar Complete Word Ctrl+Tab Cycle Windows Ctrl+BackSpace Delete To Start Of Word Ctrl+Shift+I Parameter Info Ctrl+Shift+J List Constants psalltraining.com │ [email protected] │020 3696 2796