This list gives you a glance of (nearly) all shortcut combinations in Excel. Please take the time to read it. I'm sure you'll find many of them useful. There is also a list of the . Excel shortcuts Shortcut key Action Menu equivalent comments Ctrl+A Select All None All Ctrl+B Bold Format, 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 Goto Edit, Goto All Ctrl+H Replace Edit, Replace All Ctrl+I Italic Format, Cells, Font, Font Style, Italic All Ctrl+K Insert Hyperlink Insert, Hyperlink 97 on
Ctrl+’ Copy Formula from Cell Above Edit, Copy All Hold down shift for additional functions in Excel’s menu none + Shift+F1 What’s This? Help, What’s This? All Shift+F2 Edit cell comment Insert, Edit Comments All Shift+F3 function into formula Insert, Function All Find Next Edit, Find, Find Next All Find Edit, Find, Find Next All Shift+F6 Previous Pane None All Add to selection None All Shift+F9 Calculate active worksheet Tools, Options, Calculation, Calc Sheet All Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. None 97 97
Print File, Print All New worksheet Insert, Worksheet All Save File, Save All Alt+= AutoSum No direct equivalent All Ctrl+` Toggle display Tools, Options, View, Formulas All Insert argument names into formula No direct equivalent All Alt+Down arrow Display AutoComplete list None 95 Alt+’ Format Style dialog box Format, Style All General format Format, Cells, Number, Category, General All Comma format Format, Cells, Number, Category, Number All
Time format Format, Cells, Number, Category, Time All Date format Format, Cells, Number, Category, Date All Currency format Format, Cells, Number, Category, Currency All Percent format Format, Cells, Number, Category, Percentage All Exponential format Format, Cells, Number, Category, All Place outline border around selected cells Format, Cells, Border All Remove outline border Format, Cells, Border All Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. Edit, Goto, Special, Current Region All Ctrl++ Insert Insert, (Rows, All
Columns, or Depends selection Ctrl+- Delete Delete, (Rows, Columns, or Cells) Depends on selection All Ctrl+1 Format cells dialog box Format, Cells All Ctrl+2 Bold Format, Font, Font Style, Bold All Ctrl+3 Italic Format, Cells, Font, Font Style, Italic All Ctrl+4 Underline Format, Cells, Font, Font Style, Underline All Ctrl+5 Strikethrough Format, Font, Effects, All Ctrl+6 Show/Hide objects Tools, Options, View, Objects, Show All/Hide All
Ctrl+7 Show/Hide Standard toolbar View, Toolbars, Stardard All Ctrl+8 Toggle Outline symbols None All Ctrl+9 Hide rows Format, Row, Hide All Ctrl+0 Hide columns Format, Column, Hide All Unhide rows Format, Row, Unhide All Unhide columns Format, Column, Unhide All Alt or F10 Activate the menu None All Ctrl+Tab In toolbar: next toolbar In a workbook: activate next workbook None + In toolbar: previous toolbar In a workbook: activate previous workbook None + Tab Next tool None
File, Print All New worksheet Insert, Worksheet All Save File, Save All Alt+= AutoSum No direct equivalent All Ctrl+` Toggle Value/Formula display Options, View, Formulas All Insert argument into formula No direct equivalent All Alt+Down arrow Display AutoComplete list None Excel 95 Alt+' Format dialog box Format, Style All General format Format, Cells, Number, Category, General All Comma format Format, Cells, Number, Category, Number All Time format Format, Number, Category, Time All Date format Format, Cells, Number, Category, Date All 1 A
Currency format Format, Cells, Number, Category, Currency All Percent format Format, Cells, Number, Category, Percentage All Exponential format Format, Cells, Number, Category, All outline border around selected cells Format, Cells, Border All Remove outline border Format, Cells, Border All Select current region Edit, Goto, 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 dialog box Format, Cells All Ctrl+2 Bold Format, Cells, Font, Font Style, Bold All Ctrl+3 Italic Format, Cells, Font, Font Style, Italic All Ctrl+4 Underline Format, Cells, Font, Font Style, Underline All
Shift+Insert Edit, 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 Char Shift+Up Arrow Extend Selection Up Shift+Down Arrow Extend Selection Down Outdent Edit, Outdent Alt+Spacebar System Menu Alt+Tab Applications Undo Ctrl+A Select All Edit, Select All Ctrl+C Copy Edit, Copy Ctrl+E Export Module File, Export File Ctrl+F Find Edit, Find…
ctrl+shift+v formatting only ctrl+z Undo the last action. ctrl+y Redo the last action. ctrl+shift+g Open the Word Count dialog box. ▲ up 2. Working with documents: Create, view, and save documents ctrl+n Create a new document of the same type as the current or most recent ctrl+o Open a document. ctrl+w Close a document. alt+ctrl+s Split the document window. alt+shift+c Remove the document window ctrl+s Save a document. ctrl+n Create a new document of the same type as the current or most recent ctrl+o Open a document. ctrl+w Close a document. alt+ctrl+s Split the document window. Remove the document window split. ctrl+s Save a document. ctrl+n Create a new document of the same type as the current or most recent ctrl+o Open a document. ctrl+w Close a document. alt+ctrl+s Split the document window. alt+shift+c Remove the document window split. ctrl+s Save a document. ▲ up 3. Working with documents: Find, replace, and browse through text ctrl+f Find text, formatting, and special items. alt+ctrl+y Repeat find (after closing Find and Replace window). ctrl+h Replace text, specific formatting, and special items. ctrl+g Go to a page, bookmark, footnote, table, comment, graphic, or other