Have you ever watched an experienced Excel user and wondered how they work so quickly?
While most people keep moving between the keyboard and the Ribbon, experienced users often complete the same task in just a few seconds.
Their secret isn’t that they type faster.
It’s that they use keyboard shortcuts.
Instead of clicking multiple buttons, they simply press a few keys to copy data, save a workbook, edit cells, format text, or navigate through worksheets.
At first, keyboard shortcuts may seem difficult to remember.
But once you start using them regularly, they become a habit and can save you a surprising amount of time every day.
The good news is that you don’t need to memorize hundreds of shortcuts.
Learning just a few of the most common ones can make your work much faster and easier.
In this guide, you’ll learn the most useful Excel keyboard shortcuts, organized into simple categories so you can find and remember them easily.
What Are Excel Keyboard Shortcuts?
Keyboard shortcuts are combinations of two or more keys that perform a task instantly.
Instead of searching through menus or clicking Ribbon buttons, you simply press the required keys on your keyboard.
For example:
- Ctrl + C copies the selected cells.
- Ctrl + V pastes the copied content.
- Ctrl + S saves your workbook.
- Ctrl + Z undoes your last action.
These shortcuts help you complete everyday tasks much faster.
The more you use them, the less you’ll need to rely on the mouse.
Why Should You Learn Excel Keyboard Shortcuts?
You don’t need to know every shortcut in Excel.
In fact, most Excel users regularly use only a small group of shortcuts.
Even learning 15 to 20 common shortcuts can make a noticeable difference in your daily work.
Using keyboard shortcuts helps you:
- Save time by reducing mouse clicks.
- Work faster and more efficiently.
- Edit and format data more quickly.
- Improve your productivity.
- Make working in Excel more comfortable.
Imagine copying data hundreds of times a day.
Using Ctrl + C is much faster than right-clicking and selecting Copy every time.
Small time savings like this add up quickly when you’re working on large spreadsheets.
Understanding the Most Common Shortcut Keys:
Most Excel keyboard shortcuts use one or more special keys together with another key.
Once you understand these keys, remembering shortcuts becomes much easier.
Let’s look at the four keys you’ll use most often.
Ctrl Key:
The Ctrl (Control) key is the most commonly used shortcut key in Excel.
You’ll usually press it together with another key to perform a specific action.
Some popular examples include:
| Shortcut | Action |
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + X | Cut |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + S | Save |
| Ctrl + F | Find |
If you’re new to Excel, these are the first shortcuts you should learn.
Shift Key:
The Shift key is mainly used to extend selections or modify other shortcuts.
For example:
| Shortcut | Action |
| Shift + Space | Select the entire row |
| Ctrl + Shift + End | Select all used cells to the last cell |
| Ctrl + Shift + : | Insert the current time |
Many Excel shortcuts become more powerful when you add the Shift key.
Alt Key:
The Alt key is special because it gives you access to Excel’s Ribbon without using the mouse.
When you press Alt, Excel displays small letters called KeyTips on every Ribbon tab.
For example:
- Alt → Shows KeyTips.
- Alt, H → Opens the Home tab.
- Alt, N → Opens the Insert tab.
- Alt, P → Opens the Page Layout tab.
- Alt, F → Opens the File menu.
After pressing a Ribbon shortcut, Excel displays additional letters for the commands inside that tab.
For example:
Alt → H → B
opens the Borders menu on the Home tab.
This system lets you use almost every Ribbon command without touching the mouse.
Function Keys (F1 to F12):
The function keys at the top of your keyboard also perform useful tasks in Excel.
Some examples include:
| Key | Action |
| F1 | Open Excel Help |
| F2 | Edit the active cell |
| F4 | Repeat the last action or change cell references in formulas |
| F5 | Open the Go To dialog box |
| F7 | Check spelling |
| F11 | Create a chart |
| F12 | Open the Save As dialog box |
We’ll explore all the Function key shortcuts later in this guide.
Tips Before You Start Learning Shortcuts:
Many beginners think they need to memorize hundreds of keyboard shortcuts.
That’s not necessary.
A better approach is to learn a few shortcuts at a time and use them regularly.
Here are a few simple tips:
- Start with the shortcuts you use every day.
- Practice them instead of using the Ribbon.
- Add a few new shortcuts each week.
- Don’t worry about memorizing all of them at once.
Within a short time, you’ll start using many shortcuts automatically without even thinking about them.
Most Useful Excel Keyboard Shortcuts for Beginners:
If you’re new to Excel, you don’t need to learn hundreds of keyboard shortcuts on your first day.
Start with the shortcuts that you’ll use almost every time you open Excel.
Once these become a habit, you can gradually learn more advanced shortcuts.
The table below includes some of the most useful keyboard shortcuts for beginners.
| Shortcut | What It Does |
| Ctrl + C | Copy the selected cells or text. |
| Ctrl + V | Paste copied or cut content. |
| Ctrl + X | Cut the selected cells or text. |
| Ctrl + Z | Undo your last action. |
| Ctrl + Y | Redo the last undone action. |
| Ctrl + S | Save the current workbook. |
| Ctrl + P | Open the Print window. |
| Ctrl + F | Find specific text or values. |
| Ctrl + H | Find and replace text or values. |
| Ctrl + A | Select all cells in the worksheet. |
| F2 | Edit the active cell. |
| Delete | Remove the contents of selected cells. |
| Esc | Cancel the current action or exit cell editing. |
| Ctrl + G or F5 | Open the Go To dialog box. |
| Ctrl + N | Create a new workbook. |
These shortcuts alone can save you a lot of time during everyday work.
Basic Editing Keyboard Shortcuts:
Editing data is one of the most common tasks in Excel.
Whether you’re entering numbers, correcting mistakes, or copying information, these shortcuts make the process much faster.
Let’s look at them one by one.
Ctrl + C (Copy):
The Ctrl + C shortcut copies the selected cell, range, or text to the clipboard.
After copying, you can paste it anywhere in your workbook.
Example:
Suppose you’ve entered a formula in one cell and want to use the same formula in another location.
Instead of typing it again, simply:
– Select the cell.
– Press Ctrl + C.
– Select the destination cell.
– Press Ctrl + V.
This is much faster than typing the same information repeatedly.
Ctrl + V (Paste):
After copying or cutting data, use Ctrl + V to paste it.
You can paste:
- Text
- Numbers
- Formulas
- Formatting
- Images
- Charts
Excel pastes the copied content into the selected cell or range.
Ctrl + X (Cut):
The Ctrl + X shortcut removes the selected content from its current location and places it on the clipboard.
You can then paste it somewhere else using Ctrl + V.
Use this shortcut when you want to move data instead of copying it.
Ctrl + Z (Undo):
Made a mistake?
Don’t worry.
Press Ctrl + Z to undo your most recent action.
For example, if you accidentally delete data or apply the wrong formatting, Ctrl + Z quickly restores the previous state.
This is one of the most frequently used shortcuts in Excel.
Ctrl + Y (Redo):
If you accidentally undo something you wanted to keep, press Ctrl + Y.
This shortcut reapplies the last action that was undone.
Think of it as the opposite of Ctrl + Z.
Ctrl + S (Save):
Always remember to save your work regularly.
Press Ctrl + S to save your workbook instantly.
Using this shortcut frequently helps prevent data loss if Excel closes unexpectedly or your computer restarts.
Ctrl + P (Print):
Need to print your worksheet?
Instead of searching through the File menu, simply press Ctrl + P.
This opens the Print window, where you can:
- Preview your worksheet.
- Choose a printer.
- Change page settings.
- Print the workbook.
F2 (Edit Cell):
One of the most useful Excel shortcuts is F2.
Instead of double-clicking a cell, simply select it and press F2.
Excel enters Edit mode, allowing you to modify the cell contents without deleting them.
This shortcut is especially useful when working with long formulas.
Delete Key:
Press the Delete key to remove the contents of the selected cells.
This clears the data but keeps the cell formatting, borders, and formulas in surrounding cells unchanged.
If you want to remove both the data and formatting, you’ll need to use the Clear options from the Ribbon instead.
Backspace Key:
The Backspace key works differently from the Delete key.
If you’re editing a cell, pressing Backspace removes one character to the left of the cursor.
If you’re not editing a cell, Backspace doesn’t clear the entire cell like the Delete key does.
This small difference often confuses beginners.
Esc (Cancel):
The Esc key cancels the current action.
For example, if you’re editing a cell but decide not to save your changes, press Esc to exit Edit mode without applying the changes.
It can also close menus, dialog boxes, and other temporary windows.
Find and Replace Shortcuts:
Searching through large worksheets manually can take a lot of time.
Excel provides two handy shortcuts that make finding and updating data much easier.
Ctrl + F (Find):
Use Ctrl + F to search for specific text, numbers, or values in your worksheet.
For example, if your worksheet contains hundreds of customer names, you can quickly find one by typing the name into the Find box.
This saves you from scrolling through the entire worksheet.
Ctrl + H (Replace):
Need to replace one value with another?
Press Ctrl + H.
This opens the Find and Replace dialog box.
For example, if you want to replace every occurrence of January with February, Excel can update all matching entries in just a few seconds.
Go To Shortcut:
When working with large worksheets, scrolling to a specific cell can be frustrating.
Instead, press:
Ctrl + G or F5
The Go To dialog box opens.
Simply enter a cell reference, such as:
A500
or
M1200
Click OK, and Excel jumps directly to that cell.
This shortcut is especially useful when working with large datasets.
Navigation Keyboard Shortcuts in Excel:
As your worksheets grow, scrolling through thousands of rows and columns with the mouse becomes slow and frustrating.
That’s where navigation shortcuts become useful.
Instead of dragging the scroll bar or clicking through cells, you can jump to different parts of your worksheet instantly.
Let’s look at the most useful navigation shortcuts every Excel user should know.
Ctrl + Home (Go to the Beginning of the Worksheet):
The Ctrl + Home shortcut takes you directly to the beginning of the worksheet.
It moves the active cell to A1, no matter where you are.
Example:
Imagine you’re working in cell H1250.
Instead of scrolling all the way back to the top, simply press:
Ctrl + Home
Excel immediately moves to cell A1.
This is one of the fastest ways to return to the top of your worksheet.
Ctrl + End (Go to the Last Used Cell):
The Ctrl + End shortcut moves you to the last cell that contains data in your worksheet.
This is especially useful when working with large datasets.
Example:
Suppose your data ends at G850.
Press:
Ctrl + End
Excel jumps directly to the last used cell.
This saves you from scrolling through hundreds or even thousands of rows.
Ctrl + Arrow Keys:
One of the most powerful navigation shortcuts in Excel is Ctrl + Arrow Key.
Instead of moving one cell at a time, Excel jumps to the edge of the current data region.
| Shortcut | What It Does |
| Ctrl + Right Arrow | Moves to the last filled cell on the right. |
| Ctrl + Left Arrow | Moves to the first filled cell on the left. |
| Ctrl + Down Arrow | Moves to the last filled cell below. |
| Ctrl + Up Arrow | Moves to the first filled cell above. |
Example:
If you’re in cell A2 and your data continues down to A500, pressing Ctrl + Down Arrow takes you directly to A500.
It’s much faster than holding the Down Arrow key.
Page Down:
Press Page Down to move one screen down in the worksheet.
Unlike the Down Arrow key, which moves one cell at a time, Page Down scrolls an entire screen.
This is useful when reviewing long worksheets.
Page Up:
Press Page Up to move one screen up.
It works the opposite way of Page Down.
Ctrl + Page Down:
If your workbook contains multiple worksheets, use:
Ctrl + Page Down
to move to the next worksheet.
For example:
Sheet1 → Sheet2 → Sheet3
Ctrl + Page Up:
Press:
Ctrl + Page Up
to move to the previous worksheet.
This shortcut makes switching between worksheets much faster than clicking the sheet tabs.
Tab Key:
Pressing Tab moves the active cell one column to the right.
This shortcut is especially useful when entering data across a row.
Shift + Tab:
Press Shift + Tab to move one cell to the left.
Selection Keyboard Shortcuts:
Selecting cells is something you’ll do constantly while working in Excel.
Instead of dragging the mouse, keyboard shortcuts allow you to select data much faster.
Ctrl + A (Select All):
Press Ctrl + A to select all the cells in the current worksheet.
If your cursor is inside a table or data range, pressing Ctrl + A once selects the current data.
Press it again to select the entire worksheet.
This shortcut is useful when you want to:
- Apply formatting to all data.
- Copy an entire worksheet.
- Delete all contents.
- Print the complete worksheet.
Shift + Space (Select an Entire Row):
Need to select a complete row?
Click any cell in that row and press:
Shift + Space
Excel immediately selects the entire row.
This is much faster than clicking the row number with your mouse.
Ctrl + Space (Select an Entire Column):
To select an entire column, click any cell in the column and press:
Ctrl + Space
Excel highlights the complete column.
This shortcut is useful when formatting, hiding, or deleting columns.
Ctrl + Shift + End:
This shortcut selects all the cells from the active cell to the last used cell in the worksheet.
Example:
Suppose you’re in cell B2, and your data extends to F500.
Press:
Ctrl + Shift + End
Excel selects everything from B2 to the last used cell.
This is one of the quickest ways to select large datasets.
Shift + Arrow Keys:
Need to select only a few adjacent cells?
Hold the Shift key while pressing any Arrow key.
Each key press extends the selection by one cell.
This shortcut is useful for selecting small ranges without touching the mouse.
Ctrl + Shift + Arrow Keys
For larger datasets, use:
Ctrl + Shift + Arrow Key
Instead of selecting one cell at a time, Excel extends the selection to the last filled cell in that direction.
For example:
If your data runs from A2 to A1000, pressing:
Ctrl + Shift + Down Arrow:
selects the entire range in one step.
This is one of the biggest time-saving shortcuts in Excel.
Navigation Shortcuts at a Glance:
Here’s a quick summary of the navigation shortcuts we’ve covered.
| Shortcut | Action |
| Ctrl + Home | Move to cell A1 |
| Ctrl + End | Move to the last used cell |
| Ctrl + Arrow Key | Jump to the edge of a data range |
| Page Down | Move one screen down |
| Page Up | Move one screen up |
| Ctrl + Page Down | Go to the next worksheet |
| Ctrl + Page Up | Go to the previous worksheet |
| Tab | Move one cell to the right |
| Shift + Tab | Move one cell to the left |
Selection Shortcuts at a Glance:
| Shortcut | Action |
| Ctrl + A | Select all cells |
| Shift + Space | Select the entire row |
| Ctrl + Space | Select the entire column |
| Ctrl + Shift + End | Select to the last used cell |
| Shift + Arrow Keys | Extend the selection one cell at a time |
| Ctrl + Shift + Arrow Keys | Select to the edge of the data range |
Pro Tip:
If you’re working with large Excel tables, try combining navigation and selection shortcuts.
For example, press Ctrl + Down Arrow to jump to the bottom of your data, then use Ctrl + Shift + Up Arrow to select the entire column of data instantly.
Learning combinations like these can save you a lot of time compared to selecting data with the mouse.
Excel Formatting Keyboard Shortcuts:
Formatting makes your worksheet easier to read and gives it a professional appearance.
Instead of opening the Home tab every time you want to make text bold, apply a currency format, or merge cells, you can use keyboard shortcuts to complete these tasks in seconds.
Let’s look at the most useful formatting shortcuts.
Text Formatting Shortcuts:
These shortcuts help you quickly change the appearance of text in your worksheet.
Ctrl + B (Bold):
The Ctrl + B shortcut applies or removes Bold formatting from the selected text or cells.
Example:
Suppose you have a list of monthly sales.
Making the column headings bold helps them stand out from the rest of the data.
Instead of clicking the Bold button on the Ribbon, simply press:
Ctrl + B
Ctrl + I (Italic):
Use Ctrl + I to apply or remove Italic formatting.
Italic text is commonly used for notes, comments, or emphasizing certain values.
Ctrl + U (Underline):
Press Ctrl + U to underline the selected text or cell contents.
Underlining is often used for headings or important information.
Ctrl + 5 (Strikethrough):
Need to show that a task has been completed without deleting it?
Press:
Ctrl + 5
This shortcut applies or removes Strikethrough formatting.
It’s especially useful for:
- To-do lists
- Task trackers
- Checklists
- Project planning
Cell Formatting Shortcut:
Ctrl + 1 (Open Format Cells):
One of the most useful formatting shortcuts in Excel is:
Ctrl + 1
This opens the Format Cells dialog box, where you can change:
- Number formats
- Font styles
- Borders
- Fill colors
- Alignment
- Protection settings
Many advanced formatting options are available only through this dialog box.
Number Formatting Shortcuts:
Formatting numbers correctly makes your worksheet much easier to understand.
Excel provides several shortcuts for commonly used number formats.
| Shortcut | Applies |
| Ctrl + Shift + % | Percentage format |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + @ | Time format |
Let’s understand each one.
Ctrl + Shift + % (Percentage):
This shortcut formats the selected numbers as percentages.
Example:
If a cell contains:
0.75
after pressing:
Ctrl + Shift + %
Excel displays:
75%
Ctrl + Shift + $ (Currency):
This shortcut applies the default Currency format to the selected cells.
Example:
Instead of displaying:
2500
Excel displays it using your regional currency settings.
This shortcut is useful for:
- Financial reports
- Sales reports
- Budgets
- Expense sheets
Ctrl + Shift + # (Date):
Use this shortcut to format numbers as dates.
For example:
07/29/2026
The exact date format depends on your regional settings.
Ctrl + Shift + @ (Time):
This shortcut formats the selected value as time.
For example:
2:30 PM
It’s useful when recording working hours, schedules, or attendance.
Alignment Shortcuts:
Excel also provides Ribbon shortcuts for quickly changing text alignment.
These shortcuts begin with the Alt key.
| Shortcut | Action |
| Alt → H → AT | Align Top |
| Alt → H → AC | Center Align |
| Alt → H → AM | Middle Align |
| Alt → H → AB | Align Bottom |
After pressing Alt, simply continue pressing the remaining keys in order.
Wrap Text Shortcut:
Sometimes the text inside a cell is too long to fit on one line.
Instead of increasing the column width, you can wrap the text.
Press:
Alt → H → W
Excel displays the text on multiple lines within the same cell.
This makes long headings and descriptions much easier to read.
Merge Cells Shortcut:
Need to create a title across multiple columns?
Use:
Alt → H → M → C
This opens the Merge & Center command.
It’s commonly used for:
- Report titles
- Dashboard headings
- Monthly summaries
Unmerge Cells Shortcut:
To separate merged cells again, press:
Alt → H → M → U
This removes the merge while keeping the data in the upper-left cell.
Format Painter Shortcut:
The Format Painter lets you copy formatting from one cell and apply it to another.
Instead of manually repeating formatting, use:
Alt → H → F → P
This saves time when formatting large worksheets.
Remove Duplicates Shortcut:
If your worksheet contains duplicate entries, you can quickly remove them using:
Alt → A → M
Excel opens the Remove Duplicates dialog box, allowing you to remove repeated values from your data.
Formatting Shortcuts at a Glance:
| Shortcut | Action |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 5 | Strikethrough |
| Ctrl + 1 | Open Format Cells |
| Ctrl + Shift + % | Percentage format |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + @ | Time format |
| Alt → H → W | Wrap Text |
| Alt → H → M → C | Merge & Center |
| Alt → H → M → U | Unmerge Cells |
| Alt → H → F → P | Format Painter |
| Alt → A → M | Remove Duplicates |
Tips for Using Formatting Shortcuts:
Here are a few tips that can help you work more efficiently:
- Select the cells first, then use the shortcut.
- Most formatting shortcuts work as toggles, so pressing them again removes the formatting.
- Use Ctrl + 1 whenever you need advanced formatting options that aren’t available through simple shortcuts.
- If you use Ribbon shortcuts, press the keys one after another, not all at the same time.
For example:
✔ Alt → H → W
❌ Don’t press Alt + H + W together.
Excel Formula Keyboard Shortcuts:
One of Excel’s biggest strengths is its ability to perform calculations automatically.
Whether you’re adding numbers, calculating averages, or creating complex formulas, keyboard shortcuts can help you work much faster.
Instead of clicking buttons on the Ribbon, you can insert formulas, edit them, and recalculate your worksheet with just a few key presses.
Let’s explore the most useful formula shortcuts.
AutoSum Shortcut:
Alt + = (Insert SUM Function)
The Alt + = shortcut automatically inserts the SUM function.
Instead of typing the formula manually, Excel detects the nearby numbers and creates the formula for you.
Example:
Suppose your sales figures are in cells B2:B10.
Select B11 and press:
Alt + =
Excel automatically inserts:
=SUM(B2:B10)
Press Enter, and the total is calculated instantly.
This is one of the most useful shortcuts for beginners.
Edit a Formula:
F2 (Edit Active Cell)
Need to modify an existing formula?
Select the cell and press:
F2
Excel enters Edit mode, allowing you to change the formula without deleting it.
This shortcut is much faster than double-clicking the cell.
Enter the Same Formula in Multiple Cells:
Ctrl + Enter
Normally, when you press Enter, Excel completes the entry and moves to the next cell.
However, Ctrl + Enter works differently.
It enters the same value or formula into all selected cells at once.
Example:
Suppose you’ve selected cells C2:C10.
Type:
=TODAY()
Instead of pressing Enter, press:
Ctrl + Enter
Excel enters the formula into every selected cell simultaneously.
Display or Hide Formulas:
Ctrl + ` (Grave Accent)
Want to see the formulas instead of their results?
Press:
Ctrl + `
(The ` key is usually located below the Esc key on most keyboards.)
Excel switches the worksheet view to display formulas.
Press the shortcut again to return to the normal view.
This is especially helpful when:
- Checking formulas
- Auditing calculations
- Finding errors
Recalculate Formulas:
Normally, Excel recalculates formulas automatically whenever data changes.
However, there are times when you may want to force a recalculation.
| Shortcut | Action |
| F9 | Recalculate all open workbooks |
| Shift + F9 | Recalculate only the active worksheet |
These shortcuts are useful when working with large workbooks or when automatic calculation is turned off.
Insert the Current Date:
Need to enter today’s date without typing it manually?
Press:
Ctrl + ;
Excel inserts the current system date into the selected cell as a fixed value.
Example:
29-Jul-2026
Unlike the TODAY() function, this shortcut inserts a static date that doesn’t change.
Insert the Current Time:
To insert the current time, press:
Ctrl + Shift + ;
Example:
10:45 AM
Like the date shortcut, this inserts a fixed time value.
Insert a Line Break Within a Cell:
Sometimes you want multiple lines of text in the same cell.
Instead of using separate cells, press:
Alt + Enter
This inserts a line break without leaving the cell.
Example:
Type Name, press Alt + Enter, then type Address to display both on separate lines in one cell.
Instead of:
Name Address Phone
You can display:
Name
Address
Phone
inside a single cell.
This shortcut is useful for:
- Addresses
- Product descriptions
- Notes
- Comments
Workbook Keyboard Shortcuts:
As you work with Excel, you’ll often create, save, open, and switch between workbooks.
These shortcuts make those tasks much faster.
Ctrl + N (Create a New Workbook):
Press:
Ctrl + N
Excel opens a new blank workbook immediately.
Ctrl + O (Open an Existing Workbook):
Need to open an Excel file?
Press:
Ctrl + O
The Open window appears, allowing you to browse and select a workbook.
Ctrl + S (Save Workbook):
Use:
Ctrl + S
to save your current workbook.
It’s a good habit to save your work regularly, especially after making important changes.
F12 (Save As):
If you want to save the workbook with a different name or in another location, press:
F12
Excel opens the Save As dialog box.
This shortcut is useful when:
- Creating a copy of a workbook
- Saving in a different folder
- Renaming a file
Ctrl + W (Close the Current Workbook):
After finishing your work, press:
Ctrl + W
Excel closes the active workbook.
If there are unsaved changes, Excel asks whether you want to save them before closing.
Ctrl + Tab (Switch Between Open Workbooks):
If you have multiple Excel files open, press:
Ctrl + Tab
to move to the next open workbook.
Continue pressing the shortcut until you reach the workbook you want.
Formula & Workbook Shortcuts at a Glance:
| Shortcut | Action |
| Alt + = | Insert AutoSum |
| F2 | Edit the active cell |
| Ctrl + Enter | Fill all selected cells with the same entry |
| Ctrl + ` | Show or hide formulas |
| F9 | Recalculate all open workbooks |
| Shift + F9 | Recalculate the active worksheet |
| Ctrl + ; | Insert the current date |
| Ctrl + Shift + ; | Insert the current time |
| Alt + Enter | Insert a line break within a cell |
| Ctrl + N | Create a new workbook |
| Ctrl + O | Open a workbook |
| Ctrl + S | Save the workbook |
| F12 | Save As |
| Ctrl + W | Close the current workbook |
| Ctrl + Tab | Switch between open workbooks |
Pro Tip:
Try using these shortcuts while creating a simple worksheet.
For example:
- Press Ctrl + N to create a new workbook.
- Enter a few numbers.
- Use Alt + = to calculate the total.
- Press Ctrl + ; to add today’s date.
- Save the workbook with Ctrl + S.
Practicing these shortcuts in real situations makes them much easier to remember than simply reading a list.
Function Key (F1 to F12) Shortcuts in Excel:
At the top of your keyboard, you’ll find twelve function keys labeled F1 through F12.
Many Excel users rarely use them because they aren’t sure what they do.
However, several of these keys can save you time when editing worksheets, checking formulas, creating charts, or saving workbooks.
Let’s look at each function key and how it can help you.
F1 (Open Excel Help):
Press F1 to open the Excel Help window.
If you’re unsure how a feature works, this shortcut gives you quick access to Excel’s built-in help resources.
When to Use It:
- Learn about an Excel feature.
- Search for instructions.
- Find explanations of commands.
F2 (Edit the Active Cell):
The F2 key places the active cell into Edit mode.
Instead of double-clicking the cell with your mouse, simply press F2.
Example:
Suppose cell C5 contains:
=SUM(B2:B10)
Press F2, and you can edit the formula directly inside the cell.
This is especially useful when working with long formulas.
F3 (Paste a Defined Name):
If you’ve created Named Ranges in your workbook, pressing F3 opens the Paste Name dialog box.
You can quickly insert a named range into a formula without typing its name manually.
Example:
Instead of typing:
=Sales_2026
You can press F3 and select the named range from the list.
F4 (Repeat the Last Action or Change Cell References):
The F4 key has two important uses.
1. Repeat the Last Action:
If you recently applied formatting, inserted a row, or changed a cell color, pressing F4 repeats the same action.
For example, if you make one heading bold, selecting another heading and pressing F4 applies bold formatting again without repeating the Ribbon steps.
2. Change Cell References in Formulas:
While editing a formula, F4 cycles through different reference types.
For example, if your formula contains:
=A1
Pressing F4 changes it to:
=$A$1
Press F4 again to cycle through:
- A$1
- $A1
- A1
This is one of the easiest ways to create absolute and mixed cell references.
F5 (Go To):
Press F5 to open the Go To dialog box.
Instead of scrolling through thousands of rows, simply type a cell reference such as:
H1200
Excel immediately jumps to that location.
F6 (Switch Between Worksheet Areas):
The F6 key moves the focus between different parts of the Excel window.
For example, it can switch between:
- The worksheet
- The Ribbon
- The Name Box
- The Formula Bar
- Task panes
This shortcut is helpful if you prefer working entirely with the keyboard.
F7 (Spelling Check):
Press F7 to start Excel’s Spelling checker.
Excel scans your worksheet for spelling mistakes and suggests corrections.
Useful For:
- Reports
- Invoices
- Employee lists
- Product descriptions
F8 (Extend Selection):
Press F8 to turn on Extend Selection mode.
While it’s active, the Arrow keys expand the current selection instead of moving the active cell.
Press F8 again to turn it off.
This is useful when selecting large ranges without holding the Shift key.
F9 (Calculate Formulas):
Normally, Excel recalculates formulas automatically.
If calculations are set to Manual, press F9 to recalculate all open workbooks.
This ensures every formula displays the latest results.
F10 (Activate Ribbon KeyTips):
Press F10 to activate the Ribbon.
You’ll notice that Ribbon commands become accessible from the keyboard.
You can also press Alt, which performs a similar function and displays KeyTips.
F11 (Create a Chart):
Want to create a chart quickly?
Select your data and press:
F11
Excel automatically creates a chart on a new chart sheet.
This is one of the fastest ways to visualize data.
F12 (Save As):
Press F12 to open the Save As dialog box.
Use this shortcut when you want to:
- Save a copy of your workbook.
- Rename the file.
- Save it in a different folder.
- Choose another file format.
Function Keys at a Glance:
| Function Key | Action |
| F1 | Open Excel Help |
| F2 | Edit the active cell |
| F3 | Paste a named range |
| F4 | Repeat the last action or cycle through cell references |
| F5 | Open the Go To dialog box |
| F6 | Switch between worksheet areas |
| F7 | Check spelling |
| F8 | Turn Extend Selection mode on or off |
| F9 | Recalculate formulas |
| F10 | Activate Ribbon shortcuts |
| F11 | Create a chart |
| F12 | Open the Save As dialog box |
Alt Ribbon Shortcuts:
Almost every command in Excel’s Ribbon can be accessed using the Alt key.
When you press Alt, Excel displays small letters called KeyTips on each Ribbon tab.
These letters tell you which keys to press next.
For example:
| Shortcut | Action |
| Alt → H | Open the Home tab |
| Alt → N | Open the Insert tab |
| Alt → P | Open the Page Layout tab |
| Alt → M | Open the Formulas tab |
| Alt → A | Open the Data tab |
| Alt → R | Open the Review tab |
| Alt → W | Open the View tab |
| Alt → F | Open the File menu |
After opening a tab, Excel displays additional KeyTips for every command.
For example:
- Alt → H → B opens the Borders menu.
- Alt → H → O → I automatically adjusts the column width (AutoFit Column Width).
- Alt → N → T inserts a table.
- Alt → N → P inserts a PivotTable.
- Alt → H → W turns Wrap Text on or off.
The more you use these shortcuts, the less you’ll rely on the mouse.
When you first see a long list of keyboard shortcuts, it’s easy to think you’ll never remember them all.
The good news is that you don’t have to.
Most Excel users rely on a small set of shortcuts every day. As you use them repeatedly, they become second nature.
Here are a few simple ways to learn them more quickly.
1. Start with Everyday Shortcuts:
Don’t try to memorize hundreds of shortcuts at once.
Begin with the ones you’ll use every day, such as:
- Ctrl + C (Copy)
- Ctrl + V (Paste)
- Ctrl + Z (Undo)
- Ctrl + S (Save)
- F2 (Edit Cell)
Once these become a habit, move on to more advanced shortcuts.
2. Practice Instead of Reading:
Reading about shortcuts is helpful, but using them is what builds muscle memory.
The next time you’re working in Excel, challenge yourself to use keyboard shortcuts instead of clicking Ribbon buttons.
After a few days, you’ll notice that your hands automatically reach for the correct keys.
3. Learn Similar Shortcuts Together:
Many Excel shortcuts follow logical patterns.
For example:
| Shortcut | Action |
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Or: | |
| Shortcut | Action |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
Learning related shortcuts together makes them much easier to remember.
4. Keep a Shortcut Cheat Sheet:
If you’re just starting, print a small list of your favorite shortcuts or keep one beside your computer.
You’ll refer to it less and less as the shortcuts become familiar.
5. Learn One New Shortcut Every Week
You don’t need to rush.
Even learning one new shortcut each week can make a noticeable difference over time.
After a few months, you’ll have built an impressive set of keyboard skills without feeling overwhelmed.
Common Mistakes Beginners Make:
Many new Excel users make a few common mistakes while learning keyboard shortcuts.
Knowing about them can save you time and frustration.
Trying to Memorize Everything:
You don’t need to know every shortcut.
Focus on the shortcuts you use most often and learn additional ones as your skills grow.
Forgetting to Select Cells First:
Many formatting shortcuts only work after you’ve selected the cells.
For example, pressing Ctrl + B without selecting the correct cells may not give the result you expect.
Pressing Ribbon Shortcut Keys Together:
Ribbon shortcuts work differently from Ctrl shortcuts.
For example:
✔ Alt → H → W
❌ Alt + H + W (all at the same time)
Press the keys one after another, not simultaneously.
Ignoring Function Keys:
Many users overlook the F1 to F12 keys.
However, shortcuts like F2, F4, F5, F7, and F12 can save a lot of time once you get used to them.
Depending Only on the Mouse:
The mouse is useful, but constantly switching between the keyboard and the mouse slows you down.
Using keyboard shortcuts for common tasks helps you work more efficiently.
Frequently Asked Questions (FAQs):
Do Excel keyboard shortcuts work on both Windows and Mac?
Many shortcuts are similar, but Mac uses the Command (⌘) key instead of Ctrl for many actions. Some shortcuts are different, so it’s a good idea to check the Mac version if you’re using Excel on macOS.
Do I need to memorize all Excel keyboard shortcuts?
No. Most people use only a small number of shortcuts regularly. Start with the basics and gradually learn more as you become comfortable.
Which Excel keyboard shortcuts should beginners learn first?
The best shortcuts to learn first are:
- Ctrl + C (Copy)
- Ctrl + V (Paste)
- Ctrl + X (Cut)
- Ctrl + Z (Undo)
- Ctrl + S (Save)
- Ctrl + F (Find)
- F2 (Edit Cell)
- Alt + = (AutoSum)
These shortcuts are useful in almost every workbook.
What is the most useful keyboard shortcut in Excel?
There’s no single answer because it depends on what you’re doing. However, Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + S, F2, and Alt + = are among the most frequently used shortcuts.
Can I create my own keyboard shortcuts in Excel?
Excel doesn’t allow you to assign custom shortcuts to most built-in commands directly. However, you can create custom shortcuts by using Macros and assigning shortcut keys to them.
Why are some keyboard shortcuts not working?
There could be several reasons:
- You’re using a different version of Excel.
- Your keyboard layout is different.
- Function keys may require the Fn key on some laptops.
- Another application or add-in may be using the same shortcut.
Learning Excel keyboard shortcuts is one of the easiest ways to improve your productivity.
You don’t have to master hundreds of shortcuts overnight. Start with a few common ones, use them regularly, and gradually add more to your routine.
Over time, these shortcuts become automatic, helping you complete tasks more quickly with fewer mouse clicks.
Whether you’re creating reports, analyzing data, managing budgets, or working with large spreadsheets, keyboard shortcuts can make your work faster, smoother, and more efficient.
The more you practice, the more natural they become.
So the next time you open Excel, challenge yourself to use a few keyboard shortcuts instead of reaching for the mouse. Small changes today can lead to much faster and more confident Excel skills in the future.
Related Articles:
You can continue improving your Excel skills with these beginner-friendly guides:
- How to Use AutoSum in Excel
- Basic Excel Formulas Every Beginner Should Know
- How to Add Borders in Excel
- How to Merge Cells in Excel
- How to Format Cells in Excel
- Excel Ribbon Explained
- Home Tab in Excel
- Formula Bar in Excel
- Name Box in Excel
- Excel Shortcuts for Formatting
- Excel Function Keys Explained
- Microsoft Excel Basics for Beginners