Do you want to save time while working smart in Excel? Master this Excel shortcuts cheat sheet guide that will definitely help you.
We know that using keyboard shortcuts can totally make your life more convenient, easy, productive, and faster. However, you cannot memorize all of them since there are so many functions and features in the Excel shortcut cheat sheet. That’s why we organize all of them so it won’t be hard for you to find.
Whether you’re a beginner or an experienced user of Excel, these cheat sheet shortcut keys are guaranteed to help your workflow and boost your productivity. In this tutorial, we created this bundle of cheat sheet guides that are commonly or mostly used and important Excel shortcut keys.
Top Excel Shortcuts Cheat Sheet
There are a lot of keyboard shortcuts, but which are the most useful? We have arranged the shortcuts cheatsheet in Excel by category. By doing so, it won’t be hard for you to find one.
1. Basic Keyboard Shortcuts
| Shortcut Keys | Description |
|---|---|
| Ctrl + C | Copy |
| Ctrl + N | Create a new |
| Ctrl + V | Paste |
| Ctrl + X | Cut |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + S | Save |
| Ctrl + F4 | Save As |
| Ctrl + A | Select all cells in the worksheet |
| Ctrl + O | Open existing file |
| Ctrl + B | Bold chosen text |
| Ctrl + I | Italicize chosen text |
| Ctrl + P | |
| Ctrl + U | Underline chosen text |
| Ctrl + F | Open the Find dialog box |
| Ctrl + P | Print Preview |
2. Navigation Shortcuts
Navigating worksheets is one of the basic shortcuts cheatsheet in Excel. This will help you quickly move from cell to cell, jump to different parts of your spreadsheet, and more.
| Shortcut Keys | Description |
|---|---|
| Arrow keys | Move the cursor up, down, left, or right on the worksheet. |
| Ctrl + Left arrow key | Move the cursor to the left end of the current cell in the worksheet. |
| Ctrl + right arrow key | Move the cursor to the right end of the current cell in the worksheet. |
| Ctrl + Up arrow key | Move the cursor to the top of the current cell in the worksheet. |
| Ctrl + Down arrow key | Move the cursor to the bottom of the current cell in the worksheet. |
| Ctrl + Arrow key | Move to the edge of the current active worksheet in any direction. |
| Ctrl + PgUp (Page Up) | Move the screen to the left of the worksheet tab. |
| Ctrl + PgDn (Page Down) | Move the screen to the right of the worksheet tab. |
| Ctrl + Home | Move to the beginning of the worksheet |
| Ctrl + End | Move to the last cell of the worksheet that contains data. |
| Tab | Move one cell to the right. |
3. Selecting Cells and Ranges
These shortcuts will help you select the cells that you need quickly and efficiently.
| Shortcut Keys | Description |
|---|---|
| Shift + Arrow keys | To select a range of cells. |
| Ctrl + Shift + Arrow keys | To select the entire column or row |
| Shift + Spacebar | To select the entire row. |
| Ctrl + Spacebar | To select the entire column. |
| Shift + F8 | Add to selection |
4. Formatting Cells
These keyboard shortcut cheatsheets in Excel will help you format your cells quickly and easily.
| Shortcut Keys | Description |
|---|---|
| Ctrl + 1 | To open the Format Cells dialog box. |
| Ctrl + Shift + 1 | To format cell to two decimal places. |
| Ctrl + Shift + 2 | To format cell to time. |
| Ctrl + Shift + 3 | To format cell to date. |
| Ctrl + Shift + 4 | To format cell to currency. |
| Ctrl + Shift + 5 | To format number into percent. |
| Ctrl + Shift + 6 | To format cell into scientific notation. |
| Ctrl + Shift + 7 | To draw outline around the cell. |
| Shift + F2 | To insert and edit comment. |
| Alt + H + F + G | To increase font size. |
| Alt + H + F + K | To reduce font size. |
| Alt + H + M + C | Merge Cell |
| Alt + H + F + S | Change Font Size |
| Ctrl + Q | Expanding the Quick Analysis tool |
| Alt + H + H | Change Cell Color |
5. Insert Shortcuts
| Shortcut Keys | Description |
|---|---|
| Alt + F1 or Alt + N + R | Insert Chart |
| Alt + N + P | Insert a Picture |
| Ctrl + Shift + (+) or Alt + I + R | Insert a cell, row, or column |
| Alt + N + X | Insert Textbox |
| Alt + N + U | Insert Symbol |
| Alt + N + S + H | Insert Shape |
| Shift + F11 | Insert new worksheet |
| Alt + IC | Insert column |
| Alt + IR | Insert row |
| Alt + N + V | Insert a Pivot Table |
| Alt + 0128 | Insert the euro (€) symbol |
| Alt + 0163 | Insert pound (£) sign symbol |
| Alt + 0162 | Insert cent (¢) symbol |
| Ctrl + 5 | Insert Strikethrough |
6. Options Shortcuts
| Shortcut Keys | Description |
|---|---|
| Menu Button | Right click menu |
| Ctrl + T | Apply table |
| Alt + D + F + F | Add Filters |
| Alt + A + S + S | Open Sort |
| Alt + A + B | Add Subtotal |
| Alt + A + M | Remove Duplicate |
| Alt + H + J | Cell Style |
| Ctrl + H | Replace |
| Ctrl + Shift + F | Font Drop Down List |
| F10 | Activate menu |
| F7 | Spell check |
| F1 | Help |
7. View Shortcuts
| Shortcut Keys | Description |
|---|---|
| Ctrl + 9 | Hide rows |
| Ctrl + 0 | Hide columns |
| Ctrl + Shift + 9 | Unhide rows |
| Ctrl + F10 | Maximize or restore window |
| Ctrl + 9 | Minimize workbook |
| Alt + W + A | Arrange Windows |
| Alt + H + J | Cell Style |
| Ctrl + H | Replace |
| Ctrl + Shift + F | Font Drop Down List |
| F10 | Activate menu |
| Alt + Control + Arrow Key | Change the position of the worksheet. |
Advanced Excel Shortcuts Cheat Sheet
It’s time to take your skills to the next level because you already know the basic keyboard shortcuts. These shortcut cheatsheets in Excel will help you work more efficiently and get more done in less time.
Formulas and Functions
| Shortcut Keys | Description |
|---|---|
| F2 | To edit a cell's formula. |
| = | To begin a formula. |
| Shift + F3 | To open the Insert Function dialog box. |
| Alt + M + R | To see recently function. |
| Alt + = | AutoSum |
| Ctrl + ' | To copy the formula from the cell above. |
| Ctrl + D | Duplicate the first cell in the selection downwards. |
| Shift + F3 | Insert Function |
| Alt + M + I | Financial Functions |
| Alt + M + T | Text Functions |
| Alt + M + O | Lookup Functions |
| Alt + M + Q | More Functions |
| Alt + M + E | Date and Time Functions |
| Alt + M + G | Math and Trig Functions |
| Ctrl + Alt + V | Paste Special format |
Tips for Mastering Excel Shortcuts Cheat Sheet
- Start with the most commonly used shortcuts and gradually learn new ones
- Create a cheat sheet and reference it frequently
- Practice using shortcuts in your daily work
- Make a habit of using shortcuts instead of clicking through menus
Conclusion
With the help of this ultimate Excel keyboard shortcuts cheat sheet, you can now increase your efficiency when working. This tutorial will definitely save your time. You don’t have to memorize all of it; you just have to familiarize yourself with each shortcut.
We sincerely hope that this tutorial was useful to you, and we are pleased to hear that you did well. Please share your opinions on this keyboard shortcut cheat sheet guide and how you’ve been using it.
Thank you very much for continuing to read until the end of this article. In case you have more questions, feel free to comment. You can also visit our website for additional information.