350+ Top Excel Shortcut Keys and Hotkeys

Excel is not only used by experts for crunching numbers, but also in organizing data, tracking projects, and analyzing trends. If you are new to the platform, navigating it is understandably difficult since it has so much to offer. But if you are figuring it out one click at a time, you’re missing out on some serious speed. That’s why knowing the top Excel shortcut keys and hotkeys is a game-changer. So, let’s show you the magic combos to make life easier!

Table of Contents

Top Excel Shortcut Keys and Hotkeys

Whether you’re a student, an accountant, or a data nerd, these shortcuts can completely change how you use Excel.

Ctrl + Z: Undo the last action.
F11: Insert a chart in a new sheet.
Ctrl + H: Display the find and replace with the Replace tab selected.
Shift + Space: Select Table row.
Alt + F1: Insert Embedded chart.
Ctrl + Shift + L: Toggle Auto filter.
Ctrl + V: Paste the Content from the clipboard.
Ctrl + 6: Hide or show objects.
Alt + F8: Open the Macro Dialog box.
Ctrl + Y: Redo the last action.
Ctrl + D: Duplicate object, Formula, Text.
F4: Repeat the last action.
Ctrl + F: Display the find and replace with the find tab selected.
Alt + (Arrow down button): Enable Filter.
Ctrl + A: Select the table when the active cell is in the table with this top Excel shortcut keys.
Alt + F11: Open VBA Editor.
Ctrl + Alt + V: Display the paste special dialog box.
Shift + F4: Find the next match.
F1: Open Help.
Ctrl + Shift + F4: Find the previous match.
Alt + ‘: Open the modify cell style dialog box.
Ctrl + T or Ctrl + L: Create Table.
F7: Run Spellcheck.
Alt + C: Clear Slicer Filter.
Ctrl + X: Cut the selected data.
Ctrl + C: Copy the Selected data.
Alt Space: Display control menu.
Shift + F10: Show right-click menu.
Alt: Snap to grid.
Ctrl + Space: Select Table column.

Excel Keyboard Shortcuts: Format

Now that you are done with basic shortcuts, let’s take a look at these top Excel shortcut keys for formatting style:

Alt + H + AC: Align text to the center (between left and right) of the cell.
Alt + H + 0: Increase the number of decimals displayed.
Alt + H + AL: Align text to the left of the cell.
Alt + B: Within the Border tab of the Format Cells dialog box, add/remove the bottom border.
Alt + H + AB: Align text to the bottom of the cell.
(Ctrl + Alt + V) + T or Alt + H + V + R: Paste format.
Alt + H: Within Border tab of Format Cells dialog box, and when more than 1 row is selected, add/remove horizontal interior border.
Alt + H + 9: Decrease the number of decimals displayed.
Alt + H + AN: Choose accounting format.
Alt + H + B + A: Apply borders to all sides of selected cells.
Ctrl + Shift + !: Format numbers with two decimal places and thousand separators.
Alt + H + M + M: Merge selected cells into one.
Ctrl + 5: Toggle strikethrough text formatting.
Alt + H + L + R: Open the Conditional Formatting Rules Manager.
Ctrl + Shift + #: Apply date formatting (day/month/year).
Alt + H + O + I: Automatically adjust column width to fit content.
Ctrl + T: Create a new table from selected data.
Alt + H + H + N: Remove fill color from selected cells.
Ctrl + Shift + ~: Reset cells to General number format.
Alt + H + FQ + V: Rotate text vertically in cells.
Ctrl + Alt + V + W: Adjust pasted content to match destination column widths.
Alt + H + 9: Reduce decimal places in numbers.
Ctrl + Shift + F: Open Font formatting options.
Alt + H + W: Enable text wrapping in cells.
Ctrl + Shift + $: Apply currency formatting with parentheses for negatives.
Alt + H + B + S: Add outside borders to selection.
F4: Repeat your last action.
Alt + H + J + N: Create a new cell style.
Ctrl + Shift + &: Add outer borders to selected cells.
Alt + H + L + C + S: Clear conditional formatting rules from selected cells.
Ctrl + U: Toggle underline text formatting.
Alt + H + O + A: Auto-adjust row height to fit content.
Ctrl + Shift + %: Format values as percentages without decimals.
Alt + H + B + N: Remove all borders from selection.
Ctrl + 1: Open full Format Cells dialog.
Alt + H + FC: Open font color selection menu.
Ctrl + Shift + @: Apply time formatting (HH: MM AM/PM).
Alt + H + M + U: Unmerge previously merged cells.
Ctrl + B: Toggle bold text formatting.
Alt + H + 6: Increase indent.
(Ctrl + Alt + V) + W or Alt + H + V + W: Paste column widths.
Alt + H + AM: Align text to the middle (between the top and bottom) of the cell.
Alt + H + 3 + D: Apply or remove double underlining.
Alt + D: Within Border tab of Format Cells dialog box, add/remove downward diagonal border.
Alt + H + 5: Decrease indent.
(Ctrl + Alt + V) + G or Alt + H + V + G: Paste merging the conditional formatting of the destination and source ranges.
Alt + H + AN + M: Display the Format Cells dialog box with the Number tab and the Accounting category selected.
Alt + H + B + U: Top and double bottom border.
Alt + H + B + H: Thick bottom border.
Alt + H + B + R: Right Border.
Alt + H + B + I: Choose border line color.
Alt + H + AR: Align text to the right of the cell.
Alt + H + B + M: Display the Format Cells dialog box with the Border tab selected.
Alt + H + B + G: Draw border grid.
Alt + H + B + A: All Borders.
Alt + H + B + O: Bottom Border.
Alt + H + B + E: Erase border.
Alt + H + AT: Align text to the top of the cell.
Alt + H + B + T: Thick box border.
Alt + H + B: Expand Borders drop-down menu.
Alt + H + B + L: Left Border.
Alt + H + B + D: Top and bottom border.
Alt + H + B + S or Ctrl + Shift + 7: Outside border.
Alt + H + B + C: Top and thick bottom border.
Alt + H + B + N or Ctrl + Shift + –: No Border.
Alt + H + B + P: Top Border.
Alt + H + B + W: Draw border.
Alt + H + B + B: Bottom double border.
Alt + H + FQ + V: Rotate text so that it is vertical.
Alt + H + FK: Decrease the font size by 1 point.
Alt + H + L + C + S: Clear conditional formatting rules from selected cells.
Alt + H + FC: Expand Font Color drop-down menu.
Alt + H + FQ + M or Alt + H + FA: Display the Format Cells dialog box with the Alignment tab selected.
Alt + H + FF: Change the font face.
Alt + H + H + N: Apply no fill color to current cell selection.
Alt + H + B + Y: Choose border line style.
Alt + H + L + C + E: Clear conditional formatting rules from the entire worksheet.
Alt + H + FS: Change the font size.
Alt + H + FQ + D: Rotate text down.
Alt + H + FG: Increase the font size by 1 point.
Alt + H + J + N: Display the Style dialog box to create a new cell style.
Alt + H + E + F: Clear formatting.
Alt + H + FM: Display the Format Cells dialog box with the Number tab selected.
Alt + H + FQ + O: Rotate text in an angle counterclockwise.
Alt + H + FN: Display the Format Cells dialog box with the Font tab selected with this top Excel shortcut keys.
Alt + H + FP: Activate the Format Painter.
Alt + H + K: Format number with a thousand’s comma (,) separator.
Alt + H + L + D: Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill.
Alt + H + FQ + L: Rotate text counterclockwise.
Alt + H + J: Expand the Cell Styles menu.
Alt + H + H: Expand Fill Color drop-down menu.
Alt + H + FQ + U: Rotate text up.
Alt + H + J + M: Display the Merge Styles dialog box to merge (copy) cell styles from another workbook.
Alt + H + FC: Choose font color.
Alt + H + L + C + P: Clear conditional formatting rules from the selected PivotTable (active when cell is within PivotTable).
Alt + H + L + C + T: Clear conditional formatting rules from the selected table (active when a cell is within a table).
Alt + H + L + H + G: Display the Greater Than dialog box for conditional formatting.
Alt + H + M + U: Unmerge cells.
Alt + H + O + I: Auto-fit column width.
Alt + H + L + H + D: Display the Duplicate Values dialog box.
Alt + H + L + T + P: Display the Top 10% dialog box.
Alt + H + L + H + M: Display the New Conditional Formatting Rule dialog box (Format only cells that contain).
Alt + H + T + N: Display the New Table Style dialog box.
Alt + H + L + T + B: Display the Bottom 10 Items dialog box.
Alt + H + L + D + M: Display the New Conditional Formatting Rule dialog box (Format all cells based on values).
Alt + H + M + A: Merge across cells.
Alt + H + L + H + E: Display the Equal To dialog box.
Alt + H + O + W: Display the Column Width dialog box.
Alt + H + L + I: Expand the icon sets menu for conditional formatting.
Alt + H + L + H + A: Display the A Data Occurring dialog box.
Alt + H + L + T + V: Display the Below Average dialog box.
Alt + H + W: Wrap text.
Alt + H + L + T + M: Display the New Conditional Formatting Rule dialog box (top/bottom ranked values).
Alt + H + L + H + B: Display the Between dialog box.
Alt + H + L + S: Expand the color scales menu for conditional formatting.
Alt + H + O + A: Auto-fit row height.
Alt + H + L + T + O: Display the Bottom 10% dialog box.
Alt + H + L + H + L: Display the Less Than dialog box.
Alt + H + M + M: Merge cells.
Alt + H + L + N: Display the New Conditional Formatting Rule dialog box.
Alt + H + L + R: Display the Conditional Formatting Rules Manager.
Alt + H + L + T + T: Display the Top 10 Items dialog box.
Alt + A + G + G: Display the Text That Contains dialog box.
Alt + H + N: Choose number format.
Alt + H + O + H: Display the Row Height dialog box.
Alt + H + T: Expand Format as Table menu.
Alt + H + T + P: Display the New PivotTable Style dialog box.
Alt + L: Add/remove left border.
Alt + R: Add/remove right border.
Alt + T: Add/remove top border.
Alt + V: Add/remove vertical interior border.
Ctrl + Shift + @: Apply time format (HH:MM AM/PM).
Ctrl + 5: Toggle strikethrough formatting.
Ctrl + Shift + !: Apply number format (2 decimals, 1000 separator).
F4: Repeat last action.
Ctrl + U: Toggle underlining.
Ctrl + Shift + $: Apply currency format.
Ctrl + I: Toggle italics.
Ctrl + Shift + ^: Apply scientific notation.
Ctrl + B: Toggle bold formatting.
Ctrl + Shift + ~: Reset to General format.
Ctrl + Shift + &: Add outer borders.
Ctrl + 1: Open Format Cells dialog.
Ctrl + T: Create table.
Ctrl + Shift + _: Remove borders.
Ctrl + Shift + %: Apply percentage format.
Ctrl + Shift + #: Apply date format.
Ctrl + Shift + F: Open Font formatting.

Excel Keyboard Shortcuts: Formulas And Functions

Let’s take a look at the top Excel shortcut keys related to formulas and functions:

(Ctrl + Alt + V) + F: Paste formulas only.
(Ctrl + Alt + V) + R: Paste formulas with number formatting.
(Ctrl + Alt + V) + L: Paste data links.
=: Start a new formula.
Ctrl + Shift + Enter: Enter as array formula.
F4: Cycle through reference types (absolute/relative).
Shift + F3: Open Insert Function dialog.
Alt + =: Insert AutoSum.
Alt + H + U + A: Calculate average.
Alt + H + U + C: Count numbers.
Alt + H + U + I: Find minimum value.
Alt + H + U + M: Find maximum value.
Alt + M + P: Trace precedents.
Alt + M + D: Trace dependents.
Alt + M + A + A: Remove audit arrows.
Ctrl + F3: Open Name Manager.
Ctrl + Shift + F3: Create names from selection.
F3: Paste named ranges.
F9: Calculate all workbooks.
Shift + F9: Calculate active sheet.
Ctrl + Alt + F9: Force full calculation.
Ctrl + A: Show function arguments.
Ctrl + Shift + A: Insert arguments.
Alt + Shift + F10: Show error menu.
Tab: Complete formula and move right.
Shift + Tab: Complete formula and move left.

Excel Keyboard Shortcuts: Navigation And Selection

Now let’s take a look at some top Excel shortcut keys for navigation:

Here’s your full list, shuffled and paraphrased to match the same bold-until-colon style with a clear, professional structure:
Alt + Tab: Cycle through open workbooks and switch to the next one.
Ctrl + . : When multiple cells are selected, move the active cell in a clockwise direction around the corners.
Alt + F: Open the Backstage View.
Ctrl + [ or F5 + (Alt + S) + P: Jump to the direct precedents of a formula within the current worksheet.
Ctrl + Shift + * or F5 + (Alt + S) + R: Select the entire data region around the active cell.
Alt + A to Alt + Z: Inside dialog boxes, activate a control or toggle checkboxes.
Ctrl + Arrow Keys: Navigate quickly to the edge of the current data region.
Ctrl + ] or F5 + (Alt + S) + D: Go to the direct dependents of a selected cell.
Ctrl + F or Shift + F5 or Alt + H + F + D + F: Open the Find and Replace window with the Find tab highlighted.
Alt + Down Arrow: Show the AutoComplete or AutoFilter list inside a cell, or expand a dropdown in a dialog box.
Ctrl + Shift + Spacebar or Ctrl + A: Select the data area; press repeatedly to select the entire worksheet or all objects.
Ctrl + Home then Ctrl + Shift + End: Select everything from the first to the last used cell in the sheet.
Ctrl + End or F5 + (Alt + S) + S: Go to the last cell that contains data (the lowest and right-most used cell).
Ctrl + Backspace: Return the view to the active cell, no matter where the scroll is.
Alt: Close an open dropdown in AutoFilter or a dialog box.
Ctrl + H or Alt + H + FD + R: Launch the Replace tab in the Find and Replace dialog.
Ctrl + Left-Click: Add non-adjacent cells or sheets to your current selection.
Ctrl + End: If editing a cell, move the cursor to the end of its contents.
Arrow Keys: Navigate between cells, tabs, menus, dropdown items, or options depending on the current context.
Ctrl + G or F5 or Alt + H + F + D + G: Open the Go To dialog box.
Alt + Up Arrow: Close the AutoComplete list in a cell and use this top Excel shortcut keys.
Alt + ; or F5 + (Alt + S) +Y: Select only the visible (unfiltered) cells in the range.
Alt + Page Down / Page Up: Move one screen right or left within the worksheet.
Ctrl + F6: Switch between open workbook windows.
Ctrl + Home: Jump to the top-left cell (A1) or to the start of the cell content if editing.
Ctrl + Shift + F4: Jump to the previous instance when searching for a match.
Ctrl + Space: Instantly select the entire column of the currently active cell.
Ctrl + Shift + { or F5 → Alt + S → D → L: Highlight all cells that are direct and indirect precedents to the current cell.
Ctrl + Shift + Tab: Move to the previous workbook window, or shift to the previous tab in a dialog box.
Ctrl + Shift + Page Up / Page Down: Select the current sheet along with the one before (left) or after (right) it.
Ctrl + Page Up / Page Down: Quickly switch between sheets — move left or right.
Ctrl + Shift + O or F5 → Alt + S → C or Alt + H → F → D → M: Navigate directly to all cells that contain comments.
Ctrl + Shift + Arrow Keys: Expand selection to the data edge in that direction, or (within a cell) select entire words to the left or right.
Ctrl + Shift + Home: Extend selection up to the very first cell in the worksheet, or within a cell/formula bar, select from the cursor to the start of content.
Ctrl + Shift + End: Select from the current cell all the way to the bottom-right of the used data area, or inside a cell/formula bar, highlight from cursor to end of the content.
Ctrl + Shift + } or F5 → Alt + S → P → L: Highlight all dependent cells — both direct and indirect — related to the current formula.
Ctrl + Tab: Cycle forward through open workbook windows or tabs in a dialog box.
F8: Toggle Extend Selection mode on or off to easily expand your selection using arrow keys.
F6: Rotate focus between key elements like the worksheet area, ribbon, task pane, and zoom controls
Esc: Cancel the current action and close menus, dialogs, or message boxes. Also used to deselect objects.
F1: Open the Help Task Pane. If a command is selected, Help displays the relevant topic.
Left Mouse Button + Shift: Add adjacent cells or worksheets to the current selection.
Page Down / Page Up: Scroll one screen down or one screen up in the worksheet.
Shift + Arrow Keys: Extend the selection by one cell. Inside a cell, select or extend the selection by one character left or right.
Shift + Backspace: When multiple cells are selected, reduce selection to only the active cell.
Shift + End: Select from the current position to the end of the row inside a cell.
Shift + F10: Open the Context (right-click) menu for the selected item.
Shift + F4: Repeat the last Find action or find the next match.
Shift + F6: Cycle focus between worksheet, Zoom controls, Task pane, and Ribbon (includes split panes if active).
Shift + F8: Add a non-adjacent range to the current selection. Use arrow keys to move the cursor and Shift + Arrow Keys to select the range.
Shift + Home: Select from the current position to the start of the row. Inside a cell, select from the cursor to the beginning of the line.
Shift + Page Down / Shift + Page Up: Extend selection by one screen down or one screen up.
Shift + Space: Select the active row. In tables, the first press selects the active row in the table; pressing again selects the entire worksheet row.
Shift + Tab: Move one cell left in a worksheet or to the previous unlocked cell in a protected worksheet. Move the active cell left within a selection. Navigate to the previous option or option group in dialog boxes or the Ribbon.
Spacebar: In dialog boxes, activate the selected button or toggle checkboxes. In the Ribbon, activate the selected control or open the selected menu/gallery.
Tab: Move one cell right in a worksheet or to the next unlocked cell in a protected worksheet. Move the active cell right within a selection. Navigate to the next option or option group in dialog boxes or the Ribbon.
Alt + N + V: PivotTable

Excel Keyboard Shortcuts: Sort And Filter

Check out these Excel shortcut keys for sort and filter:

Alt + A + V + V: Open the Data Validation settings dialog.
Ctrl + Shift + L or Alt + H + S + F: Toggle filters on or off in the current range.
Alt + A + SA or Alt + H + S + S: Sort data from smallest to largest.
Alt + H + S + C: Remove any applied filters.
Ctrl + Alt + L or Alt + H + S + Y: Refresh and reapply the current filter and sort criteria.
Alt + A + SD or Alt + H + S + O: Sort data from largest to smallest.
Alt + A + SS or Alt + H + S + U: Bring up the Sort dialog box.
Alt + A + Q: Launch the Advanced Filter tool.

Excel Keyboard Shortcuts: Print

Follow these shortcuts to print information in Excel:

Alt + P + S + P: Launch the dialog box for Page Setup options.
Ctrl + P: Access the Print tab within the Backstage View to print documents.
Alt + P + R + S: Define the Print Area for your worksheet.
Ctrl + F2: Preview the print layout in the Print Preview section of the Backstage View.

Excel Keyboard Shortcuts: VBA And Macros

VBAs and Macros have their own set of shortcuts too:

Alt + F11: Open the Visual Basic Editor if it’s closed, or switch between Excel and the Editor if it’s already open.
Alt + W + M + U: Activate Relative References mode for macros.
Ctrl + G: Show the Immediate Window inside the Visual Basic Editor.
F2: Open the Object Browser within the Visual Basic Editor.
Alt + L + I: Expand the menu for inserting Form Controls and ActiveX Controls.
Alt + F8 or Alt + W + M + V: Open the Macro dialog box.
Alt + W + M + R: Start recording a new macro.
F5: Run the selected macro inside the Visual Basic Editor.

Excel Keyboard Shortcuts: Workbooks And Worksheets

Lastly, look at these top Excel shortcut keys for worksheet:

Ctrl + F7: Activate the Move command on the current workbook window (if not maximized). Use arrow keys to move, then Enter to confirm or Esc to cancel.
Ctrl + F12: Open the Open dialog box.
Alt + H + O + U + S: Hide the active worksheet.
Alt + H + D + S or Alt + E + L: Delete the active worksheet.
Ctrl + S or Shift + F12: Save the current file with the existing name and location.
Ctrl + N: Create a new blank workbook.
Alt + H + O + T + N: Remove color from the current worksheet tab.
Ctrl + F11: Insert a new Macro sheet.
Alt + H + O + R or Alt + O + H + R: Rename the active worksheet.
Ctrl + W: Close the selected workbook.
Shift + F11 or Alt + H + I + S: Insert a new worksheet in the current workbook.
Alt + H + O + M: Open the Move or Copy worksheet dialog box.
Alt + H + O + U + H: Open the Unhide worksheet dialog box.
Ctrl + F9: Minimize the current workbook window.
Ctrl + F8: Activate the Resize command on the active workbook window (if not maximized). Use arrow keys to resize, Enter to confirm, Esc to cancel.
Alt + H + O + T: Open the Tab Color menu.
F12 or Alt + F2: Open the Save As dialog box.
Ctrl + F4: Close the current workbook window.
Ctrl + O: Open the Open tab in Backstage View to open a workbook.
Alt + Shift + F1: Insert a new worksheet.

Also Read: 12 Shortcuts to Open Task Manager in Windows 10/11

Now you will no longer have a difficult time figuring out the top Excel shortcut keys after following this guide. For more helpful tips and tricks, stay tuned, and feel free to share your suggestions in the comments below.