Gyansetu Team 
Do you find yourself spending too much time clicking through Excel’s menus and ribbons? Well, there’s a faster way to navigate through excel keyboard shortcuts Excel has over 200 keyboard shortcuts that can help you streamline your work and increase your productivity.
With these Excel Keyboard shortcuts, you can quickly perform basic navigation tasks, as well as complex calculations and data analysis. So, if you’re looking to boost your Excel skills and speed up your work, it’s time to learn some Excel keyboard shortcuts.
Workbook Related Shortcuts
| Function | Windows Shortcut | Mac Shortcut |
| Create a new blank Workbook | Ctrl + N | ⌘ + N |
| Opens the Print Preview Window | Ctrl + F2 | ⌘ + P |
| Saves the Workbook with its current file name, location, and file type | Ctrl + S | ⌘ + S |
| Displays the Open Dialog box to Open/Find a file | Ctrl + O | ⌘ + O |
| Opens the Save As dialog box | F12 | ⌘ + ⇧ + S |
| Maximize or Restore Selected Workbook Window | Ctrl + F10 | |
| Switch to the Previous Workbook | Ctrl + Shift + Tab | |
| Switch to the Next Workbook | Ctrl + Tab | |
| Minimize Workbook | Ctrl + F9 |
Excel Cell Editing Shortcut
| Function | Shortcut |
| Select one Word on the Left of the Cursor | Ctrl Shift ← |
| Delete One Character on the Left of the Cursor | Backspace |
| Select one Word on the Right of the Cursor | Ctrl Shift → |
| Select One Character on the Left of the Cursor | SHIFT ← |
| Delete One Character on the Right of the Cursor | Delete |
| Jump one Word on the Right of the Cursor | Ctrl → |
| Edit Active Cell | F2 |
| Delete to the End of the line (from the cursor) | Ctrl + Delete |
| Select One Character on the Right of the Cursor | SHIFT → |
| Start a New Line in the Same Cell | ALT + ENTER |
| Cancel Entry | Esc |
Hide/Unhide (Rows, Columns, Objects) Shortcuts
| Function | Windows Shortcut |
| Hide Selected Rows | Ctrl + 9 |
| Hide Selected Columns | Ctrl + 0 |
| Unhide Hidden Rows in Selection | Ctrl + Shift + 9 |
| Unhide Hidden Columns in Selection | Ctrl + Shift + 0 |
| Show/Hide Objects | Ctrl + 6 |
Navigation Shortcuts in Excel
| Function | Shortcut |
| Go to the First Cell in the Current Region | Ctrl + Home |
| Move One Screen to the Right | Alt + PageDown |
| Move to the Bottom-right used Cell in the Worksheet | Ctrl + End |
| Move to the Right Edge of the Data Region | Ctrl → |
| Down One Screen | PageDown |
| Move One Cell to the Left | ← |
| Move to the Bottom edge of the data region | Ctrl ↓ |
| Move to the Previous Worksheet | Ctrl + PageUp |
| Move One Cell Up | ↑ |
| Move to Next Worksheet | Ctrl + PageDown |
| Move to the Beginning of the Row | Home |
| Move One Cell Down | ↓ |
| Up One Screen | PageUp |
| Move One Screen to the Left | Alt + PageUp |
| Move One Cell to the Right | → |
| Move to the Top Edge of Data Region | Ctrl ↑ |
General Excel Keyboard Shortcuts
| Function | Shortcut |
| Display the Print Menu | Ctrl + P |
| Turn On End Mode | End |
| Activate Filter (when the cell with filter is selected) | Alt + ↓ |
| Spell Check | F7 |
| Calculate Active Worksheet | Shift + F9 |
| Display Go To Dialog Box | Ctrl + G |
| Undo | Ctrl + Z |
| Repeats the Last Action | F4 |
| Apply Data Filter | Ctrl + Shift + L |
| Display Go To Dialog Box | F5 |
| Opens Help | F1 |
| Recalculate All Workbooks | F9 |
| Repeats the last command or action | Ctrl + Y |
Cut, Copy, and Paste Shortcuts in Excel
| Function | Shortcut |
| Copy Selected Cells | Ctrl + C |
| Display Paste Special Dialog Box | Ctrl + Alt + V |
| Paste Content from the Clipboard | Ctrl + V |
| Copy Formula from the Cell Above | Ctrl + ‘ |
| Copy Value from the Cell Above | Ctrl + SHIFT + ‘ |
| Cut Selected Cells | Ctrl + X |
Extending the Selection Shortcuts
| Function | Windows Shortcut |
| Extend Selection to the Right by One Cell | Shift + → |
| Extend Selection to the Left by One Cell | Shift + ← |
| Extend Selection Upwards by One Cell | Shift + ↑ |
| Extend Selection Downwards by One Cell | Shift + ↓ |
| Extend the Selection to the Right till the Last Cell | Ctrl + Shift + → |
| Extend the Selection to the Left till the Last Cell | Ctrl + Shift + ← |
| Extend the Selection Upwards to the Last Cell | Ctrl + Shift + ↑ |
| Extend Selection Upwards by One Screen | Shift + PageUp |
| Extend Selection Downwards by One Screen | Shift + PageDown |
| Extend Selection to the Right by One Screen | ALT + Shift + PageUp |
| Extend Selection to the Left by One Screen | ALT + Shift + PageDown |
| Extend Selection to the Start of the Row | Shift + Home |
| Extend Selection to First Cell in the Worksheet | Ctrl + Shift + Home |
| Extend Selection to the Last Cell in the Worksheet | Ctrl + Shift + End |
| Toggle Extend Selection Mode | F8 |
Data Entry Shortcuts in Excel
| Function | Shortcut |
| Fill Down | Ctrl + D |
| Insert Current Date | Ctrl + ; |
| Enter and Move Left | Shift + Tab |
| Display AutoComplete list | Alt + ↓ |
| Fill Right | Ctrl + R |
| Cancel Cell Entry | ESC |
| Enter and Move Down | Enter |
| Enter and Remain on the Same Cell | Control + Enter |
| Enter and Move right | Tab |
| Enter and Move Up | Shift + Enter |
| Start a New Line in the Same Cell | Alt + Enter |
| Enter Same Data in All Selected Cells | Control + Enter |
| Insert Current Time | Ctrl + Shift + ; |
Clear Shortcuts in Excel
| Function | Windows Shortcut |
| Clear Everything | Alt + H + E + A |
| Clear Formats Only | Alt + H + E + F |
| Clear Content Only | Alt + H + E + C |
| Clear Hyperlinks Only | Alt + H + E + L |
| Clear Comments Only | Alt + H + E + M |
Conditional Formatting Shortcuts
| Function | Windows Shortcut |
| Open Conditional Formatting Dialog Box | Alt O D |
| Clear Conditional from Selected Cells | Alt H L C S |
| Clear Conditional from the Entire Worksheet | Alt H L C E |
Selection Shortcuts in Excel
| Function | Windows Shortcut |
| Select All Cells that Contain Comments | Ctrl + Shift + O |
| Select Row Differences | Ctrl + |
| Select Current Region Around the Active Cell | Ctrl + Shift + * |
| Select Direct Precedents | Ctrl + [ |
| Select Direct Dependents | Ctrl + ] |
| Select Visible Cells in the Current Region | Alt + ; |
| Select Entire Row | Shift + Space |
| Select Entire Column | Ctrl + Space |
| Select the Current Region / Select All | Ctrl + A |
| Select all Dependents | Ctrl + Shift + } |
| Select all Precedents | Ctrl + Shift + { |
| Select Column Differences | Ctrl + Shift + | |
Alignment Shortcuts
| Function | Windows Shortcut |
| Align Content to the Left of the Cell | Alt + H + A + L |
| Align Content to the Right of the Cell | Alt + H + A + R |
| Align Content to the Center of the Cell | Alt + H + A + C |
| Align Content to the Middle of the Cell | Alt + H + A + M |
Insert Shortcuts
| Function | Windows Shortcut |
| Insert New Line in the Same Cell | Alt + Enter |
| Insert New Worksheet | Shift + F11 |
| Insert Row/Cell (shows a dialog box) | Ctrl + Shift + = |
| Insert Current Date | Ctrl + ; |
| Insert Current Time | Ctrl + Shift + ; |
| Insert Table | Ctrl + T |
| Insert Hyperlink | Ctrl + K |
| Insert Argument Names into Formula | Ctrl + Shift + A |
| Insert/Edit Cell Comment | Shift + F2 |
| Delete Row/Cell (shows the dialog box) | Ctrl – |
Formatting Shortcuts in Excel
| Function | Windows Shortcut |
| Remove Indent | Alt H 5 |
| Displays the Format Style Dialog Box | Alt + ‘ |
| Apply the Percentage Format with No Decimal Places | Ctrl + Shift + % |
| Displays the Font Dialog Box | Shift + Ctrl + F |
| Apply the Date format with the Day, Month, and Year | Ctrl + Shift + # |
| Apply the General Number Format | Ctrl + Shift + ~ |
| Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values | Ctrl + Shift + ! |
| Apply Strikethrough Format | Ctrl + 5 |
| Underline Text | Ctrl + U |
| Insert New Worksheet | Shift + F11 |
| Apply the Currency Format with Two Decimal Places | Ctrl + Shift + $ |
| Place outline Border around the Selected Cells | Ctrl + Shift + 7 |
| Make Text Bold | Ctrl + B |
| Make Text Italics | Ctrl + I |
| Remove Outline Border | Ctrl + Shift + _ |
| Increase Font Size by One Step | Alt H F G |
| Insert/Edit Cell Comment | Shift + F2 |
| Apply Indent | Alt H 6 |
| Decrease Font Size by One Step | Alt H F K |
| Insert Current Time | Ctrl + Shift + ; |
| Insert Table | Ctrl + T |
| Insert New Line in the Same Cell | Alt + Enter |
| Insert Current Date | Ctrl + ; |
| Insert Hyperlink | Ctrl + K |
| Delete Row/Cell (shows the dialog box) | Ctrl – |
| Insert Row/Cell (shows a dialog box) | Ctrl + Shift + = |
Named Ranges Shortcuts
| Function | Windows Shortcut |
| Get a List of All Defined Named Ranges | F3 |
| Create Named Range from Selection | Ctrl + Shift + F3 |
| Define Name Dialog Box | Ctrl + F3 |
Excel Formula-Related Shortcuts
| Function | Shortcut |
| Insert Autosum Formula | Alt + = |
| Toggle Value/Formula display | Ctrl + ` |
| Display the Insert Function Dialog Box | Shift + F3 |
| Evaluate Part of the Formula | F9 |
| Expand/Collapse Formula Bar | Ctrl + Shift + U |
| Select All Cells Directly or Indirectly Referenced by Formulas | Ctrl + [ |
| Select Cells that Contain Formulas that Directly or Indirectly Ref… | Ctrl + ] |
| Enter a Formula as an Array Formula | Ctrl + Shift + Enter |
| While Typing a Formula, Switches Cell Reference from Absolute to R… | F4 |
| Rechecks dependent formulas and then calculates all cells in all t… | Ctrl + Alt + Shift + F9 |
| Select the Array Containing the Active Cell | Ctrl + / |
Find and Replace Shortcuts
| Function | Windows Shortcut |
| Display Find and Replace Dialog Box (Find Selected) | Ctrl + F |
| Display Find and Replace Dialog Box (Replace Selected) | Ctrl + H |
| Find Next Match | Shift + F4 |
| Find the Previous Match | Ctrl + Shift + F4 |
Drag (Mouse) Shortcuts
| Function | Windows Shortcut |
| Drag and Copy the selected cells | Ctrl + Drag |
| Drag and Cut the selected cells | Drag |
| Duplicate Worksheet | Ctrl + Drag |
| Switch Position of Cells/Rows/Columns | Shift + Drag |
Pivot Table Shortcuts
| Function | Shortcut |
| Select Entire Pivot Table (excluding Report Filters) | Ctrl + A |
| Open Pivot Table Wizard | Alt + D + P |
| Display Insert Pivot Table Dialog Box | Alt + N + V |
| Select the Next Item in PivotTable Field List or Items List | ↓ |
| Select a Previous Item in PivotTable Field List or Items List | ↑ |
| Select Last Visible Item in List | End |
| Select First Visible Item in List | Home |
| Open Field List for Active Cell | Alt + ↓ |
| Add/Remove Checkmark for Selected Field in PivotTable Field List | Space |
| Hide Selected Item or Field | Ctrl + – |
| Group Selected Pivot Table Items | Alt + Shift + → |
| UnGroup Pivot Table Items | Alt + Shift + ← |
| Opens Calculated Field dialog box (when the data field is selected) | Shift + Ctrl + = |
| Opens Calculated Item Dialog box (when field heading cell is Selected) | Shift + Ctrl + = |
Charting Shortcuts
| Function | Windows Shortcut |
| Inserts Chart in the Worksheet (using the selected data) | Alt + F1 |
| Inserts a ChartSheet with a Chart (using the selected data) | F11 |
VBA Shortcuts
| Function | Windows Shortcut |
| Opes the VBA Editor and also switches between Excel Worksheet and the VBA editor | Alt + F11 |
| Open VB Help | F1 |
| View Object Browser | F2 |
| View Properties | F4 |
| View Code window | F7 |
| View Immediate window | Ctrl + G |
| View Shortcut Menu | Shift + F10 |
| Run a Sub/UserForm | F5 |
| Step Into the code | F8 |
| Step Over | Shift + F8 |
| Step Out | Ctrl + Shift + F8 |
| Run to Cursor | Ctrl + F8 |
| Toggle Breakpoint | F9 |
| Clear All Breakpoints | Ctrl + F9 |
| Close VBA Editor and Return to the Excel Worksheet | Alt + Q |
Others Shortcuts
| Function | Windows Shortcut |
| Move Window | Ctrl + F7 |
| Resize Window | Ctrl + F8 |
| Restore Window Size | Ctrl + F5 |
| Next Pane | F6 |
| Previous Pane | F8 |
| Display Shortcut Menu | Shift + F6 |
| Next Window | Ctrl + F6 |
| Extend Mode | Shift + F10 |
| Turns On the Add to Selection Mode | Shift + F8 |
CONCLUSION
So, Excel keyboard shortcuts can be a game-changer for anyone who uses Excel on a regular basis. With over 200 excel keyboard shortcuts available, you can quickly navigate through menus and ribbons, perform calculations, and analyse data with ease.
By mastering these Excel keyboard shortcuts, you can save yourself a lot of time and increase your productivity in Excel. So, if you’re looking to improve your Excel skills, take the time to learn some of these Excel keyboard shortcuts. You’ll be surprised at how much faster and more efficient you can be in Excel! Yes, Gyansetu
