The Most Important Excel Shortcuts to Help You Work Faster and Better
As you spend more time getting familiar with Microsoft Excel, you may start to wonder if you can automate some of the more repetitive tasks or make navigating the software easier. Fortunately, there are a great number of shortcuts that you can use in Excel that can help you do just that and more. Knowing these shortcuts and implementing them in your everyday use will help you save time and optimize your workflow.
Users who take advantage of these shortcuts often find them much more intuitive than constantly toggling a mouse. Those living with mobility or vision limitations will also appreciate shortcuts, as they can be easier to use than touchscreens. Whether you’re a student, data analyst, or someone who uses Excel on an irregular basis, you’ll likely form a shortlist of shortcuts that you use often. This tutorial will serve as an introduction to new Excel shortcuts that you can add to your wheelhouse, as well as a reference point so that you don’t have to memorize shortcuts that you may not use as frequently.
Last Updated January 2023
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365 | By Kyle Pew, Office Newb
Explore CourseApplying Excel shortcuts
Before we get started, you should know that the shortcuts below are structured so that you know exactly how to type them in Excel. If you see a plus sign between the shortcut keys, it means you will have to press all of the buttons at the same time. If the plus sign is a part of the shortcut command, it will be enclosed in parentheses (+).” On the other hand, a comma (,) instructs you to press the shortcut keys in succession for it to work.
Now that you understand why Excel shortcuts are worth learning and how to apply them, let’s take a look at some of the most important keyboard shortcuts in Excel.
Shortcuts for adding and deleting data and cells in Excel
How to add a new cell
Windows shortcut | macOS shortcut |
CTRL + SHIFT + (+) | COMMAND + UP (↑) + (+) |
The shortcut listed above allows you to add a new cell to your spreadsheet, depending on your operating system. If you frequently use Excel for data entry, you will want to take advantage of this shortcut to reduce the time you usually spend introducing a row, column, or single cell.
How to add a new line
Windows shortcut | macOS shortcut |
ALT + ENTER | CONTROL + COMMAND + RETURN |
When you need to add a new line within a cell, the shortcuts above will help you do that with ease. The great thing about this shortcut is that it makes entering comments and longer paragraphs easy to do. Professionals who find themselves writing long text entries within their Excel spreadsheets will most likely use this shortcut every day.
How to insert a comment
Windows shortcut | macOS shortcut |
SHIFT + F2 | FN + UP (↑) + F2 |
Looking for a quick way to leave a note within a cell? This shortcut is your best solution. Using the shortcut keys associated with your operating system, you will be able to annotate a single cell with a pop-up note or edit an existing comment. You will find this helpful in times when you need to clarify the meaning of a value, explain a set formula, or any other warning to make your data easier to interpret.
How to add a hyperlink
Windows shortcut | macOS shortcut |
CTRL + K | COMMAND + K |
CTRL + K, or COMMAND + K for Mac users, makes it easy to apply hyperlinks to text within a cell. This one comes in handy when you need additional context behind a value or formula, as a hyperlink can easily connect a user to an external reference that offers a more detailed explanation. Be aware that clicking on a cell that contains a hyperlink will automatically pull up a browser and load the page.
How to populate a cell with data from the left
Windows shortcut | macOS shortcut |
CTRL + R | UP (↑) + R |
Those who work with large sets of redundant data can make good use of this shortcut. It works by automatically filling in data from the cell to the left of the one you select. It can also repeat across the entire row if necessary. With one less step, this shortcut is a good alternative to manually copying and pasting within the spreadsheet. Try it out the next time you use the data validation tool.
How to automatically fill a cell with data from above
Windows shortcut | macOS shortcut |
CTRL + D | UP (↑) + D |
If you ever need to fill a cell with data from the cell above, this keyboard shortcut is the quickest way to do it. It works very similarly to the previous shortcut we learned, and they both help make data entry a whole lot easier.
How to input data in multiple cells
Windows shortcut | macOS shortcut |
CTRL + ENTER | UP (↑) + RETURN |
What this shortcut does is fill a selected cell range with user input. This is great to use when you plan to fill an entire row or column with identical text and want to spend less time copying and pasting cell by cell. The first step is selecting the range of cells where you want to type. With that selected, you can now type what you want to repeat in multiple cells and use the keys associated with your device to apply it to the entire selection. Note that you can also use this shortcut to complete an entry within the same cell — simply type the keys without selecting a range of cells to do this.
How to create a chart
Windows shortcut | macOS shortcut |
F11 | FN + F11 |
This speedy shortcut key converts data from any specified range into a bar graph. The graph will automatically populate in a separate worksheet tab, so you don’t have to worry about Excel rearranging your existing spreadsheet. Those who regularly work with metrics such as sales, revenue, and inventory should learn this shortcut.
How to create a table
Windows shortcut | macOS shortcut |
CTRL + T | UP (↑) + T |
Most Excel users use its spreadsheets to create tables, so everyone can benefit from this essential shortcut that automatically adds a table to the worksheet. Similar to using a shortcut to create a chart, these keys convert a selected range into a table. After highlighting the preferred cells and converting them into a table, Excel will automatically present some formatting options (e.g., adding a header row, filter button, or total row) and table styles with different color combinations.
How to create a new worksheet
Windows shortcut | macOS shortcut |
SHIFT + F11 | FN + UP (↑) + F11 |
This shortcut is most practical for those who work on bigger projects. It’s a faster alternative than hitting the “insert worksheet” button every time you want to open a new worksheet.
Shortcuts for selecting data and cells
Some shortcut keys will let you quickly select multiple cells instead of doing the classic drag, drop, and click. You can find a few below.
How to extend a section
Windows shortcut | macOS shortcut |
F8 | FN + F8 |
This shortcut key makes a precise selection using arrow keys. Simply press the key, or keys if you’re working on a Mac, and select the arrow keys in the direction of your selection. You may select a single row or multiple rows horizontally or vertically.
How to switch to the next worksheet
Windows shortcut | macOS shortcut |
CTRL + PageUp | FN + ^ + UP (↑) |
Instead of toggling between different worksheets using the buttons on the bottom, pressing these keys will automatically pull up the following worksheet. It is especially useful with larger projects with 10+ tabs being used at any given one time for intensive data analysis.
How to switch to the previous worksheet
Windows shortcut | macOS shortcut |
CTRL + PageDown | FN + ^ + DOWN (↓) |
Like the shortcut mentioned above, this one automatically pulls up the previous worksheet. This one is also useful to use with big projects with numerous tabs.
How to display the find and replace dialog box
Windows shortcut | macOS shortcut |
SHIFT + F5 | SHIFT + F5 or CONTROL + F |
When pouring through large spreadsheets with tons of data, the Find and Replace Dialog box is super convenient. Hit this shortcut key, and a dialog box opens with the option to find or replace values within the open sheet or the entire workbook. You also can search by rows and columns or perform searches for formulas, values, notes, and comments.
How to select a table
Windows shortcut | macOS shortcut |
CTRL + SHIFT + SPACE | CTRL + A |
This shortcut selects all of the cell contents within a table. This is very useful when copying and pasting large data sets.
How to show all formulas
Windows shortcut | macOS shortcut |
CTRL + (+) + ~ | CTRL + (+) + ` |
Use this shortcut key to pull up all of the formulas used in the worksheet. It is a great choice if you are unfamiliar with a spreadsheet or working on someone else’s spreadsheet.
Formatting and editing data and cells
If you’re sharing a spreadsheet with others, it’s important to make sure that the data is presented in a way that makes sense to everyone who reads it. The following keys will make formatting and editing data within Excel quick and straightforward.
How to edit or format a cell
Windows shortcut | macOS shortcut |
F2 | ^ + U |
Simply put, this keyboard shortcut lets you edit and format cells.
How to display the formatting dialog box
Windows shortcut | macOS shortcut |
CTRL + 1 | COMMAND + 1 |
This shortcut pulls up the “Format Cells” dialog box. You can format cells in different ways, such as a specific number format (e.g., expressed as a percentage or a fraction), alignment (e.g., centering and right indentation), font style, border style, fill style, and protection, which ‘locks up’ the cell to prevent it from being edited. This is particularly useful for more sensitive data.
Data formatting shortcuts
The following shortcuts work to format data cells to a specific type in both Windows and macOS:
- CTRL + SHIFT + 1: Formats the data according to a chosen number format (e.g., moving decimal places).
- CTRL + SHIFT + 2: Formats according to a chosen time format.
- CTRL + SHIFT + 3: Formats according to a chosen date format.
- CTRL + SHIFT + 4: Formats the data according to a chose currency value.
- CTRL + SHIFT + 5: Formats the data according to a chosen percentage value (1 to 100%).
- CTRL + SHIFT + 6: Formats the data according to a chosen exponential value or scientific form (12000 to 1.20E+04).
Shortcuts for formatting cells
There are also many shortcuts to format cells, performing everything from inserting a note to inserting blank cells. Note that some of Windows’ preexisting shortcuts may not be available for macOS.
Shortcut | Windows | macOS |
Formats fonts | CTRL + Shift + F | (^) + (↑) + F |
Edits the active cell | F2 | (^) + U |
Adds a threaded comment | Shift + F2 | FN + (↑) + F2 |
Opens a threaded comment | CTRL + Shift + F2 | |
Deletes the selected cells using the Delete dialog box | CTRL + (-) | CTRL + (-) |
Adds the current time | CTRL + Shift + (:) | COMMAND + (;) |
Adds today’s date | CTRL + (;) | (^) + (;) |
Toggles between showing formulas or cell values | CTRL + (`) | (^) + (`) |
Moves selected cells to other cells | CTRL + X | COMMAND + X |
Copies selected cell contents | CTRL + C | COMMAND + C |
Pastes selected cell contents | CTRL + V | COMMAND + V |
Opens the Paste Special dialog box | CTRL + Alt + V | COMMAND + (^) + V |
Removes or adds italicized text | CTRL + I or CTRL + 3 | COMMAND + I |
Removes or adds bold formatting | CTRL + B or CTRL + 2 | COMMAND + B |
Removes or adds an underline | CTRL + U or CTRL + 4 | COMMAND + U |
Works strikethrough formatting | CTRL + 5 | COMMAND + (^) + X |
Toggles between showing placeholders displaying, or hiding objects in the worksheet | CTRL + 6 | (^) + 6 |
Applies an outline border from chosen cells | CTRL + Shift + (&) | COMMAND + (⌥) + 0 |
Removes outline border from chosen cells | CTRL + Shift + (_) | COMMAND + (⌥) + (_) |
Shows or removes the outline symbols | CTRL + 8 | (^) + 8 |
Copies and pastes the contents of a highlighted cell into a selected range of cells below | CTRL + D | (^) + D |
Applies the General Number format | CTRL + Shift + (~) | (^) + (↑) + (~) |
Applies the Currency format (two decimal places) | CTRL + Shift + ($) | (^) + (↑) + ($) |
Applies the Percentage format (no decimal places) | CTRL + Shift + (%) | (^) + (↑) + (%) |
Applies the Scientific number format (two decimal places) | CTRL + Shift + (^) | (^) + (↑) + (^) |
Applies the Date format (day, month, year) | CTRL + Shift + (#) | (^) + (↑) + (#) |
Applies the Time format (hour, minute, AM, PM) | CTRL + Shift + (@) | (^) + (↑) + (@) |
Spell-checker (entire worksheet or selected range) | F7 | FN + F7 |
Opens “Quick Analysis,” which automatically highlights an entire cell range and presents formatting, charting, and table options, including conditional formatting with rules. | CTRL + Q | |
Opens Workbook Statistics. | CTRL + Shift + G |
Miscellaneous Shortcut Keys
Here are some of the more frequently used and simpler shortcuts for general workbook navigation.
Shortcut | Windows shortcut | macOS shortcut |
Closes a Workbook | CTRL + W | COMMAND + W |
Opens a Workbook | CTRL + O | COMMAND + O |
Reverts to the Home tab | Alt + H | |
Saves all of the data in the worksheet | CTRL + S | COMMAND + S |
Undo selected data | CTRL + Z | COMMAND + Z |
Removes the contents of a cell | Delete | Delete |
Chooses a fill color for the selected cell | Alt + H , H | |
Aligns cell contents in the center | Alt + H , A , C | COMMAND + E |
Navigates to the View tab | Alt + W | |
Open context menu | Shift + F10 | Shift + F10 |
Navigates to Formula tab | Alt + M | |
Hides chosen rows | CTRL + 9 | (^) + 9 |
Hides chosen columns | CTRL + 0 | (^) + 0 |
Top courses in Office Productivity
What are ribbon keyboard shortcuts?
The navigation ribbon also shows related options on tabs. To view all of the ribbon shortcuts for different options, press the Alt key. You will find small letters enclosed within squares that appear next to the tabs. Simply press on the letter to navigate between the different tabs and options.
You can combine different letter keys with the Alt keys to produce Access Keys, which are shortcuts to all of the different ribbon options. For example, you may press Alt+H to open the Home tab and press Alt+ M to merge and center the contents within a cell or selected cell range.
What are the different access keys for ribbon tabs?
Here are some of the most helpful access keys to navigate directly to a ribbon tab using Excel for Windows.
Shortcut | Windows | Why It’s Useful |
Opens the File page | CTRL + SHIFT + 1 | You can easily select previously saved workbooks. |
Opens the Home tab | Alt + H | It helps you find popular tools like wrapping text, formatting data as a table, or sorting and filtering a column. |
Opens the Insert tab | Alt + N | This tab allows you to enter more complex spreadsheet presentation options such as pivot tables, pivot charts, slicers, and hyperlinks. |
Opens the Page Layout tab | Alt + P | The page layout tab allows you to work with various formatting options, such as orientation (setting to portrait or landscape), margins, page size, printing, and scaling. |
Now that you know some shortcuts, you should have no trouble applying them to make some of the more advanced Excel skills even more manageable.
Recommended Articles
Top courses in Excel
Excel students also learn
Empower your team. Lead the industry.
Get a subscription to a library of online courses and digital learning tools for your organization with Udemy Business.