10 Essential Excel Keyboard Shortcuts for Navigating Worksheets

Ben Stegner 10-10-2017

Working in a Microsoft Excel spreadsheet can be a frustrating or pleasant experience. The difference likely lies in how productive you are with the software 10 Easy Excel Timesavers You Might Have Forgotten These ten tips are sure to minimize your time performing menial Excel tasks and boost your spreadsheet productivity. Read More .


Having to hunt through menus for everything is no fun. Keyboard shortcuts help you access your most-used functions instantly, and you can even make your own How to Make Your Own Excel Keyboard Shortcuts the Easy Way Looking to make Excel your own? Here are the best ways to create custom keyboard shortcuts. Read More .

Here are some of the most useful Excel shortcuts you should keep in mind for regular use:

  • F2 lets you edit the selected cell.
  • F4 repeats the last action you took.
  • Ctrl + Alt + V opens the Paste Special menu. Here you can choose to paste the value, formula, formatting, and more of your copied text.
  • Ctrl + A selects the entire worksheet.
  • Alt + = will automatically add the values in a row, column, or table and create a SUM function in the current cell.
  • Ctrl + ; will enter the current date.
  • Ctrl + T opens the Insert Table dialogue.
  • Ctrl + Shift + Arrow key will extend your selection as far as data goes. For instance, say you have a column with 10 items in it. Select the top cell, use this shortcut, and Excel will select all the cells.
  • Ctrl + 1 opens the Format Cells dialogue. This lets you change number, alignment, font, and more properties without poking through the Ribbon menu.
  • If you ever lose track of your current cell, press Ctrl + Backspace.
  • Press Ctrl + Home to return to cell A1.

For many more of these, check out our guide to Excel shortcuts 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac Keyboard shortcuts can save you a lot of time! Use these Microsoft Excel shortcuts to speed up working with spreadsheets on Windows and Mac. Read More .

Which Excel shortcuts do you use regularly? Tell us which keyboard shortcuts you can’t live without in the comments!

Image Credit: fotoscool/Depositphotos


Related topics: Keyboard Shortcuts, Microsoft Excel.

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Bryan
    November 14, 2018 at 7:53 pm

    I also like the shortcut to jump between tabs: Ctrl+Page Up, and Ctrl+Page Down.

    (here's a gif showing it in action:

  2. Keith
    October 10, 2017 at 3:54 pm

    You should clarify that most of these are for Windows, not Mac