The Ultimate Excel Shortcuts Cheat Sheet You Need To Know

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 KeysDescription
Ctrl + CCopy
Ctrl + NCreate a new
Ctrl + VPaste
Ctrl + XCut
Ctrl + ZUndo
Ctrl + YRedo
Ctrl + SSave
Ctrl + F4Save As
Ctrl + ASelect all cells in the worksheet
Ctrl + OOpen existing file
Ctrl + BBold chosen text
Ctrl + IItalicize chosen text
Ctrl + PPrint
Ctrl + UUnderline chosen text
Ctrl + FOpen the Find dialog box
Ctrl + PPrint 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 KeysDescription
Arrow keysMove the cursor up, down, left, or right on the worksheet.
Ctrl + Left arrow keyMove the cursor to the left end of the current cell in the worksheet.
Ctrl + right arrow keyMove the cursor to the right end of the current cell in the worksheet.
Ctrl + Up arrow keyMove the cursor to the top of the current cell in the worksheet.
Ctrl + Down arrow keyMove the cursor to the bottom of the current cell in the worksheet.
Ctrl + Arrow keyMove 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 + HomeMove to the beginning of the worksheet
Ctrl + EndMove to the last cell of the worksheet that contains data.
TabMove 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 KeysDescription
Shift + Arrow keys To select a range of cells.
Ctrl + Shift + Arrow keys To select the entire column or row
Shift + SpacebarTo select the entire row.
Ctrl + SpacebarTo 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 KeysDescription
Ctrl + 1To open the Format Cells dialog box.
Ctrl + Shift + 1To format cell to two decimal places.
Ctrl + Shift + 2 To format cell to time.
Ctrl + Shift + 3To 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 + F2To insert and edit comment.
Alt + H + F + GTo 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 + QExpanding the Quick Analysis tool
Alt + H + H Change Cell Color

5. Insert Shortcuts

Shortcut KeysDescription
Alt + F1 or Alt + N + R Insert Chart
Alt + N + PInsert a Picture
Ctrl + Shift + (+) or Alt + I + RInsert a cell, row, or column
Alt + N + XInsert Textbox
Alt + N + UInsert Symbol
Alt + N + S + HInsert Shape
Shift + F11Insert new worksheet
Alt + ICInsert column
Alt + IRInsert row
Alt + N + VInsert a Pivot Table
Alt + 0128Insert the euro (€) symbol
Alt + 0163Insert pound (£) sign symbol
Alt + 0162Insert cent (¢) symbol
Ctrl + 5 Insert Strikethrough

6. Options Shortcuts

Shortcut KeysDescription
Menu ButtonRight click menu
Ctrl + TApply table
Alt + D + F + F Add Filters
Alt + A + S + S Open Sort
Alt + A + BAdd Subtotal
Alt + A + MRemove Duplicate
Alt + H + JCell Style
Ctrl + H Replace
Ctrl + Shift + F Font Drop Down List
F10Activate menu
F7Spell check
F1 Help

7. View Shortcuts

Shortcut KeysDescription
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 + AArrange Windows
Alt + H + JCell Style
Ctrl + H Replace
Ctrl + Shift + F Font Drop Down List
F10Activate 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 KeysDescription
F2To edit a cell's formula.
=To begin a formula.
Shift + F3 To open the Insert Function dialog box.
Alt + M + RTo see recently function.
Alt + =AutoSum
Ctrl + 'To copy the formula from the cell above.
Ctrl + DDuplicate the first cell in the selection
Shift + F3Insert Function
Alt + M + IFinancial Functions
Alt + M + TText 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 + VPaste 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


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.

Leave a Comment