43 Handy Excel Shortcuts You Can‘t Live Without

Are you looking to become an Excel power user? Do you spend hours every day working in spreadsheets and want to increase your efficiency and productivity? The key is to master Excel keyboard shortcuts.

By memorizing a few simple key combinations, you can quickly navigate, select, edit, format, and analyze your data without ever touching the mouse. Learning shortcuts will save you a ton of time and energy in the long run.

In this ultimate guide, we‘ll share over 75 of the most useful Excel shortcuts for PC and Mac. We‘ll cover everything from basic navigation to advanced data analysis. Whether you‘re a beginner or an Excel veteran, you‘re sure to discover some new tricks here.

Let‘s get started!

Navigate Like a Pro with These Shortcuts

Navigating through a large, complex spreadsheet can be a pain. Scrolling around endlessly with your mouse is slow and imprecise. Instead, use these handy shortcuts to move around quickly:

  • Move to the next cell: Tab
  • Move to the previous cell: Shift + Tab
  • Move to the cell above: Up arrow key
  • Move to the cell below: Down arrow key
  • Move to the next column: Right arrow key
  • Move to the previous column: Left arrow key
  • Jump to the first cell in the current row: Home
  • Jump to the last cell in the current row: End
  • Go to the first cell (A1) in the worksheet: Ctrl + Home
  • Go to the last used cell: Ctrl + End
  • Move to the next worksheet in a workbook: Ctrl + Page Down
  • Move to the previous worksheet: Ctrl + Page Up
  • Create a new worksheet: Shift + F11
  • Open a new workbook: Ctrl + N
  • Close the current workbook: Ctrl + W

Select Cells Like a Champ

Before you can format or manipulate data, you need to select it. And selecting with the mouse can be clumsy, especially for larger ranges. Try these shortcuts instead:

  • Select the entire column: Ctrl + Spacebar
  • Select the entire row: Shift + Spacebar
  • Select all cells in the worksheet: Ctrl + A
  • Select the current region around the active cell: Ctrl + Shift + *
  • Extend the selection by one cell: Shift + arrow key
  • Extend the selection to the last nonblank cell: Ctrl + Shift + arrow key
  • Select the current cell plus cells above/below: Shift + Ctrl + Down/Up arrow
  • Select noncontiguous cells or ranges: Ctrl + click

Edit and Delete Data with Ease

Need to quickly enter or remove data? Don‘t reach for the mouse and click around in the ribbon. Keep your hands on the keyboard and use these shortcuts:

  • Edit the active cell: F2
  • Copy selected cells: Ctrl + C
  • Cut selected cells: Ctrl + X
  • Paste content from clipboard: Ctrl + V
  • Undo last action: Ctrl + Z
  • Redo last action: Ctrl + Y
  • Delete cell contents: Delete key
  • Copy formula from cell above: Ctrl + ‘
  • Fill selected cell range with the current entry: Ctrl + Enter
  • Complete a cell entry and stay in the same cell: Ctrl + Shift + Enter
  • Insert new row: Ctrl + Shift + Plus (+)
  • Delete selected row(s): Ctrl + Minus (-)

Speed Up Your Formatting

Formatting your spreadsheet to make it cleaner and easier to read is important, but it can also be tedious. Speed things up with these formatting shortcuts:

  • Open the Format Cells dialog box: Ctrl + 1
  • Apply or remove bold formatting: Ctrl + B
  • Apply or remove italic formatting: Ctrl + I
  • Apply or remove underlining: Ctrl + U
  • Apply borders to selected cells: Ctrl + Shift + &
  • Remove borders from selected cells: Ctrl + Shift + –
  • Hide the current row(s): Ctrl + 9
  • Unhide any hidden row(s): Ctrl + Shift + 9
  • Hide the current column(s): Ctrl + 0
  • Unhide any hidden column(s): Ctrl + Shift + 0
  • Apply General number format: Ctrl + Shift + ~
  • Apply Currency format with two decimal places: Ctrl + Shift + $
  • Apply Percentage format with no decimal places: Ctrl + Shift + %
  • Apply Scientific number format with two decimal places: Ctrl + Shift + ^
  • Apply a date format (day, month, year): Ctrl + Shift + #
  • Apply a time format (hour, minute, AM/PM): Ctrl + Shift + @
  • Apply the outline border to selected cells: Ctrl + Shift + &

Excel at Excel Functions

Functions are one of Excel‘s most powerful features, allowing you to automate calculations and analyze your data. Using the mouse to find and enter functions is inefficient. Instead, try these keyboard shortcuts:

  • Insert a function into a cell: Shift + F3
  • Start a formula: =
  • Insert the SUM function: Alt + =
  • Insert the AVERAGE function: Ctrl + Shift + Enter
  • Insert the COUNT function: Ctrl + Shift + C
  • Insert the MAX function: Ctrl + Shift + M
  • Insert the MIN function: Ctrl + Shift + N
  • Enter an array formula: Ctrl + Shift + Enter
  • Toggle absolute/relative cell references: F4
  • Name a cell range: Ctrl + F3

Dominate Data Analysis

Excel is an excellent tool for sorting, filtering, and analyzing large datasets. But crunching numbers with your mouse is inefficient and mind-numbing. Try these shortcuts instead:

  • Sort the selected data range: Alt + D + S
  • Filter the selected data range: Ctrl + Shift + L
  • Reapply a filter: Ctrl + Alt + L
  • Remove a filter: Alt + D + F + R
  • Insert a pivot table: Alt + N + V
  • Refresh a pivot table: Alt + F5
  • Create a chart on the same worksheet: F11
  • Create a chart on a new worksheet: F11 + F11
  • Format a chart element: Ctrl + 1

Print Like a Boss

When it‘s time to print your beautiful spreadsheet, don‘t waste time with print preview and fiddling around with settings. Just use these shortcuts:

  • Open the Print dialog box: Ctrl + P
  • Toggle Page Break Preview: Alt + W + I
  • Set a print area: Ctrl + Shift + P
  • Clear a print area: Ctrl + Shift + C
  • Insert a page break: Alt + P + B + I
  • Remove a page break: Alt + P + B + R

More Useful Excel Shortcuts

Here are a few more shortcuts that don‘t fit into a particular category, but are super helpful to know:

  • Toggle worksheet formulas on/off: Ctrl + `
  • Check spelling: F7
  • Insert a comment: Shift + F2
  • Display the Format Cells dialog box: Ctrl + 1
  • View a cell comment: Alt + F2
  • Display the Go To dialog box to navigate to named ranges: F5
  • Zoom to selection: Alt + W + G
  • Group rows or columns: Alt + Shift + Right/Left arrow
  • Ungroup rows or columns: Alt + Shift + Up arrow

Excel Shortcuts for Mac

If you‘re a Mac user, you‘ll be pleased to know that most of the above shortcuts also work on macOS. However, you‘ll need to use the Command (⌘) key instead of Control, and the Option key instead of Alt.

Here are a few other notable differences for Excel shortcuts on Mac:

  • Edit the active cell: Control + U
  • Hide or show the ribbon: ⌘ + Option + R
  • Insert a new worksheet: ⌘ + F11
  • Enable End mode: Fn + End
  • Move to the next worksheet: ⌘ + Page Down
  • Move to the previous worksheet: ⌘ + Page Up
  • Undo the last action: ⌘ + Z
  • Redo the last action: ⌘ + Y
  • Open the Go To Special dialog box: ⌘ + G
  • Zoom in or out: ⌘ + Option + Plus (+) or Minus (-)

Conclusion

Mastering Excel keyboard shortcuts is one of the best ways to boost your productivity and efficiency when working with spreadsheets. By memorizing a few key combinations, you can navigate, select, format, and analyze your data at lightning speed.

Don‘t feel like you need to learn all 75+ shortcuts at once, though. Start with a handful of the most common shortcuts, like Ctrl + C to copy and Ctrl + V to paste. Once those become second nature, try adding a few more.

With practice and repetition, you‘ll soon be flying through Excel like a pro. Your co-workers will marvel at your spreadsheet sorcery! And you‘ll get to enjoy the satisfaction of being a true Excel power user.

For a handy reference, download our printable cheat sheet of all the shortcuts covered in this article. Keep it by your desk or tape it to your monitor until you‘ve internalized them all.

Do you have a favorite Excel shortcut we didn‘t include here? Share it in the comments below!

Tags: