docs / articles / Mastering Excel: Complete List of Shortcut Keys (PDF)

Mastering Excel: Complete List of Shortcut Keys (PDF)

Sara Jul 09, 2026 2026-07-09 04:40:45

Mastering Excel shortcuts can significantly enhance your productivity and efficiency. This comprehensive guide will walk you through the most essential Excel shortcuts, categorized for easy navigation. Whether you're a beginner or an experienced user, these time-saving techniques will help you streamline your workflow.

the excel shortcut keys list is shown in blue and pink, with numbers on each side
the excel shortcut keys list is shown in blue and pink, with numbers on each side

Before we dive into the shortcuts, let's ensure you're familiar with the basic Excel layout. The Ribbon, located at the top of the screen, is where you'll find various tabs like Home, Insert, Page Layout, etc. Shortcuts are designed to help you access these features quickly without navigating through menus.

Microsoft Excel Shortcut key
Microsoft Excel Shortcut key

Navigation Shortcuts

These shortcuts help you move around your worksheet with ease.

Computer tricks😉
Computer tricks😉

Before you start, remember that most shortcuts require you to press the Ctrl key (or Cmd on Mac) in combination with another key.

Moving Around the Worksheet

Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips

To move one cell up or down, use Ctrl + ↑ or Ctrl + ↓. To move one cell to the left or right, use Ctrl + ← or Ctrl + →.

To select a range of cells, click and drag your mouse. Alternatively, you can use Ctrl + Shift + ↑ or Ctrl + Shift + ↓ to select a column, and Ctrl + Shift + ← or Ctrl + Shift + → to select a row.

Jumping to Specific Cells

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

To go to a specific cell, press F5, then enter the cell reference (e.g., A1, B5, etc.). Alternatively, you can use the Ctrl + G shortcut to open the Go To dialog box.

To go to the last cell with data, press Ctrl + Shift + End. To go to the first cell with data, press Ctrl + Shift + Home.

Editing Shortcuts

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

These shortcuts help you edit and manipulate data within your worksheet.

Copying and Pasting

Excel shortcut ...✅
Excel shortcut ...✅
Top 21 Excel Formulas
Top 21 Excel Formulas
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
short computer keys
short computer keys
[PDF] 400+ Excel Formulas List | Excel Shortcut Keys PDF - Download Here
[PDF] 400+ Excel Formulas List | Excel Shortcut Keys PDF - Download Here
30+ Excel Shortcuts Every Professional Should Know
30+ Excel Shortcuts Every Professional Should Know
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
Computer Shortcut Keys Chart | Windows, Browser, Word & Excel Shortcuts for Productivity
Computer Shortcut Keys Chart | Windows, Browser, Word & Excel Shortcuts for Productivity
[FREE PDF DOWNLOAD] 333 Excel Keyboard Shortcuts!
[FREE PDF DOWNLOAD] 333 Excel Keyboard Shortcuts!
20 Advanced Excel Shortcut Keys Every Professional Should Know | Excel Productivity Cheat Sheet
20 Advanced Excel Shortcut Keys Every Professional Should Know | Excel Productivity Cheat Sheet
excel useful shortcuts
excel useful shortcuts
Industrial Knowledge on LinkedIn: ➡️ Excel Shortcuts From Beginner to Pro: https://lnkd.in/d7hB3YEc ➡️ Join…
Industrial Knowledge on LinkedIn: ➡️ Excel Shortcuts From Beginner to Pro: https://lnkd.in/d7hB3YEc ➡️ Join…
Client Challenge
Client Challenge
excel shortcuts quick reference worksheet is shown in the above text box
excel shortcuts quick reference worksheet is shown in the above text box
the google sheet shortcut keys are shown in different colors and sizes, including blue, yellow
the google sheet shortcut keys are shown in different colors and sizes, including blue, yellow
23 Excel important Shortcut Key's
23 Excel important Shortcut Key's
the excel ctrl shortcuts cheat sheet
the excel ctrl shortcuts cheat sheet
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
the basic excel formats for each type of text, including numbers and letters in green
the basic excel formats for each type of text, including numbers and letters in green
50 Essential Computer Shortcut Keys Every Student Should Know
50 Essential Computer Shortcut Keys Every Student Should Know

To copy a cell or range, select it, then press Ctrl + C. To paste, press Ctrl + V. To paste without formatting, use Ctrl + Shift + V.

To copy a formula that calculates the sum of a range, select the range, then press Ctrl + Shift + T. This is the AutoSum shortcut, which automatically enters the SUM formula for you.

Deleting and Undoing

To delete a cell's content, press Ctrl + - (that's the minus key). To delete a cell, including its content, press Ctrl + X.

To undo an action, press Ctrl + Z. Each press will undo the previous action. To redo an action, press Ctrl + Y.

Formulas and Functions

These shortcuts help you work with formulas and functions more efficiently.

Inserting Formulas

To insert a formula, type an equal sign (=) in the cell where you want the result to appear, then enter the formula. To accept the formula, press Enter.

To edit a formula, double-click the cell containing the formula. To edit multiple cells, select the cells, then double-click any one of them.

Using Functions

To use a function, type an equal sign (=), then start typing the function name (e.g., SUM, AVERAGE, etc.). Excel will display a list of matching functions. Select the correct function by clicking it or using the arrow keys, then press Tab to insert it.

To insert a function using the Insert Function dialog box, press Alt + F1. This will open the dialog box, where you can browse functions by category or search for a specific function.

Mastering these shortcuts will significantly improve your productivity in Excel. Practice them regularly, and they'll become second nature. Happy shortcutting!