Excel Shortcuts like Ctrl+N (New Workbook), Ctrl+s (save), Ctrl+P (Print), Ctrl+H (Replace), F7 (Spell check) are some of the most common shortcuts people use, but there is more that can make your Excel life easy. We have categorized and grouped these Excel shortcuts by the kind of job you are doing in Excel.
These shortcuts simplify moving around an Excel spreadsheet, whether you’re inputting data, styling cells, or handling MS Excel operations like text functions in Excel and data validation in Excel. Once you begin utilizing a handful of every task, from modifying cells to handling shortcut Excel formulas becomes significantly easier. This technique is among the efficient methods to enhance productivity, particularly for those relying on Excel basics for assignments, projects, reports, or professional duties.
100+ Excel Shortcuts for Windows and Mac
Here are the most practical shortcuts you can realistically use in your day-to-day Excel work.
General Shortcuts
| Action | Windows Excel Shortcuts | Mac Excel Shortcuts |
| New Workbook | Ctrl + N | Cmd + N |
| Open Workbook | Ctrl + O | Cmd + O |
| Save | Ctrl + S | Cmd + S |
| Save As | F12 | Cmd + Shift + S |
| Ctrl + P | Cmd + P | |
| Close Workbook | Ctrl + W | Cmd + W |
| Quit Excel | Alt + F4 | Cmd + Q |
| Undo | Ctrl + Z | Cmd + Z |
| Redo | Ctrl + Y | Cmd + Y |
| Copy | Ctrl + C | Cmd + C |
| Cut | Ctrl + X | Cmd + X |
| Paste | Ctrl + V | Cmd + V |
| Select All | Ctrl + A | Cmd + A |
| Find | Ctrl + F | Cmd + F |
| Replace | Ctrl + H | Cmd + Shift + H |
| Go To | Ctrl + G / F5 | Cmd + G |
| Spell Check | F7 | Cmd + Shift + ; |
Navigation Shortcuts
| Action | Windows Excel Shortcuts | Mac Excel Shortcuts |
| Move One Cell | Arrow Keys | Arrow Keys |
| Jump to Data Edge | Ctrl + Arrow | Cmd + Arrow |
| Go to A1 | Ctrl + Home | Fn + Cmd + Left |
| Go to Last Cell | Ctrl + End | Fn + Cmd + Right |
| Page Up / Down | Page Up / Page Down | Fn + Up / Fn + Down |
| Move Screen Left / Right | Alt + Page Up / Alt + Page Down | Fn + Shift + Up / Fn + Shift + Down |
| Next Sheet | Ctrl + Page Down | Cmd + Page Down |
| Previous Sheet | Ctrl + Page Up | Cmd + Page Up |
Row & Column Operations
| Action | Windows Excel Shortcuts | Mac Excel Shortcuts |
| Select Column | Ctrl + Space | Ctrl + Space |
| Select Row | Shift + Space | Shift + Space |
| Insert Row or Column | Ctrl + Shift + Plus | Cmd + Shift + K |
| Delete Row or Column | Ctrl + Minus | Cmd + Minus |
| Hide Row | Ctrl + 9 | Cmd + 9 |
| Hide Column | Ctrl + 0 | Cmd + 0 |
| Unhide Row | Ctrl + Shift + 9 | Cmd + Shift + 9 |
| Unhide Column | Ctrl + Shift + 0 | Cmd + Shift + 0 |
| Auto Fit Column | Alt + H + O + I | Cmd + Option + I |
| Auto Fit Row | Alt + H + O + A | Cmd + Option + J |
Formatting Shortcuts
| Action | Windows excel shortcuts | Mac excel shortcuts |
| Format Cells Dialog | Ctrl + 1 | Cmd + 1 |
| Bold | Ctrl + B | Cmd + B |
| Italic | Ctrl + I | Cmd + I |
| Underline | Ctrl + U | Cmd + U |
| Add Border | Ctrl + Shift + 7 | Cmd + Option + 0 |
| Remove Border | Ctrl + Shift + Underscore | Cmd + Shift + Underscore |
| Fill Color | Alt + H + H | Cmd + Shift + H |
| Increase Font Size | Ctrl + Shift + Greater | Cmd + Shift+ Greater |
| Decrease Font Size | Ctrl + Shift+ Less | Cmd + Shift + Less |
| Number Format | Ctrl + Shift + 1 | Cmd + Shift + 1 |
| Time Format | Ctrl + Shift + 2 | Cmd + Shift + 2 |
| Date Format | Ctrl + Shift + 3 | Cmd + Shift + 3 |
| Currency Format | Ctrl + Shift + 4 | Cmd + Shift + 4 |
| Percent Format | Ctrl + Shift + 5 | Cmd + Shift + 5 |
| Scientific Format | Ctrl + Shift + 6 | Cmd + Shift + 6 |
Editing and Data Excel Shortcuts
| Action | Windows excel shortcuts | Mac excel shortcuts |
| Edit Cell | F2 | Ctrl + U |
| Fill Down | Ctrl + D | Cmd + D |
| Fill Right | Ctrl + R | Cmd + R |
| Insert Comment | Shift + F2 | Cmd + Shift + M |
| Delete Comment | Ctrl + Shift + F10 | Cmd+Shift+F10 |
| New Line in Cell | Alt + Enter | Option + Cmd + Enter |
| Clear Contents | Delete | Delete |
| Select Entire Table | Ctrl + T | Cmd + T |
| Convert to Table | Ctrl + L | Cmd + L |
| Expand Selection | Ctrl + Shift + Arrow | Cmd + Shift + Arrow |
| Data Validation | Alt + A + V + V | Cmd + Semicolon |
Formula Shortcuts
| Action | Windows Excel Shortcuts | Mac Excel Shortcuts |
| Insert Function | Shift + F3 | Cmd + Shift + A |
| Toggle Absolute/Relative | F4 | Cmd + T |
| Calculate All | F9 | Fn + Cmd + Equals |
| Auto Sum | Alt + Equals | Cmd + Shift + T |
| Show Formula Bar | Ctrl + Shift + U | Cmd + Shift + U |
| Show Formulas | Ctrl + Grave | Cmd + Grave |
| Complete Entry | Enter | Enter |
Worksheet and Workbook Shortcuts
| Action | Windows excel shortcuts | Mac excel shortcuts |
| New Sheet | Shift + F11 | Fn + Shift + F11 |
| Switch Workbook | Ctrl + Tab | Cmd + Tab |
| Next Sheet | Ctrl + Page Down | Cmd + Page Down |
| Previous Sheet | Ctrl + Page Up | Cmd + Page Up |
| Rename Sheet | Alt + H + O + R | Cmd + Shift + K |
| Delete Sheet | Alt + H + D+ S | Cmd + Shift + K + Delete |
Selection Shortcuts
| Action | Windows excel shortcuts | Mac excel shortcuts |
| Select Entire Worksheet | Ctrl + A twice | Cmd + A twice |
| Select to Start of Row | Shift + Home | Shift + Fn + Left |
| Select to End of Row | Shift + End | Shift + Fn + Right |
| Select to Start of Column | Ctrl + Shift + Up | Cmd + Shift + Up |
| Select to End of Column | Ctrl + Shift + Down | Cmd + Shift+ Down |
Advanced Excel Shortcuts
| Action | Windows Excel Shortcuts | Mac Excel Shortcuts |
| Flash Fill | Ctrl + E | Cmd + E |
| Insert PivotTable | Alt + N + V | Cmd + Option + P |
| Refresh Data | Ctrl + Alt + F5 | Cmd + Option + F5 |
| Create Chart | Alt + F1 | Fn + F1 |
| Insert New Comment | Shift + F2 | Cmd + Shift + M |
| Group Rows or Columns | Alt + Shift + Right | Cmd + Shift + K |
| Ungroup Rows or Columns | Alt + Shift + Left | Cmd + Shift + J |
| Zoom In | Ctrl + Mouse Wheel | Cmd + Mouse Wheel |
| Freeze Panes | Alt + W + F + F | Cmd + Shift + R |
Additional Excel Shortcuts
| Action | Windows Excel Shortcuts | Mac Excel Shortcuts |
| Insert Hyperlink | Ctrl + K | Cmd + K |
| Open Format Painter | Ctrl + Shift + C | Cmd + Shift + C |
| Apply Format Painter | Ctrl + Shift + V | Cmd + Shift + V |
| Insert Today Date | Ctrl + Semicolon | Cmd + Semicolon |
| Insert Current Time | Ctrl + Shift + Semicolon | Cmd + Shift + Semicolon |
| Insert New Worksheet | Shift + F11 | Fn + Shift + F11 |
| Toggle Full Screen | Ctrl + Shift + F1 | Cmd + Control + F |
| Open Name Manager | Ctrl + F3 | Cmd + F3 |
| Create Named Range | Ctrl + Shift + F3 | Cmd + Shift + F3 |
| Open Macro Window | Alt + F8 | Option + F8 |
Conclusion
Becoming proficient with Excel shortcuts is one of the methods to enhance both your efficiency and precision within any Excel spreadsheet. Whether handling datasets processing information with Excel formulas or arranging reports, in MS Excel these rapid key commands enable you to operate more efficiently with minimal effort. The frequently you use these Excel shortcut keys, the more intuitive and smoother they become during actual work.
If you’re just beginning with excel basics or aiming to go beyond operations begin by practicing five to ten shortcuts daily. Enough you’ll notice how quickly you can move through any Excel sheet without relying on the mouse. Download this PDF file of Excel shortcuts for future reference.
Explore more helpful tools, ready to use templates and step by step guides on Budget Excel to simplify your daily tasks.
FAQs
Excel shortcuts speed up your work by reducing clicks and helping you navigate, format, and calculate faster with fewer errors.
Why are Excel shortcuts important?
Excel shortcuts accelerate your tasks by minimizing the clicks required for functions. Then searching through menus, you can quickly navigate an excel sheet, format cells or insert excel formulas in a matter of seconds. These excel shortcut keys increase efficiency reduce errors and make navigating any excel spreadsheet easier. They are particularly beneficial, for those who use MS Excel regularly and aim for a streamlined productive workflow.
What is F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12 in Excel?
Function keys serve as native excel shortcuts enabling you to complete tasks:
- F1 Open Excel Help
- F2 Edit active cell
- F3 Paste a defined name
- F4 Repeat last action or lock references in excel formulas
- F5 Open Go To
- F6 Switch between window panes
- F7 Spell check the excel sheet
- F8 Extend selection
- F9 Calculate workbook in MS Excel
- F10 Activate the menu bar
- F11 Create a chart
- F12 Open Save As
What are the 7 basic Excel formulas?
Here are the most common excel formulas beginners use while learning excel basics:
- SUM Add numbers
- AVERAGE Get the mean
- COUNT Count numbers
- COUNTA Count non empty cells
- IF Logical test
- VLOOKUP Search for data
- CONCAT Join text
These formulas support everything from simple calculations to everyday reporting.
How to list from A to Z in Excel?
There are two simple ways to list A to Z in an excel spreadsheet:
Method 1: Auto Fill
- Type A in the first cell
- Type B in the next
- Select both
- Drag the fill handle down until Z appears
Method 2: Formula
Use this formula:
=CHAR(ROW(A65))
Drag it down from row 65 to row 90 to list A through Z.
How to list 1 to 100 in Excel?
You can list numbers from 1 to 100 in an excel sheet easily.
Method 1: Auto Fill
- Type 1
- Type 2 below it
- Select both
- Pull the fill handle until it reaches 100
Method 2: Formula
Use this formula:
=SEQUENCE (100,1,1,1)
This instantly fills numbers 1 to 100.