| Shortcut | Function | How to Use | Why It's Useful |
|---|---|---|---|
| Ctrl + N | New Workbook | Press Ctrl and N together | Quickly starts a new blank Excel file |
| Ctrl + O | Open Workbook | Press Ctrl and O together | Access recent or saved files instantly |
| Ctrl + S | Save Workbook | Press Ctrl and S anytime | Prevents data loss by saving progress |
| Ctrl + Page Up / Page Down | Switch Worksheets | Use Ctrl with Page Up or Page Down | Navigates between sheets without mouse |
| Double-click on sheet tab | Rename Sheet | Double-click the tab name | Quickly change the sheet name for clarity |
| Right-click sheet → Insert/Delete | Insert/Delete Sheet | Right-click on any sheet tab | Manage sheets easily by adding/removing |
| Review tab → Protect Sheet | Protect Sheet | Use Review tab in Ribbon | Prevents changes to data or layout |
| Ctrl + F4 | Close Workbook | Press Ctrl and F4 | Quickly exits the current workbook |
| Ctrl + Tab | Switch Workbooks | Hold Ctrl and press Tab | Switch between open files quickly |
| Alt + F11 | Open VBA Editor | Press Alt and F11 | Write or debug macros (advanced users) |
| Ctrl + F6 | Next Workbook Window | Use Ctrl + F6 | Cycle through multiple open workbooks |
| Shift + F11 | Insert New Worksheet | Press Shift and F11 | Adds a new sheet instantly |
| Alt + H, D, S | Delete Sheet | Use Alt navigation to delete | Removes unwanted sheets from the workbook |
| Alt + E, L | Rename Sheet (Legacy) | Follow Alt key path | Used in older Excel versions |
| Alt + H, O, R | Rename Sheet (Ribbon) | Use Alt, then H, O, R | Renames using keyboard navigation |
| Alt + T, P, P | Protect Sheet Dialog | Alt → T → P → P | Enables sheet protection options |
| Alt + F8 | Run Macro | Press Alt and F8 | Access and run saved macros |
| Shortcut / Action | Feature | How to Use | Why It's Useful |
|---|---|---|---|
| Drag the fill handle | Auto Fill | Select a cell, drag the bottom-right corner | Automatically fills series or patterns |
| Ctrl + E | Flash Fill | Enter data in pattern, press Ctrl + E | Automatically fills data based on patterns |
| Home tab → Number dropdown | Number Formatting | Select cell(s), choose format from dropdown | Formats values as currency, percentage, date, etc. |
| Home tab → Wrap Text | Wrap Text | Click on the Wrap Text icon | Displays all content within a cell neatly |
| Home tab → Merge & Center | Merge & Center | Select multiple cells, click Merge & Center | Combines cells and centers the text |
| Font group → Borders, Fill Color | Cell Borders & Shading | Select cells, apply border and fill options | Highlights and separates content visually |
| Home tab → Conditional Formatting | Conditional Formatting | Choose rules to highlight cells dynamically | Visualizes data trends and exceptions |
| Ctrl + ; | Insert Current Date | Press Ctrl + semicolon ( ; ) | Quickly inserts today's date |
| Ctrl + Shift + : | Insert Current Time | Press Ctrl + Shift + colon ( : ) | Quickly inserts current time |
| Ctrl + Shift + "$" | Apply Currency Format | Press Ctrl + Shift + 4 | Formats numbers as currency |
| Ctrl + Shift + "%" | Apply Percentage Format | Press Ctrl + Shift + 5 | Formats numbers as percentages |
| Ctrl + Shift + "#" | Apply Date Format | Press Ctrl + Shift + 3 | Formats cell as a date |
| Ctrl + B | Bold Text | Select text/cell, press Ctrl + B | Highlights content with bold style |
| Ctrl + I | Italic Text | Select text/cell, press Ctrl + I | Applies italic style for emphasis |
| Ctrl + U | Underline Text | Select text/cell, press Ctrl + U | Adds underline for importance |
| Alt + H, H | Fill Cell Color | Use Alt key navigation | Adds background color to cells |
| Alt + H, B | Apply Borders | Use Alt → H → B via keyboard | Organizes data with clear borders |
| Shortcut / Action | Feature | How to Use | Why It's Useful |
|---|---|---|---|
| Shift + F3 | Insert Function | Place cursor in a cell and press Shift + F3 | Opens the function dialog box for help with formulas |
| Alt + = | AutoSum | Select a cell below a column of numbers, press Alt + = | Quickly adds values above the selected cell |
| SUM, AVERAGE, IF, VLOOKUP, INDEX, MATCH | Common Functions | Type = followed by function name (e.g., =SUM(A1:A5)) | Used for calculations, lookups, and conditional logic |
| Formulas tab → Trace Precedents | Formula Auditing | Go to Formulas tab and click Trace Precedents | Helps visualize which cells affect a formula |
| Formulas tab → Define Name | Named Ranges | Select cells, go to Formulas → Define Name | Makes formulas more readable and manageable |
| F2 | Edit Formula | Select cell and press F2 | Allows in-place editing of cell formulas |
| Ctrl + ` | Show Formulas | Press Ctrl + backtick (`) to toggle formula view | Displays formulas instead of results in cells |
| Ctrl + Shift + Enter | Array Formula | After typing formula, press Ctrl + Shift + Enter | Executes array operations over multiple cells |
| Alt + M, F, I | Insert Function Dialog | Use ribbon key sequence Alt → M → F → I | Accesses Insert Function box quickly via keyboard |
| Ctrl + Shift + U | Expand Formula Bar | Press Ctrl + Shift + U to toggle height of bar | Useful when writing long formulas |
| Alt + M, R | Trace Precedents | Use Alt ribbon keys to highlight source cells | Shows which cells a formula depends on |
| Alt + M, D | Trace Dependents | Use Alt ribbon keys to find dependent cells | Reveals which cells are affected by the formula |
| Alt + M, A | Remove Arrows | Go to Formulas tab → Remove Arrows | Clears auditing arrows from worksheet |
| Alt + M, N | Name Manager | Use Alt keys to open the Name Manager | Manage all named ranges in workbook |
| Alt + M, D | Define Name | Open Define Name window via ribbon keys | Assign meaningful names to ranges |
| Shortcut / Action | Feature | How to Use | Why It's Useful |
|---|---|---|---|
| Alt + F1 | Insert Chart | Press Alt + F1 to insert a default chart on the current sheet | Quickly visualize data without leaving keyboard |
| Insert tab → Choose Chart | Chart Types | Go to Insert tab and select desired chart type | Select the most appropriate chart for your data |
| Click + icon beside chart | Chart Elements | Click the plus icon next to chart to add/remove elements | Customize chart with titles, legends, gridlines easily |
| Design tab → Chart Styles | Chart Styles | Go to Design tab and pick a style | Enhance chart appearance for better presentation |
| F11 | Create Chart on New Sheet | Press F11 to create a chart on a separate sheet | Focus on the chart without worksheet clutter |
| Alt + N, R | Insert Recommended Charts | Press Alt, then N, then R to open recommended charts | Get suggested charts based on selected data |
| Alt + N, Q | Insert Quick Chart | Use Alt, N, Q to insert a quick default chart | Faster than manual chart creation steps |
| Alt + J, C | Customize Chart Elements | Press Alt, J, C to access chart element options | Add or remove titles, labels, legends, etc. |
| Alt + J, D | Change Chart Type | Press Alt, J, D to switch chart types | Adjust chart for better data visualization |
| Alt + J, T | Switch Row/Column | Use Alt, J, T to toggle data orientation in chart | Change how data is grouped for clearer insights |
| Alt + J, A | Add Chart Element | Press Alt, J, A to add elements like axis titles | Enhance chart information and readability |
| Alt + J, H | Move Chart | Use Alt, J, H to move chart to a different location or sheet | Organize workbook layout for better workflow |
| Alt + J, F | Format Chart Selection | Press Alt, J, F to open formatting options for selected chart part | Customize colors, fonts, borders, and styles |
| Alt + J, E | Edit Chart Data | Press Alt, J, E to edit the data source for the chart | Update chart automatically when data changes |
| Shortcut / Action | Feature | How to Use | Why It's Useful |
|---|---|---|---|
| Home tab → Sort & Filter | Sort & Filter | Go to Home tab and click Sort & Filter dropdown | Organize data quickly by sorting or filtering |
| Data tab → Data Validation | Data Validation | Open Data tab and select Data Validation option | Restrict input values to improve data accuracy |
| Data tab → Remove Duplicates | Remove Duplicates | Click Remove Duplicates in Data tab | Clean data by eliminating repeated entries |
| Data tab → Text to Columns | Text to Columns | Use Text to Columns in Data tab to split cell data | Separate combined data into multiple columns |
| Data tab → Flash Fill | Flash Fill | Go to Data tab and select Flash Fill | Automatically fill data based on pattern recognition |
| Alt + A, S, S | Sort A to Z | Press Alt, then A, then S, then S for ascending sort | Sort data alphabetically from A to Z |
| Alt + A, S, D | Sort Z to A | Press Alt, then A, then S, then D for descending sort | Sort data alphabetically from Z to A |
| Alt + A, T | Apply Filter | Use Alt + A + T to toggle filters on selected columns | Easily filter data to show only relevant rows |
| Alt + D, F, F | Advanced Filter | Press Alt, D, F, F to open advanced filter options | Perform complex filtering with criteria ranges |
| Alt + A, V, V | Data Validation Dialog | Press Alt, A, V, V to open validation dialog | Set rules to control cell input values |
| Alt + A, M | Remove Duplicates | Use Alt + A + M to open Remove Duplicates tool | Efficiently remove duplicate data entries |
| Alt + A, E | Text to Columns Wizard | Press Alt + A + E to launch the wizard | Split cell contents into multiple columns with options |
| Ctrl + Alt + L | Reapply Last Filter | Press Ctrl + Alt + L to refresh last applied filter | Quickly update filtered data view after changes |
| Alt + A, G | Group Data | Press Alt, A, G to group rows or columns | Organize related data for easy expansion/collapse |
| Alt + A, U | Ungroup Data | Press Alt, A, U to ungroup grouped data | Remove grouping to view data fully |