Microsoft Excel Shortcuts

Applies full grid border lines to all selected rows, columns, or active table cells.

Draws a single border line along the bottom edge of selected cells.

Draws a border line along the top edge of selected cells.

Applies a vertical border line along the left edge of selected range.

Applies a vertical border line along the right edge of selected range.

Clears all internal and perimeter borders from the active cell selection.

Applies a bold heavy line around the outer perimeter of selected cells.

Applies classic accounting double bottom border under final balance and total rows.

Opens Borders tab in Format Cells dialog for custom colors, diagonal lines, and dashed borders.

Jumps keyboard focus directly into the Font Size box on Home ribbon. Type number and press Enter.

Focuses font selector box to switch fonts (Calibri, Aptos, Arial, Times New Roman, Segoe UI).

Opens theme font color dropdown to colorize text with arrow keys.

Opens background shading palette to fill header cells and status rows with color.

Combines selected cells into a single larger cell and centers the contents horizontally.

Merges selected cells together while preserving standard alignment.

Merges cells across columns within each selected row separately without combining vertical rows.

Splits previously merged cells back into individual cells.

Wraps extra-long text into multiple visible lines within cell height so no text gets cut off.

Aligns cell data along the top edge of cell height.

Centers text vertically between top and bottom cell borders.

Aligns text along the bottom baseline of cell.

Aligns content against the left margin of the cell.

Centers content horizontally between left and right cell walls.

Aligns text or numbers against the right edge of cell.

Legendary Excel shortcut that automatically resizes column width to perfectly fit the longest entry.

Automatically adjusts row height to accommodate multi-line wrapped text or larger fonts.

Opens exact numerical column width input box to standardize uniform column widths.

Opens exact numerical row height input box.

Highlights the sheet tab name at bottom of screen to immediately type a new worksheet name.

Opens Move or Copy dialog to duplicate active sheet or reorder tabs.

Opens color palette to color-code sheet tabs for visual organization.

Hides currently highlighted rows from view.

Hides currently highlighted columns from view.

Restores hidden rows between selected boundary rows.

Restores hidden columns between selected boundary columns.

Inserts new blank rows directly above the selected row.

Inserts new blank columns to the left of the selected column.

Adds a brand new empty worksheet tab into the active workbook.

Permanently deletes active selected rows and shifts lower rows upward.

Permanently deletes active selected columns and shifts right columns to the left.

Deletes the current worksheet tab from the workbook.

Pastes raw calculated values without formulas, formatting, or cell links.

Pastes underlying calculation formulas without copying cell borders or fill colors.

Rotates clipboard orientation: pastes horizontal rows into vertical columns and vice versa.

Applies source column widths onto target destination columns.

Completely strips cell back to blank state, removing text, styles, formulas, and comments.

Clears colors, borders, and number formatting while leaving data values intact.

Clears typed text and numbers while preserving cell borders and background colors.

Opens Conditional Formatting rules: Highlight Cell Rules, Top/Bottom Rules, Data Bars, Color Scales.

Applies pre-designed table theme styles with alternating row colors and auto-filters.

Opens Sort & Filter dropdown for quick ascending, descending, or custom multi-level sort.

Opens master Sort dialog to sort by multiple columns, custom lists, or cell colors.

Multiplies by 100 and applies percent sign (%) to selected numerical cells.

Formats numbers with standard thousands commas and two decimal places (e.g. 100,000.00).

Shows more decimal places for greater numerical precision.

Shows fewer decimal places, rounding the displayed number.

Opens Create PivotTable wizard to summarize, analyze, explore, and present summary data.

Converts selected cell range into an official structured Excel Table with structured references.

Opens Column and Bar chart gallery (2D Clustered, 3D Column, Stacked Bar).

Inserts Line graphs for displaying continuous trends over time.

Inserts proportional distribution charts for breakdown analysis.

Embeds images, company logos, and diagrams from your computer storage.

Opens shape gallery with arrows, callouts, flowchart blocks, and rectangles.

Creates interactive visual button filter tiles for PivotTables and Excel Tables.

Links cell to external website URLs, email addresses, or specific cells in other sheets.

Draws a free-floating text box for annotations or summary KPI callouts.

Switches into Page Layout view to customize headers and footers (page numbers, sheet name).

Opens symbol dialog for Greek math characters, arrows, currency signs, and checkmarks.

Sets margins: Normal, Wide, Narrow, or Custom margins for print alignment.

Switches spreadsheet printing between vertical Portrait and wide Landscape mode.

Sets paper format dimensions for printing documents.

Locks selected cells as the exclusive area that will be printed or exported to PDF.

Removes print area boundaries to print the entire used worksheet.

Opens Page Setup dialog to repeat column headers at the top of every printed page.

Opens Insert Function formula builder to search formulas and syntax guidance.

Opens Name Manager window to inspect, create, edit, or delete named ranges.

Draws tracer arrows to cells that provide values to active formula.

Draws tracer arrows to cells that depend on value of active cell.

Clears all precedent and dependent tracer arrows from active worksheet.

Switches display between calculated results and raw formulas across all sheet cells.

Steps through formula calculation step-by-step to debug errors like #N/A or #VALUE!.

Turns filter dropdown arrows on or off across header row of data range.

Opens Sort window to configure multi-column sorting (e.g. by Region, then by Sales).

Clears all column filters and reveals all hidden rows in the table.

Re-runs filter and sort rules after modifying or adding new records.

Scans table and removes redundant duplicate rows based on chosen key columns.

Splits compound cell contents (like "First Last" or CSV data) across separate columns.

Creates dropdown validation picklists, prevents invalid data entries, and sets error alerts.

Finds the exact input value needed to hit a specific target output result.

Groups selected rows or columns with expand/collapse (+ / -) outline buttons.

Removes outline grouping from selected rows or columns.

Calculates automatic subtotals and grand totals for grouped data in sorted lists.

Refreshes all Power Query connections, web data, and database tables in workbook.

Freezes rows above and columns to left of active cell so headers remain visible during scrolling.

Locks row 1 so column headings remain visible when scrolling down huge tables.

Locks column A so identifiers stay visible when scrolling horizontally to the right.

Hides or reveals background cell gridline boundaries on the screen.

Shows or hides column letters (A, B, C...) and row numbers (1, 2, 3...).

Shows or hides the formula editing bar at the top of the worksheet.

Opens precise Zoom level dialog (25%, 50%, 75%, 100%, 200%, or custom percent).

Magnifies worksheet so the highlighted block of cells fits the entire active window.

Divides worksheet window into 2 or 4 separate scrollable viewports.

Classic financial analyst shortcut that opens Paste Special and selects Values.

Pastes formulas only without altering cell borders, font weights, or colors.

Applies source number formatting, fills, and borders to destination cells.

Rotates table orientation (swapping rows into columns).

Duplicates exact column dimensions from copied table onto target cells.

Multiplies target cells by copied value in place (great for bulk conversions like converting thousands into millions).

Divides target cells by copied number in place (e.g. dividing figures by 100).

Navigates to File > New to create blank workbook or select template.

Navigates to File > Open to browse recent spreadsheets or OneDrive files.

Saves active workbook to disk.

Navigates to File > Save As to change location or format (.xlsx, .csv, .pdf).

Opens master Excel Options dialog for calculation settings, formulas, and add-ins.

Automatically inserts the =SUM() formula detecting adjacent numbers above or to the left.

Inserts current static date into active cell without typing.

Inserts current static timestamp (HH:MM) into active cell.

In formula bar, cycles reference locking ($A$1 -> A$1 -> $A1 -> A1). On worksheet, repeats last action.

Fills the exact formula or value entered into all currently selected cells at once.

Copies contents and formulas from the top cell of selected range downward.

Copies contents and formulas from the leftmost cell of selected range rightward.

Magically extracts, combines, and splits data patterns across adjacent columns automatically.

Toggles between displaying calculated formula results and raw underlying formulas across the sheet.

Copies the exact formula from the cell directly above without adjusting relative cell references.

Copies the calculated value from the cell directly above into current cell.

Opens Insert Function formula builder to pick formulas (VLOOKUP, XLOOKUP, INDEX, MATCH, IF, SUMIFS).

Forces calculation of formulas on the current active sheet without recalculating entire workbook.

Calculates all open workbooks. When inside formula bar with highlighted syntax, evaluates selected chunk.

Forces complete calculation of all formulas in all open workbooks regardless of whether they changed.

Opens picklist of all unique text entries previously entered in current column, or activates Data Validation list.

Starts a new text line within the same spreadsheet cell without moving cursor to the next row.

When typing formula, completes the highlighted function suggestion and inserts opening parenthesis.

Inserts parameter argument names into formula after typing function name (e.g. =VLOOKUP(lookup_value...)).

Toggles between single-line formula bar and expanded multi-line formula bar for viewing long formulas.

Opens master Name Manager to view, edit, define, and delete named cell ranges.

Generates named ranges automatically using text from top row, left column, or bottom row of table.

Opens Paste Name dialog box to select and insert a defined range name into active formula.

Highlights the complete horizontal row from column A to XFD (all 16,384 columns).

Highlights the complete vertical column from row 1 down to row 1,048,576.

Selects the contiguous table block. Pressing Ctrl+A a second time selects the entire worksheet.

Immediately highlights all rows and columns across the entire sheet.

Opens Insert dialog to insert new cell, shift cells right/down, or insert entire row/column.

Deletes selected cells and shifts remaining cells, or removes entire highlighted rows/columns.

Hides selected rows from the worksheet view.

Reveals any hidden rows within the selected row span.

Hides selected columns from the worksheet view.

Reveals any hidden columns within the selected column span.

Converts data range into an official Excel Table with striped rows, total row, and column sorting.

Teleports active cursor to the last filled cell in the chosen arrow direction.

Highlights all cells from current position to the last filled cell in chosen direction.

Expands the highlighted cell range by one cell in direction of arrow pressed.

Immediately scrolls and jumps cursor to cell A1 of active worksheet.

Moves cursor to the lowest and rightmost populated cell in active sheet.

Scrolls screen view directly back to the active cell while preserving wide selections.

Shrinks an extensive multi-cell selection down to only the active starting cell.

Cycles active focus cell clockwise around the four corners of a selected multi-cell range.

Enables extend mode so moving arrow keys expands selection without needing to hold Shift.

Enables "Add or Remove Selection" mode to pick separate non-contiguous cell blocks with arrow keys.

Master shortcut that opens full Format Cells dialog: Number, Alignment, Font, Border, Fill, and Protection.

Resets highlighted cells to default General number format without specific commas or currencies.

Formats numbers as Currency with two decimal places and symbol (e.g. $1,250.00 / ₹1,250.00).

Multiplies by 100 and applies percent style without decimal places (e.g. 0.25 -> 25%).

Formats numbers in scientific engineering notation with two decimal places (e.g. 1.25E+06).

Formats serial date values into standard day, month abbreviation, and year (e.g. 06-Oct-26).

Formats time fractions into standard hour, minute, and AM/PM timestamp.

Applies thousands separators, two decimal places, and minus sign for negative numbers.

Toggles bold weight on selected cell text or numbers.

Toggles italic slant on selected cell contents.

Applies or clears underline from selected cells.

Applies or clears horizontal strikethrough line across selected cell text.

Draws a single clean border line around the outer perimeter of selected cells.

Instantly removes all internal and outer borders from highlighted range.

Opens Excel Help and formulas tutorial side task pane.

Puts active cell into Edit Mode, placing insertion point at the end of cell contents.

Displays Paste Name dialog box to insert named ranges into active formula.

In formula bar, cycles reference locking ($A$1). In worksheet, repeats your last formatting or action.

Opens Go To dialog to jump directly to cell coordinates (e.g. Z100) or named ranges.

Runs spell check across active worksheet or selected cells.

Turns Extend Selection on or off so arrow keys expand range without holding Shift.

Recalculates all formulas in all open workbooks. When inside formula bar, computes highlighted expression.

Displays Ribbon shortcut badge KeyTips to control Excel entirely via keyboard.

Immediately creates a full-screen default column chart on a brand new dedicated Chart Sheet tab.

Opens Save As dialog window to choose new folder, file name, or file format.

Displays contextual screen tips and help on active feature.

Opens a popup note box on active cell for annotations and documentation.

Launches function search dialog to select formula and inspect parameter explanations.

Jumps to next match of search query specified in previous Find search.

Opens Find and Replace dialog directly focused on Find tab.

Opens research pane to look up synonyms and definitions.

Enables Add mode: use arrow keys and Enter to pick multiple disjoint cells without holding Ctrl.

Computes formulas on active sheet only without calculating other sheets.

Opens right-click popup context menu at current cell without touching mouse.

Quickly inserts a new worksheet tab to the left of the current sheet.

Saves active spreadsheet file (equivalent to Ctrl+S).

Toggles showing full ribbon commands vs minimal tabs to expand vertical spreadsheet view.

Opens Backstage Print Preview to check paper fit, pagination, and print area.

Opens Name Manager dialog to inspect and manage all workbook defined names.

Closes active workbook without quitting the Microsoft Excel software.

Restores the window size of the selected workbook window.

Switches window focus to the next open Excel workbook.

Switches window focus back to previous Excel workbook window.

Minimizes current workbook window to an icon on taskbar.

Maximizes the workbook window to fill full screen or restores previous size.

Opens standard Open File dialog box to browse spreadsheets.

Instantly creates an embedded clustered column chart directly on the active worksheet.

Opens Save As dialog window (equivalent to F12).

Closes all workbooks and terminates Excel program.

Opens Macros dialog window to run, step into, record, or delete VBA macros.

Launches Microsoft Visual Basic for Applications IDE to write automation macros and custom UDF functions.

Switches view to the next worksheet tab to the right in the workbook.

Switches view to the preceding worksheet tab to the left in the workbook.

Quickly adds a new worksheet tab.

Cycles window focus between all open spreadsheet workbooks.

Creates a brand new empty spreadsheet file.

Opens existing workbook from computer drive or cloud storage.

Commits all pending edits to file storage.

Closes active workbook window.

Opens Print Preview dialog to inspect page layout and printer options.

Opens search dialog to locate values, formulas, or comments across active sheet or entire workbook.

Opens Replace tab to find and substitute text or numbers in bulk.

Opens Go To window to jump directly to specific cell coordinates or named ranges.

Reverts the most recent cell modification or formatting change.

Re-applies the action that was just undone.

Crucial shortcut that selects only unhidden, visible cells in a filtered table so hidden rows are not accidentally copied.

Turns filter dropdown arrows on or off across header row of data range.

Launches Create PivotTable dialog to build data summarization reports.

Updates active PivotTable cache with fresh numbers from source table.

Recalculates and refreshes every PivotTable and data connection in the entire workbook.

Groups selected rows, columns, or date entries (Years, Quarters, Months) in PivotTables and outlines.

Removes grouping from active outline or PivotTable date field.

When focused on header cell with filter arrow, opens the filter dropdown menu without mouse.

When navigating filter items in dropdown, toggles checkbox on or off.

In an open filter dropdown, jumps keyboard cursor into the Search box to filter items by keyword.

In an open filter dropdown, selects "Clear Filter From [Column Name]" to reveal all items.

Identifies and deletes duplicate data rows from table.

Splits combined cell strings into individual columns using delimiters (comma, space, tab).

Creates dropdown validation picklists, prevents invalid data entries, and sets error alerts.

Calculates the required input variable needed to achieve a specified goal value.