Excel Keyboard Shortcuts are the ultimate productivity boosters for anyone working with spreadsheets. Whether you’re navigating cells, formatting data, or performing complex calculations, mastering these shortcuts can save you time and effort. In this comprehensive guide, we’ve compiled the most essential shortcuts for PC and Mac users, making it easier than ever to streamline your workflow. From basic navigation to advanced formula editing, these Excel keyboard shortcuts are designed to help you work smarter, not harder. Dive in and discover how to unlock the full potential of Microsoft Excel!
Table of Contents
List of Excel Keyboard Shortcuts
| Category | Action | Keyboard Shortcut |
| Basic Navigation | Move to the next cell | Tab |
| Move to the previous cell | Shift + Tab | |
| Go to the beginning of a row | Home | |
| Go to the beginning of a worksheet | Ctrl + Home / Fn + Left | |
| Go to the last cell | Ctrl + End / Fn + Right | |
| Move one screen down | Page Down | |
| Move one screen up | Page Up | |
| Jump to a specific cell | Ctrl + G / F5 | |
| Move between open workbooks | Ctrl + Tab | |
| Selection Shortcuts | Select an entire column | Ctrl + Space |
| Select an entire row | Shift + Space | |
| Select the entire worksheet | Ctrl + A | |
| Extend selection by one cell | Shift + Arrow keys | |
| Select non-adjacent cells | Ctrl + Click | |
| Select visible cells only | Alt + ; | |
| Editing Basics | Copy | Ctrl + C |
| Cut | Ctrl + X | |
| Paste | Ctrl + V | |
| Undo | Ctrl + Z | |
| Redo | Ctrl + Y | |
| Insert a new worksheet | Shift + F11 | |
| Delete a worksheet | Alt + H + D + S | |
| Formatting | Bold text | Ctrl + B |
| Italicize text | Ctrl + I | |
| Underline text | Ctrl + U | |
| Open the Format Cells dialog box | Ctrl + 1 | |
| Apply or remove strikethrough | Ctrl + 5 | |
| Add or remove borders | Ctrl + Shift + 7 | |
| Increase font size | Alt + H + FG | |
| Decrease font size | Alt + H + FK | |
| Center align cell contents | Alt + H + AC | |
| Data Entry | Add the current date | Ctrl + ; |
| Add the current time | Ctrl + Shift + : | |
| Repeat last action | F4 | |
| Fill data down | Ctrl + D | |
| Fill data to the right | Ctrl + R | |
| Enter data into multiple cells | Ctrl + Enter | |
| Enable/disable Edit mode | F2 | |
| Formula Shortcuts | Show all formulas | Ctrl + ` |
| Insert a function | Shift + F3 | |
| Toggle absolute/relative references | F4 | |
| Calculate the worksheet | F9 | |
| Calculate all worksheets | Shift + F9 | |
| Evaluate part of a formula | F9 while editing | |
| Trace precedents | Ctrl + [ | |
| Trace dependents | Ctrl + ] | |
| Display the Insert Function dialog box | Shift + F3 | |
| Navigating Large Data | Jump to the end of a range | Ctrl + Arrow keys |
| Scroll horizontally | Alt + Page Up / Alt + Page Down | |
| Scroll vertically | Arrow keys | |
| Expand/collapse grouped rows/columns | Alt + Shift + (+/-) | |
| Tables & Filters | Insert a table | Ctrl + T |
| Open the filter drop-down | Alt + Down Arrow | |
| Apply or remove a filter | Ctrl + Shift + L | |
| Select visible cells only | Alt + ; | |
| Clear all filters | Alt + H + FC | |
| Pivot Tables | Open the PivotTable Field List | Alt + Shift + F1 |
| Group selected items | Alt + Shift + Right Arrow | |
| Ungroup selected items | Alt + Shift + Left Arrow | |
| Refresh PivotTable | Alt + F5 | |
| Move PivotTable field | Ctrl + Shift + Arrow keys | |
| Chart Tools | Create a chart | Alt + F1 |
| Edit chart title | F2 while title is selected | |
| Move chart to a new sheet | Alt + F11 | |
| File Management | Save | Ctrl + S |
| Open | Ctrl + O | |
| Ctrl + P | ||
| Close | Ctrl + W | |
| Open Excel Options | Alt + F + T | |
| Open Save As dialog box | F12 | |
| Search & Replace | Find | Ctrl + F |
| Replace | Ctrl + H | |
| Repeat last search | Shift + F4 |
Excel Keyboard Shorcuts
Mastering Excel Keyboard Shortcuts is a game-changer for boosting your efficiency and productivity. By incorporating these shortcuts into your daily workflow, you can save valuable time, reduce repetitive tasks, and focus on more critical aspects of your work. Whether you’re a beginner looking to learn the basics or an advanced user aiming to optimize your skills, these shortcuts are your key to becoming an Excel power user. Start practicing today and experience the difference! For more tips and tricks, explore our other guides and take your Excel expertise to the next level.