Microsoft Excel Keyboard Reference
Excel Shortcuts Cheat Sheet: Windows & Mac
Quickly find Excel keyboard shortcuts for navigation, editing, formatting, formulas, tables, charts, PivotTables, and everyday workbook tasks. Compare Windows and Mac commands side by side.
- 26 focused sections
- Windows and Mac comparisons
- Searchable shortcut reference
Find Excel Shortcuts
Search the Excel Shortcuts Cheat Sheet
Search by command, keyboard combination, operating system, workbook task, Excel feature, or shortcut category.
26 sections
Matching sections remain visible while unrelated sections are hidden.
No matching sections found. Try a command, feature, operating system, or keyboard combination.
Free Printable PDF
Download the Excel Keyboard Shortcuts PDF
Get the printable 6-page Excel keyboard shortcuts reference for Windows and Mac. Ideal for quick lookup, study, and everyday Excel work.
Download Free PDFEssential commands at a glance
Excel Shortcuts Quick Reference
Start with these frequently used Excel shortcuts for opening, saving, editing, formatting, navigating, and working with data. Windows and Mac commands are shown separately.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Open a new blank workbook |
Ctrl
+
N
Ctrl+N
|
⌘
+
N
Cmd+N
|
|
| Open a workbook |
Ctrl
+
O
Ctrl+O
|
⌘
+
O
Cmd+O
|
|
| Save the workbook |
Ctrl
+
S
Ctrl+S
|
⌘
+
S
Cmd+S
|
|
| Copy the selection |
Ctrl
+
C
Ctrl+C
|
⌘
+
C
Cmd+C
|
|
| Paste the selection |
Ctrl
+
V
Ctrl+V
|
⌘
+
V
Cmd+V
|
|
| Undo the previous action |
Ctrl
+
Z
Ctrl+Z
|
⌘
+
Z
Cmd+Z
|
|
| Apply bold formatting |
Ctrl
+
B
Ctrl+B
|
⌘
+
B
Cmd+B
|
|
| Open the Format Cells dialog |
Ctrl
+
1
Ctrl+1
|
⌘
+
1
Cmd+1
|
|
| Edit the active cell |
F2
F2
|
F2
F2
|
|
| Insert a new worksheet |
Shift
+
F11
Shift+F11
|
Shift
+
F11
Shift+F11
|
|
| Add or remove a filter |
Ctrl
+
Shift
+
L
Ctrl+Shift+L
|
Ctrl
+
Shift
+
L
Ctrl+Shift+L
|
|
| Insert an AutoSum formula |
Alt
+
=
Alt+=
|
Shift
+
⌘
+
T
Shift+Cmd+T
|
Understand modifier keys
Windows and Mac Key Differences
Many Excel shortcuts use similar letter keys on both platforms, but the modifier keys and some application-level commands differ. Do not assume every Windows shortcut converts directly to Mac.
Ctrl and Command
Windows commonly uses Ctrl, while Mac often uses ⌘ for file and editing commands such as copy, paste, save, and undo.
Alt and Option
The Mac Option key often performs tasks similar to Alt, but the exact shortcut can differ between Excel versions.
Function keys
On many Mac keyboards, an Excel command such as F2 may require Fn + F2 unless standard function keys are enabled in macOS settings.
Ribbon KeyTips
Excel for Windows uses Alt KeyTips to reach ribbon commands. Excel for Mac does not mirror every Windows ribbon sequence and relies more heavily on menus and Mac-specific commands.
Excel for the web
Browser shortcuts can override Excel commands. Excel for the web sometimes uses Alt + Windows for ribbon access instead of the desktop Windows sequence.
Keyboard layouts
Microsoft documents shortcuts using a US keyboard layout. Symbols and key positions may differ on Swedish and other international keyboards even when the Excel command is the same.
Manage Excel files faster
File and Workbook Shortcuts
Create, open, save, print, and close Excel workbooks without leaving the keyboard. These commands apply to the desktop versions of Excel unless otherwise noted.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Create a new blank workbook |
Ctrl
+
N
Ctrl+N
|
⌘ + N | |
| Open a workbook |
Ctrl
+
O
Ctrl+O
|
⌘ + O | |
| Save the current workbook |
Ctrl
+
S
Ctrl+S
|
⌘ + S | |
| Open Save As |
F12
F12
|
⌘ + Shift + S | |
| Close the workbook window |
Ctrl
+
W
Ctrl+W
|
⌘ + W | |
| Open print options |
Ctrl
+
P
Ctrl+P
|
⌘ + P | |
| Insert a new worksheet |
Shift
+
F11
Shift+F11
|
Shift + F11 | |
| Show or hide the ribbon |
Ctrl
+
F1
Ctrl+F1
|
⌘ + Option + R |
Select worksheet data
Select Cells, Rows, and Columns
Select individual cells, complete rows and columns, contiguous data regions, or large worksheet ranges without dragging with the mouse.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Extend the selection by one cell |
Shift
+
Arrow key
Shift+Arrow key
|
Shift + Arrow key | |
| Extend to the last nonblank cell |
Ctrl
+
Shift
+
Arrow key
Ctrl+Shift+Arrow key
|
Shift + Command + Arrow key | |
| Select the entire column |
Ctrl
+
Spacebar
Ctrl+Spacebar
|
Ctrl + Spacebar | |
| Select the entire row |
Shift
+
Spacebar
Shift+Spacebar
|
Shift + Spacebar | |
| Select the current data region |
Ctrl
+
Shift
+
*
Ctrl+Shift+Asterisk
|
Command + A Press again to expand the selection. | |
| Select the current region or entire worksheet |
Ctrl
+
A
Ctrl+A
|
Command + A | |
| Extend to the beginning of the worksheet |
Ctrl
+
Shift
+
Home
Ctrl+Shift+Home
|
Ctrl + Shift + Home MacBook: Ctrl + Shift + Fn + Left Arrow | |
| Extend to the last used cell |
Ctrl
+
Shift
+
End
Ctrl+Shift+End
|
Ctrl + Shift + End MacBook: Ctrl + Shift + Fn + Right Arrow | |
| Add a nonadjacent range to the selection |
Shift
+
F8
Shift+F8
|
Shift + F8 MacBook keyboards may require Fn. |
Work efficiently with cell content
Enter and Edit Data
Edit existing values, complete or cancel cell entries, add line breaks, fill selected ranges, and insert the current date or time.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Edit the active cell |
F2
F2
|
F2 Some keyboards require Fn + F2. | |
| Complete the entry and move down |
Enter
Enter
|
Return | |
| Complete the entry and move up |
Shift
+
Enter
Shift+Enter
|
Shift + Return | |
| Complete the entry and move right |
Tab
Tab
|
Tab | |
| Complete the entry and move left |
Shift
+
Tab
Shift+Tab
|
Shift + Tab | |
| Cancel the current cell entry |
Esc
Esc
|
Esc | |
| Insert a line break inside a cell |
Alt
+
Enter
Alt+Enter
|
Option + Return Ctrl + Option + Return also works. | |
| Fill every selected cell with the current entry |
Ctrl
+
Enter
Ctrl+Enter
|
Command + Return Ctrl + Return also works. | |
| Insert the current date |
Ctrl
+
;
Ctrl+Semicolon
|
Ctrl + ; | |
| Insert the current time |
Ctrl
+
Shift
+
;
Ctrl+Shift+Semicolon
|
Command + ; |
Move and duplicate worksheet content
Copy, Paste, and Fill
Copy or move worksheet content, choose how copied data is pasted, and quickly extend values, formatting, or formulas through selected cells.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Copy the selected cells |
Ctrl
+
C
Ctrl+C
|
Command + C | |
| Cut the selected cells |
Ctrl
+
X
Ctrl+X
|
Command + X | |
| Paste copied or cut content |
Ctrl
+
V
Ctrl+V
|
Command + V | |
| Open the Paste Special dialog box |
Ctrl
+
Alt
+
V
Ctrl+Alt+V
|
Ctrl + Command + V | |
| Fill the selected range downward |
Ctrl
+
D
Ctrl+D
|
Ctrl + D | |
| Fill the selected range to the right |
Ctrl
+
R
Ctrl+R
|
Ctrl + R | |
| Cancel the copy or cut selection |
Esc
Esc
|
Esc |
Reverse or reuse recent actions
Undo, Redo, and Repeat
Correct mistakes, restore an action you reversed, or repeat a recent command without navigating through Excel’s menus.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Undo the last action |
Ctrl
+
Z
Ctrl+Z
|
Command + Z | |
| Redo an action that was undone |
Ctrl
+
Y
Ctrl+Y
|
Command + Y | |
| Repeat the last command or action |
F4
F4
Ctrl + Y can also repeat many actions.
|
Command + Y Availability depends on the previous action. |
Style cells and display values
Format Cells and Numbers
Format text and control how numbers, currencies, percentages, dates, and times appear without changing their underlying values.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Open the Format Cells dialog box |
Ctrl
+
1
Ctrl+1
|
Command + 1 | |
| Apply or remove bold formatting |
Ctrl
+
B
Ctrl+B
|
Command + B | |
| Apply or remove italic formatting |
Ctrl
+
I
Ctrl+I
|
Command + I | |
| Apply or remove underline formatting |
Ctrl
+
U
Ctrl+U
|
Command + U | |
| Apply the General number format |
Ctrl
+
Shift
+
~
Ctrl+Shift+Tilde
|
Ctrl + Shift + ~ | |
| Apply the Number format |
Ctrl
+
Shift
+
!
Ctrl+Shift+Exclamation point
Uses two decimals and a thousands separator.
|
Ctrl + Shift + ! | |
| Apply the Currency format |
Ctrl
+
Shift
+
$
Ctrl+Shift+Dollar sign
|
Ctrl + Shift + $ | |
| Apply the Percentage format |
Ctrl
+
Shift
+
%
Ctrl+Shift+Percent sign
|
Ctrl + Shift + % | |
| Apply the Date format |
Ctrl
+
Shift
+
#
Ctrl+Shift+Number sign
|
Ctrl + Shift + # | |
| Apply the Time format |
Ctrl
+
Shift
+
@
Ctrl+Shift+At sign
|
Ctrl + Shift + @ |
Change worksheet structure
Rows, Columns, and Cells
Insert or remove cells, rows, and columns, or temporarily hide worksheet areas so you can focus on the data that matters.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Insert cells, rows, or columns |
Ctrl
+
+
Ctrl+Plus sign
|
Ctrl + + | |
| Delete cells, rows, or columns |
Ctrl
+
−
Ctrl+Minus sign
|
Ctrl + − | |
| Hide the selected rows |
Ctrl
+
9
Ctrl+9
|
Command + ( Ctrl + ( also works. | |
| Unhide rows within the selection |
Ctrl
+
Shift
+
9
Ctrl+Shift+9
|
Command + Shift + ( | |
| Hide the selected columns |
Ctrl
+
0
Ctrl+0
|
Command + ) Ctrl + ) also works. | |
| Unhide columns within the selection |
Ctrl
+
Shift
+
0
Ctrl+Shift+0
|
Command + Shift + ) |
Build and inspect calculations
Formulas and Functions
Start formulas, insert functions, create totals, inspect worksheet formulas, control cell references, and recalculate results.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Start a formula |
=
Equal sign
|
= | |
| Open Insert Function or Formula Builder |
Shift
+
F3
Shift+F3
|
Shift + F3 Some keyboards require Fn + Shift + F3. | |
| Insert an AutoSum formula |
Alt
+
=
Alt+Equal sign
|
Shift + Command + T | |
| Show or hide formulas in the worksheet |
Ctrl
+
`
Ctrl+Grave accent
|
Ctrl + ` | |
| Cycle through relative, absolute, and mixed references |
F4
F4
|
Command + T F4 also works on supported keyboards. | |
| Calculate the active worksheet |
Shift
+
F9
Shift+F9
|
Shift + F9 MacBook keyboards may require Fn. | |
| Calculate all open worksheets |
F9
F9
|
Ctrl + Option + F9 | |
| Force a full recalculation |
Ctrl
+
Alt
+
F9
Ctrl+Alt+F9
|
Ctrl + Option + F9 |
Locate and update worksheet content
Find and Replace
Search for text, numbers, formulas, or formatting and replace matching content across the current worksheet or the entire workbook.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Open the Find dialog box |
Ctrl
+
F
Ctrl+F
|
Ctrl + F | |
| Open the Replace dialog box |
Ctrl
+
H
Ctrl+H
|
Ctrl + H | |
| Repeat the last Find action |
Shift
+
F4
Shift+F4
|
Command + G Moves to the next matching result. | |
| Move to the previous matching result |
Shift
+
Enter
Shift+Enter
Use while the Find dialog box is active.
|
Command + Shift + G | |
| Close Find or Replace |
Esc
Esc
|
Esc |
Organize and narrow worksheet data
Sort and Filter Data
Add filters, open column filter menus, arrange records, reapply active filters, and fill text patterns automatically.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Add or remove AutoFilter buttons |
Ctrl
+
Shift
+
L
Ctrl+Shift+L
|
Command + Shift + F Ctrl + Shift + L also works. | |
| Open the filter list for the active header |
Alt
+
Down Arrow
Alt+Down Arrow
|
Option + Down Arrow | |
| Open the Sort dialog box |
Alt
→
A
→
S
→
S
Alt, A, S, S
Press the keys in sequence.
|
Command + Shift + R | |
| Reapply the current sort and filter |
Ctrl
+
Alt
+
L
Ctrl+Alt+L
|
No documented direct shortcut Use the Data tab and the available sort or filter controls. | |
| Apply Flash Fill |
Ctrl
+
E
Ctrl+E
|
Ctrl + E |
Work with structured data
Excel Tables
Convert a data range into an Excel table, move through table cells, add records, and select structured rows or columns efficiently.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Create a table from the current data range |
Ctrl
+
T
Ctrl+T
Ctrl + L also opens Create Table.
|
Command + T Ctrl + T also works. | |
| Move to the next table cell |
Tab
Tab
|
Tab | |
| Move to the previous table cell |
Shift
+
Tab
Shift+Tab
|
Shift + Tab | |
| Add a new row at the bottom of a table |
Tab
Tab from the last table cell
Press from the table’s final cell.
|
Tab Press from the table’s final cell. | |
| Select the current table column |
Ctrl
+
Spacebar
Ctrl+Spacebar
Press again to expand the selection.
|
Ctrl + Spacebar | |
| Select the current table row |
Shift
+
Spacebar
Shift+Spacebar
|
Shift + Spacebar | |
| Select the table’s data region |
Ctrl
+
A
Ctrl+A
Repeated presses expand the selection.
|
Command + A Repeated presses expand the selection. | |
| Display Quick Analysis for selected data |
Ctrl
+
Q
Ctrl+Q
|
No direct shortcut |
Turn worksheet data into visuals
Charts and Visual Analysis
Create charts from selected data and use the keyboard to select, inspect, format, or remove chart objects.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Create an embedded chart from the current data range |
Alt
+
F1
Alt+F1
|
No direct shortcut Use Insert and choose a chart type. | |
| Create a chart on a separate chart sheet |
F11
F11
|
F11 MacBook keyboards may require Fn + F11. | |
| Navigate to floating worksheet objects |
Ctrl
+
Alt
+
5
Ctrl+Alt+5, then Tab
Then press Tab to cycle through objects.
|
F6 Then use Tab to browse available chart objects. | |
| Cycle through elements of a selected chart |
Arrow keys
Arrow keys
|
Arrow keys | |
| Open the context menu for a selected chart element |
Shift
+
F10
Shift+F10
|
Shift + F10 Some keyboards require Fn. | |
| Remove the selected chart or chart element |
Delete
Delete
|
Delete |
Summarize and explore large datasets
PivotTables
Create PivotTables, open field menus, access PivotTable commands, and refresh summarized data when the source changes.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Open the Create PivotTable dialog box |
Alt
→
N
→
V
→
T
Alt, N, V, T
Press the keys in sequence.
|
No direct shortcut Use Insert, then choose PivotTable. | |
| Open the selected PivotTable field menu |
Alt
+
Down Arrow
Alt+Down Arrow
|
Option + Down Arrow | |
| Open the context menu for the selected PivotTable item |
Shift
+
F10
Shift+F10
|
Shift + F10 Some keyboards require Fn. | |
| Refresh the selected PivotTable or data connection |
Alt
+
F5
Alt+F5
|
No direct shortcut Use the PivotTable tab and choose Refresh. | |
| Refresh all workbook data connections |
Ctrl
+
Alt
+
F5
Ctrl+Alt+F5
|
No direct shortcut Use Data and choose Refresh All. | |
| Close an open PivotTable menu or dialog box |
Esc
Esc
|
Esc |
Manage the Excel workspace
Workbook Views and Windows
Switch between open workbooks, move focus between Excel interface areas, and change how the active worksheet is displayed.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Switch to the next open Excel workbook |
Ctrl
+
F6
Ctrl+F6
|
Command + ` Uses the macOS window-switching command. | |
| Switch to the previous open Excel workbook |
Ctrl
+
Shift
+
F6
Ctrl+Shift+F6
|
Command + Shift + ` | |
| Move focus to the next interface area |
F6
F6
|
F6 Some keyboards require Fn + F6. | |
| Move focus to the previous interface area |
Shift
+
F6
Shift+F6
|
Shift + F6 Some keyboards require Fn. | |
| Switch to Normal view |
Alt
→
W
→
L
Alt, W, L
Press the keys in sequence.
|
No direct shortcut Choose Normal from the View tab. | |
| Switch to Page Layout view |
Alt
→
W
→
P
Alt, W, P
Press the keys in sequence.
|
No direct shortcut Choose Page Layout from the View tab. | |
| Switch to Page Break Preview |
Alt
→
W
→
I
Alt, W, I
Press the keys in sequence.
|
No direct shortcut Choose Page Break Preview from the View tab. | |
| Show or hide the ribbon |
Ctrl
+
F1
Ctrl+F1
|
Command + Option + R |
Prepare worksheets for printing
Print and Page Setup
Preview printed pages and adjust orientation, paper size, margins, scaling, and the worksheet content included in the printout.
| Action | Windows | Mac | Copy |
|---|---|---|---|
| Open Print and Print Preview |
Ctrl
+
P
Ctrl+P
|
Command + P | |
| Open the Page Setup dialog box |
Alt
→
P
→
S
→
P
Alt, P, S, P
Press the keys in sequence.
|
No direct shortcut Open Page Setup from the Page Layout tab. | |
| Change page orientation in Print |
Alt
+
P
→
O
Alt+P, O
Use inside the Print screen.
|
Tab Navigate to Orientation and use the arrow keys. | |
| Change paper size in Print |
Alt
+
P
→
L
Alt+P, L
Use inside the Print screen.
|
Tab Navigate to Paper Size and use the arrow keys. | |
| Change page margins in Print |
Alt
+
P
→
M
Alt+P, M
Use inside the Print screen.
|
Tab Navigate to Margins and use the arrow keys. | |
| Change print scaling |
Alt
+
P
→
S
Alt+P, S
Use inside the Print screen.
|
Tab Navigate to Scaling and choose an option. | |
| Print using the selected settings |
Alt
+
P
→
P
Alt+P, P
Use inside the Print screen.
|
Return Use when the Print button has focus. |
Understand the top row of the keyboard
Function Keys: F1–F12
Use Excel’s function keys for editing, navigation, calculations, charts, and file commands. Laptop keyboards may require the Fn key.
| Key and action | Windows | Mac | Copy |
|---|---|---|---|
| F1 — Open Excel Help |
F1
F1
|
F1 Command + / also opens Help. | |
| F2 — Edit the active cell |
F2
F2
|
F2 | |
| F3 — Work with names or functions |
F3
F3
Opens Paste Name when workbook names exist.
|
Shift + F3 Opens the Formula Builder. | |
| F4 — Repeat or change a formula reference |
F4
F4
Repeats an action or cycles reference types in a formula.
|
F4 Cycles relative, absolute, and mixed references. | |
| F5 — Open the Go To dialog box |
F5
F5
|
F5 | |
| F6 — Cycle through Excel interface areas |
F6
F6
|
F6 Shift + F6 moves in reverse. | |
| F7 — Check spelling |
F7
F7
|
F7 Shift + F7 opens the thesaurus. | |
| F8 — Turn Extend Selection mode on or off |
F8
F8
Shift + F8 adds another range to the selection.
|
F8 Shift + F8 adds another range. | |
| F9 — Calculate all open workbooks |
F9
F9
Shift + F9 calculates only the active sheet.
|
F9 Shift + F9 calculates only the active sheet. | |
| F10 — Open keyboard menus |
F10
F10
Shows Key Tips. Shift + F10 opens the context menu.
|
Shift + F10 Opens the context menu. | |
| F11 — Create a chart sheet |
F11
F11
Shift + F11 inserts a new worksheet.
|
F11 Shift + F11 inserts a new worksheet. | |
| F12 — Open Save As |
F12
F12
|
F12 Command + F12 opens a workbook. |
Fix common keyboard problems
Shortcut Troubleshooting
Identify why an Excel shortcut behaves unexpectedly and apply the most likely fix before changing workbook or application settings.
| Problem | Likely cause | What to try |
|---|---|---|
| A function key changes volume, brightness, or opens another app | The laptop assigns a hardware or manufacturer command to the F-key row. | Hold Fn while pressing the function key. You can also enable Fn Lock or standard function keys in the computer’s keyboard settings. |
| Arrow keys scroll the worksheet instead of changing cells | Scroll Lock is enabled. | Turn off Scroll Lock. If the keyboard has no Scroll Lock key, use the Windows On-Screen Keyboard or check the computer’s keyboard utility. |
| A shortcut types inside the cell instead of performing its action | Excel is currently in cell-editing mode. | Press Enter to keep the current edit or Esc to cancel it, and then try the shortcut again. |
| Editing shortcuts do nothing in Excel for the web | The workbook is open in Viewing mode or the browser is handling the command. | Switch the workbook to Editing mode. Remember that some browser shortcuts differ from the Excel desktop application. |
| A symbol-based shortcut produces the wrong result | The shortcut documentation uses a US keyboard layout, while the physical keyboard uses another regional layout. | Locate the actual symbol key on your keyboard. For number formats, you can instead open Format Cells with Ctrl + 1 on Windows or Command + 1 on Mac. |
| A Mac shortcut activates Mission Control or another macOS feature | The Excel shortcut conflicts with a macOS system shortcut. | Open macOS System Settings, choose Keyboard and Keyboard Shortcuts, and change or disable the conflicting system command. |
| Ctrl, Command, or Option shortcuts behave inconsistently | The Windows and Mac versions use different modifier keys for that particular action. | Check the correct platform column in this cheat sheet. Do not assume every Windows Ctrl command becomes Command on Mac. |
| A shortcut works on one computer but not another | Excel version, keyboard firmware, operating-system settings, or an installed utility may be different. | Try the equivalent ribbon command first. Then check Excel updates, keyboard settings, Fn Lock, and any manufacturer keyboard tools. |
Build speed without losing accuracy
Shortcut Best Practices
Learn Excel shortcuts in manageable groups and use them safely in real workbooks until they become part of your normal workflow.
| Best practice | Why it helps | How to apply it |
|---|---|---|
| Start with frequently used commands | Common shortcuts provide the largest time saving and are easier to remember through repetition. | Learn Save, Undo, Copy, Paste, Find, cell editing, and basic navigation before moving to advanced commands. |
| Learn shortcuts in task-based groups | Related commands are easier to recall when they belong to the same workflow. | Practice navigation together, then selection, formatting, formulas, filtering, and workbook management. |
| Add only a few new shortcuts at a time | Trying to memorize a large reference table at once usually leads to poor retention. | Choose three to five shortcuts each week and use them repeatedly in normal worksheet tasks. |
| Practice in a disposable workbook | Structural commands can insert, delete, move, or overwrite data. | Test unfamiliar shortcuts in a blank workbook before using them in an important financial or business file. |
| Watch the active cell and selection | Many Excel commands affect the currently selected cell, range, row, column, or data region. | Confirm the highlighted range before filling, deleting, formatting, sorting, or creating a table. |
| Save before structural changes | Deleting rows, changing formulas, sorting incomplete ranges, or refreshing data can produce unexpected results. | Press Ctrl + S on Windows or Command + S on Mac before major changes. |
| Use Undo immediately when something looks wrong | Continuing to edit can make it harder to identify and reverse the original mistake. | Press Ctrl + Z on Windows or Command + Z on Mac as soon as you notice the problem. |
| Use the ribbon as a learning tool | The ribbon helps you discover commands that do not have a simple or memorable shortcut. | On Windows, press Alt to display Key Tips. On Mac, use F6 and Tab to explore ribbon commands. |
| Keep Windows and Mac commands separate | Modifier keys and available commands are not always equivalent across the two platforms. | Focus on the platform you use daily and treat the other column as a reference when collaborating or changing computers. |
| Prefer consistency over memorizing everything | A small set of reliable shortcuts is more useful than many commands you cannot recall under pressure. | Build a personal core set based on the Excel tasks you perform most often. |
Common questions answered
Frequently Asked Questions
Find quick answers about shortcut compatibility, laptop keyboards, Excel versions, regional layouts, and effective learning methods.
| Question | Answer |
|---|---|
| Do Windows and Mac use the same Excel shortcuts? | Some shortcuts are identical, but many use different modifier keys. Windows commonly uses Ctrl and Alt, while Mac may use Command, Option, or Control. Always check the correct platform column. |
| Why does an F-key change volume or open another application? | Many laptops assign hardware controls or manufacturer utilities to F1–F12. Hold Fn while pressing the key or enable Fn Lock so the top row works as standard function keys. |
| Why does F12 not open Save As on my laptop? | Your computer may have assigned another action to F12. Try Fn + F12. You can also use Ctrl + Shift + S where supported, or open Save As from Excel’s File menu. |
| Why do the arrow keys scroll instead of changing cells? | Scroll Lock is probably enabled. Turn it off using the keyboard or the Windows On-Screen Keyboard if your physical keyboard has no Scroll Lock key. |
| Do these shortcuts work in Excel for the web? | Many common shortcuts work, but browser commands can take priority and some desktop features are unavailable. Make sure the workbook is in Editing mode before testing an editing command. |
| Why does a symbol shortcut not match my keyboard? | Shortcut documentation commonly follows a US keyboard layout. Symbols such as ~, #, @, and $ may be located on different keys in other regional layouts. |
| Can I create custom keyboard shortcuts in Excel? | Excel does not provide a simple custom shortcut for every command. On Windows, frequently repeated tasks can be recorded as macros and assigned keyboard combinations. Be careful not to replace familiar built-in shortcuts. |
| What is the fastest way to learn Excel shortcuts? | Start with three to five commands that match tasks you perform every day. Use them repeatedly for a week before adding another group. Task-based practice is more effective than memorizing a long list. |
| What is the difference between plus signs and commas in shortcuts? | A plus sign means press the keys together. For example, Ctrl + C. A comma or arrow between keys means press them in sequence, such as Alt, then W, then L. |
| Why does Ctrl+A select only part of the worksheet? | When the active cell is inside a populated range or table, the first press may select only that data region. Press the shortcut again to expand the selection toward the entire worksheet. |
| Why does F4 behave differently while editing a formula? | In normal worksheet mode, F4 can repeat a supported action. While a cell reference is selected inside a formula, F4 cycles between relative, absolute, and mixed references. |
| Are keyboard shortcuts safe to test in an important workbook? | Navigation commands are generally safe, but insert, delete, fill, sort, refresh, and paste commands can change data. Save first or practice unfamiliar commands in a disposable workbook. |
Keep learning
Official Excel Resources
Use these official Microsoft resources to confirm shortcuts, explore Excel functions, learn formula fundamentals, and develop more advanced data-analysis skills.
| Resource | Best for | Official guide |
|---|---|---|
| Excel Keyboard Shortcuts | Checking Windows, Mac, web, accessibility, and function-key commands directly against Microsoft’s current reference. | View shortcut reference |
| Excel Help & Learning | Finding Microsoft tutorials about formulas, formatting, collaboration, data analysis, and troubleshooting. | Explore Excel help |
| Excel Functions by Category | Browsing functions by purpose, including logical, lookup, financial, statistical, text, date, and array functions. | Browse functions |
| Overview of Excel Formulas | Understanding functions, cell references, operators, constants, formula syntax, and calculation fundamentals. | Learn formula basics |
| Basic Tasks in Excel | Learning how to create workbooks, enter and format data, perform calculations, sort information, and create charts. | View beginner guide |
| Power Query and Power Pivot | Moving beyond basic worksheets to import, transform, model, and analyze larger collections of data. | Explore advanced tools |
Add context and collaborate
Comments and Notes
Add simple cell annotations with notes or use threaded comments to discuss worksheet content with other people.
Shift+F2Ctrl+Shift+F2Ctrl+EnterAlt, Z, CPress the keys in sequence.Alt, R, NPress the keys in sequence.Alt, R, VPress the keys in sequence.Esc