Excel shortcuts

Excel shortcut keys 2016: The ultimate list

If you're an Excel power user, you know that shortcut keys can save you a ton of time. And with the release of Excel 2016, there are even more shortcut keys to learn!

In this article, we'll share with you the ultimate list of Excel shortcut keys for 2016. We'll also show you how to create your own custom shortcut keys.

So without further ado, here are the shortcut keys you need to know for Excel 2016:

  • Ctrl + N: Create a new workbook
  • Ctrl + O: Open an existing workbook
  • Ctrl + S: Save the active workbook
  • Ctrl + F: Open the Find dialog box
  • Ctrl + H: Open the Replace dialog box
  • Ctrl + G: Open the Go To dialog box
  • F11: Create a chart of the active data
  • Alt + F1: Insert a new chart sheet
  • Ctrl + `: Display the Formula bar
  • Ctrl + Shift + F3: Insert a function
  • Shift + F3: Open the Insert Function dialog box
  • F3: Open the Paste Name dialog box
  • F4: Repeat the last action
  • Ctrl + Z: Undo the last action
  • Ctrl + Y: Redo the last action
  • Ctrl + F2: Print the active sheet
  • Ctrl + P: Open the Print dialog box
  • Alt + F8: Open the Macro dialog box
  • Alt + F11: Open the Visual Basic Editor
  • Ctrl + Break: Stop the macro
  • Ctrl + Shift + F6: Switch to the next open workbook
  • Ctrl + F6: Switch to the previous open workbook
  • Alt + F9: Calculate all worksheets in all open workbooks
  • Alt + F10: Maximize or restore the workbook window
  • Alt + F5: Refresh the data
  • F5: Go to a specific cell
  • Ctrl + F5: Restore the window size
  • Shift + F5: Open the Find and Replace dialog box
  • Ctrl + A: Select all cells
  • Ctrl + B: Bold the selected text
  • Ctrl + I: Italicize the selected text
  • Ctrl + U: Underline the selected text
  • Ctrl + 5: Strikethrough the selected text
  • Ctrl + C: Copy the selected cells
  • Ctrl + X: Cut the selected cells
  • Ctrl + V: Paste the copied cells
  • Ctrl + F4: Close the active workbook
  • Ctrl + F7: Move the window
  • Ctrl + F8: Resize the window
  • Ctrl + F9: Minimize the workbook window
  • Ctrl + F10: Maximize the workbook window
  • Ctrl + F11: Insert a new worksheet
  • Ctrl + F12: Open the Save As dialog box
  • Shift + F12: Save the active workbook
  • Alt + F12: Open the Open dialog box
  • Ctrl + Shift + F12: Print the active workbook
  • Shift + F11: Insert a new worksheet
  • F12: Save the active workbook
  • Ctrl + Shift + F1: Insert a hyperlink
  • Ctrl + F1: Display or hide the Ribbon
  • Alt + F1: Insert a chart
  • Shift + F1: Display the Microsoft Excel Help task pane
  • Ctrl + Shift + F2: Create a new workbook
  • Ctrl + F2: Print the selection
  • Shift + F2: Edit the cell comment
  • Ctrl + Shift + F3: Create a name by using the Create Names from Selection dialog box
  • Ctrl + F3: Open the Name Manager dialog box
  • Shift + F3: Insert a function
  • F3: Paste a name
  • Shift + F4: Find the next instance of the value or text you specify
  • Ctrl + F4: Close the active workbook
  • Ctrl + Shift + F4: Find the previous instance of the value or text you specify
  • Ctrl + F5: Restore the active workbook
  • F5: Go to a specific cell
  • Ctrl + Shift + F5: Refresh the data
  • F6: Switch to the next pane
  • Ctrl + F6: Switch to the previous pane
  • Shift + F6: Switch to the next workbook or window
  • Ctrl + Shift + F7: Extend the selection by using the arrow keys
  • F7: Extend the selection by using the arrow keys
  • Shift + F8: Add to the selection
  • Ctrl + Shift + F8: Subtract from the selection
  • F8: Extend the selection
  • Ctrl + Shift + F9: Update the selected cells
  • F9: Calculate all worksheets in all open workbooks
  • Ctrl + F9: Minimize the workbook window
  • Shift + F9: Calculate the active worksheet
  • F10: Activate the menu bar
  • Shift + F10: Display the shortcut menu for the selected item
  • F11: Create a chart of the active data
  • Shift + F11: Insert a new worksheet
  • F12: Save the active workbook
  • Shift + F12: Print the active workbook
  • Ctrl + Shift + F12: Open the Save As dialog box
  • Alt + F12: Open the Open dialog box
  • Ctrl + Shift + F1: Insert a hyperlink
  • Ctrl + F1: Display or hide the Ribbon
  • Alt + F1: Insert a chart
  • Shift + F1: Display the Microsoft Excel Help task pane
  • Ctrl + Shift + F2: Create a new workbook
  • Ctrl + F2: Print the selection
  • Shift + F2: Edit the cell comment
  • Ctrl + Shift + F3: Create a name by using the Create Names from Selection dialog box
  • Ctrl + F3: Open the Name

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.