Top Excel Hotkeys to Improve Your Productivity

Updated: Oct 25, 2021

Who doesn’t like shortcuts? When you have a long process to do to get a list, a little short cut can make things a little more convenient and can save a little time! Here I am listing a few general shortcuts in Excel that you can use.

Ctrl+N: Create a new workbook

Ctrl+O: Open an existing workbook

Ctrl+S: Save a workbook

F12: Open the Save As dialog box

Ctrl+W: Close a workbook

Ctrl+F4: Close Excel

F4: Repeat the last command or action.

Shift+F11: Insert a new worksheet

Ctrl+Z: Undo an action

Ctrl+Y: Redo an action

Ctrl+F2: Switch to Print Preview

F1: Open the Help pane

Alt+Q: Go to the “Tell me what you want to do” box

F7: Check spelling

F9: Calculate all worksheets in all open workbooks

Shift+F9: Calculate active worksheets

Alt or F10: Turn key tips on or off

Ctrl+F1: Show or hide the ribbon

Ctrl+Shift+U: Expand or collapse the formula bar

Ctrl+F9: Minimize the workbook window

F11: Create a bar chart based on selected data (on a separate sheet)

Alt+F1: Create an embedded bar chart based on select data (same sheet)

Ctrl+F: Search in a spreadsheet, or use Find and Replace

Alt+F: Open the File tab menu

Alt+H: Go to the Home tab

Alt+N: Open the Insert tab

Alt+P: Go to the Page Layout tab

Alt+M: Go to the Formulas tab

Alt+A: Go to the Data tab

Alt+R: Go to the Review tab

Alt+W: Go to the View tab

Alt+X: Go to the Add-ins tab

Alt+Y: Go to the Help tab

Ctrl+Tab: Switch between open workbooks

Shift+F3: Insert a function

Alt+F8: Create, run, edit, or delete a macro

Alt+F11: Open the Microsoft Visual Basic For Applications Editor

21 views0 comments

Recent Posts

See All