New Excel Shortcuts List + Community Favorites

Bottom line: Learn some our of community's favorite shortcuts, plus a list of over 270 Excel shortcuts.

Skill level: Beginner

Video Announcement

Watch on YouTube & Subscribe to our Channel

Excel Shortcuts List Updated

We recently published a new page that contains a list of over 270 Excel shortcuts for the Windows, Mac, and Web versions of Excel. It quickly became a popular page. Everyone loves to learn new Excel shortcuts.

Excel Keyboard Shortcuts List with New Navigation Menu
Click image to go to the Shortcuts Page

So feel free to share this page with your co-workers and friends. You can also download a PDF version of the list on that page.

The page was also recently updated with a Table of Contents in the sidebar to make it easier to navigate.

3 Community Favorites

We received a lot of great comments from the Excel Campus community about their favorite or newly found shortcuts. Here are three that might help save some time with your everyday tasks.

Ctrl+~ to Show/Hide Formulas

Ctrl Tilde to Show Hide Formulas in Excel - Nick Miller

I think Nick did a great job of explaining this shortcut, and why it's useful.

When you press Ctrl+~ (tilde or back quote), the Show Formulas mode is toggled on. You can also get to this view from the Formulas tab > Show Formulas button in the Ribbon.

Ctrl Tilde Shortcut to Show or Hide Formulas in Excel

With Show Formulas on, you will see the formulas in ALL of the cells on the worksheet, instead of the results of the formulas (values).

Selecting a cell will also display the colored bounding boxes around cells & ranges that are referenced in the formula. This is the same as if you are editing the formula.

One thing you'll notice about this mode is that the column widths typically get wider to fit the formulas. The widths of the columns don't actually change, but the view makes them appear twice as wide. When you turn Show Formulas off, the columns will change back to their original size.

As Nick mentioned, the Show Formulas view allows you to quickly see which cells contain formulas. It also allows you to compare formulas between cells to see if there are any discrepancies.

Shift+F8 to Select Multiple Areas

Shift F8 Excel Shortcut to Select Multiple Areas - Rich DAngelo

Rich discovered a new shortcut that will help him select multiple areas (cells or ranges).

Pressing Shift+F8 will toggle Add or Remove Selection mode on. It allows you to select multiple cells and ranges that are not adjacent. Just click each cell or range that you want to add to the selection.

This is similar to holding the Ctrl key while selecting cells or ranges with the mouse. The advantage is that you can perform the selections with one hand.

You can also use the arrow keys and Shift on the keyboard to add to the selection.

You can press the Escape key to turn the Add or Remove Selection mode off, or press Ctrl+F8 again.

Note: You might need to press Fn+Shift+F8 if you are using a Mac or Windows laptop keyboard.

Shift+F2 to Add a New Note (formerly Comment)

If you use cell notes or comments frequently, then Robert has a great tip.

Cell notes and comments can help us add additional information or context about a cell.

Excel Shortcuts for Cell Notes and Comments Ctrl Shift F2

There is one point of confusion with notes and comments. If you are using Microsoft/Office 365, then the cell Comments have been renamed to Notes. The newer versions of Excel have a new Comment feature that allows you to have threaded conversations for a cell.

If you are on an older version of Excel then they are still called Comments.

Shift+F2 inserts Notes (Comments on older versions of Excel)

Ctrl+Shift+F2 inserts Comments (Microsoft 365)

Note: You might need to hold the Fn key in combination with these shortcuts if you are using a Mac or Windows laptop.

Learn More Shortcuts

Thanks to everyone that has suggested shortcuts on our blog, YouTube channel, and inside our training programs (members area)!

Excel has hundreds of shortcuts. There's no way I'll ever commit all of these to memory, so it's great to be reminded of ones you might not use everyday.

Checkout our Excel Shortcuts List to see over 270 shortcuts and download the free pdf file if you'd like to print the list and/or keep it handy.

  • ctrl+~ ?

    not on a UK keyboard (that will apply General format – much more useful)

    Show formulae on this keyboard is ctrl+` (but still the on the far left of the top row). The only use I’ve found for this feature is to show which date-like cells are actually numbers and which are text masquerading as dates, but the column width thing makes it difficult to follow which cells are which – it’s not even an auto-fit thing; they’re just much wider

    jim

    • Hi Jim,
      Thanks for letting us know about the variations on the UK keyboard. This will be helpful for others.

      The shortcut on the US keyboard is really Ctrl+` (usually referred to as back tick or back quote). However, most people (myself included) refer to it as Ctrl+~ tilde. Tilde is the secondary character that requires the Shift key. The back tick can be really hard to see on some keyboards, so I’m guessing that is why it’s commonly referred to as the tilde key.

      Thanks again! 🙂

  • Search
    Generic filters
    Exact matches only

    JOIN US & LEARN EXCEL

    Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
    Plus weekly updates to help you learn Excel.

    Download the eBook

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    About Me

    Jon Acampora Profile

    Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

    This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

    MVP_Horizontal_BlueOnly

    Free Excel Training Webinar Modern Power Tools

    >