Create New Workbook

Ctrl + N / ⌘ + N — Opens a blank new Excel file.

Open Workbook

Ctrl + O / ⌘ + O — Opens an existing Excel file.

Save Workbook

Ctrl + S / ⌘ + S — Saves the current workbook.

Save As

F12 / ⌘ + ⇧ + S — Saves with a new name or location.

Print File

Ctrl + P / ⌘ + P — Opens the print dialog box.

Print Preview

Ctrl + F2 — Shows print preview of the sheet.

Close Workbook

Ctrl + W / ⌘ + W — Closes the current workbook.

Close Excel

Alt + F4 / ⌘ + Q — Quits Excel completely.

Expand or Collapse Ribbon

Ctrl + F1 / ⌘ + ⌥ + R — Show or hide the ribbon bar.

Activate Access Keys

Alt — Show ribbon shortcut letters (Windows only).

Move to Next Ribbon Control

Tab — Navigate across ribbon items.

Activate or Open Selected Control

Space — Activates the highlighted button or option.

Confirm Control Change

Enter / Return — Confirms the change or selection.

Get Help on Selected Control

F1 — Opens help related to the selected ribbon item.

Open Options

Alt + F + T / ⌘ + , — Opens Excel Options/settings.

Open Help

F1 / ⌘ + / — Opens the Excel Help window.

Undo Last Action

Ctrl + Z / ⌘ + Z — Undoes the previous action.

Redo Last Action

Ctrl + Y / ⌘ + Y — Repeats the undone action.

Copy Selected Cells

Ctrl + C / ⌘ + C — Copies selected content to clipboard.

Repeat Last Action

F4 / ⌘ + Y — Repeats your last action.

Cut Selected Cells

Ctrl + X / ⌘ + X — Cuts selected content to clipboard.

Paste from Clipboard

Ctrl + V / ⌘ + V — Pastes copied content.

Paste Values

Ctrl + Shift + V / ⌘ + ⇧ + V — Pastes values only.

Paste Special

Ctrl + Alt + V / ⌘ + ⌃ + V — Opens the Paste Special dialog box.

Find and Replace

Ctrl + F / ⌘ + F — Finds content in worksheet.

Find and Replace (Replace tab)

Ctrl + H / ⌃ + H — Opens Replace tab directly.

Find Next Match

Shift + F4 / ⌘ + G — Finds the next match.

Find Previous Match

Ctrl + Shift + F4 / ⌘ + ⇧ + G — Finds the previous match.

Create Embedded Chart

Alt + F1 / Fn + ⌥ + F1 — Inserts chart in same sheet.

Create Chart in New Worksheet

F11 / Fn + F11 — Inserts chart in a new worksheet.

Insert Table

Ctrl + T / ⌘ + T — Converts range into a table.

Toggle Autofilter

Ctrl + Shift + L / ⌘ + ⇧ + F — Adds or removes filters.

Activate Filter

Alt + ↓ / ⌥ + ↓ — Opens filter dropdown on selected cell.

Select Table Row

Shift + Space / ⇧ + Space — Selects the entire table row.

Select Table Column

Ctrl + Space / ⌃ + Space — Selects the entire table column.

Select Table

Ctrl + A / ⌘ + A — Selects the entire table or data region.

Clear Slicer Filter

Alt + C / ⌥ + C — Clears filter applied via slicer.

Toggle Total Row

Ctrl + Shift + T / ⌃ + ⇧ + T — Show or hide total row.

Drag and Cut

Drag — Moves selected cells to new location.

Drag and Copy

Ctrl + Drag / ⌥ + Drag — Copies cells while dragging.

Drag and Insert

Shift + Drag / ⇧ + Drag — Inserts cells at drop location.

Drag and Insert Copy

Ctrl + Shift + Drag / ⌥ + ⇧ + Drag — Inserts and copies cells.

Drag to Worksheet

Alt + Drag / ⌘ + Drag — Move content to another sheet.

Duplicate Worksheet

Ctrl + Drag / ⌥ + Drag — Duplicates the entire sheet.

Move One Cell Right

→ — Moves active cell right.

Move One Cell Left

← — Moves active cell left.

Move One Cell Up

↑ — Moves active cell up.

Move One Cell Down

↓ — Moves active cell down.

Move One Screen Right

Alt + PgDn / Fn + ⌥ + ↓ — Scrolls one screen right.

Move One Screen Left

Alt + PgUp / Fn + ⌥ + ↑ — Scrolls one screen left.

Move One Screen Up

PgUp / Fn + ↑ — Scrolls one screen up.

Move One Screen Down

PgDn / Fn + ↓ — Scrolls one screen down.

Right Edge of Data Region

Ctrl + → / ⌘ + → — Moves to right edge of data.

Left Edge of Data Region

Ctrl + ← / ⌘ + ← — Moves to left edge of data.

Top Edge of Data Region

Ctrl + ↑ / ⌘ + ↑ — Moves to top edge of data.

Bottom Edge of Data Region

Ctrl + ↓ / ⌘ + ↓ — Moves to bottom edge of data.

Move to Beginning of Row

Home / Fn + ← — Goes to the first cell of the row.

Move to Last Cell in Worksheet

Ctrl + End / Fn + ⌃ + → — Jumps to last cell used.

Move to First Cell in Worksheet

Ctrl + Home / Fn + ⌃ + ← — Jumps to cell A1.

Turn End Mode On

End / Fn + → — Enables End mode for arrow keys.

Go Back to Hyperlink

Ctrl + G then Enter / ⌃ + G then Return — Returns to last followed hyperlink.

Select entire row

Shift + Space / ⇧ + Space — Selects full row of active cell.

Select entire column

Ctrl + Space / ⌃ + Space — Selects full column of active cell.

Select entire worksheet

Ctrl + A / ⌘ + A — Selects all cells in worksheet.

Add adjacent cells to selection

Shift + Click / ⇧ + Click — Adds range of cells to selection.

Add non-adjacent cells to selection

Ctrl + Click / ⌘ + Click — Adds single cells to selection.

Same selection in next column

⌥ + Tab — Keeps selection shape in next column.

Same selection in previous column

⌥ + ⇧ + Tab — Keeps selection shape in previous column.

Move right between non-adjacent selections

Ctrl + Alt + → / ⌃ + ⌥ + → — Moves active cell between selection groups.

Move left between non-adjacent selections

Ctrl + Alt + ← / ⌃ + ⌥ + ← — Moves left between non-adjacent selection blocks.

Toggle add to selection mode

Shift + F8 / Fn + ⇧ + F8 — Add multiple ranges without holding Ctrl.

Cancel selection

Esc — Deselect all selected cells.

Select active cell only

Shift + Backspace / ⇧ + Delete — Deselects other selected cells.

Show the active cell on worksheet

Ctrl + Backspace / ⌃ + Delete — Scrolls to the active cell.

Move active cell clockwise in selection

Ctrl + . / ⌃ + . — Moves active cell to next corner.

Move active cell down in selection

Enter / Return — Moves active cell down in selection.

Move active cell up in selection

Shift + Enter / ⇧ + Return — Moves active cell upward.

Move active cell right in selection

Tab — Moves right within selection.

Move active cell left in selection

Shift + Tab / ⇧ + Tab — Moves left within selection.

Extend one cell right

Shift + → / ⇧ + → — Selects one more cell to the right.

Extend one cell left

Shift + ← / ⇧ + ← — Selects one more cell to the left.

Extend one cell up

Shift + ↑ / ⇧ + ↑ — Adds one row up to selection.

Extend one cell down

Shift + ↓ / ⇧ + ↓ — Adds one row down to selection.

To last cell right

Ctrl + Shift + → / ⌘ + ⇧ + → — Selects to last data cell right.

To last cell left

Ctrl + Shift + ← / ⌘ + ⇧ + ← — Selects to first data cell left.

To last cell up

Ctrl + Shift + ↑ / ⌘ + ⇧ + ↑ — Selects upward to top data row.

To last cell down

Ctrl + Shift + ↓ / ⌘ + ⇧ + ↓ — Selects downward to bottom data row.

Extend up one screen

Shift + Page Up / Fn + ⇧ + ↑ — Adds one screen above to selection.

Extend down one screen

Shift + Page Down / Fn + ⇧ + ↓ — Adds one screen below to selection.

Extend right one screen

Alt + Shift + Page Down / Fn + ⇧ + ⌥ + ↓ — Adds one screen to the right.

Extend left one screen

Alt + Shift + Page Up / Fn + ⇧ + ⌥ + ↑ — Adds one screen to the left.

To start of row

Shift + Home / Fn + ⇧ + ← — Selects from current to first column.

To first cell in worksheet

Ctrl + Shift + Home / Fn + ⌃ + ⇧ + ← — Selects to top-left A1 cell.

To last cell in worksheet

Ctrl + Shift + End / Fn + ⌃ + ⇧ + → — Selects to bottom-right used cell.

Toggle extend selection mode

F8 / Fn + F8 — Turn on/off keyboard selection mode.

Toggle Extend Selection Mode

F8 / Fn + F8
Turns on/off selection mode — use arrow keys to expand the selection without holding Shift.

Display 'Go To' Dialog

Ctrl + G / ⌃G — Quickly navigate to a specific cell by address (like B5 or Sheet2!A1).

Select Cells with Comments

Ctrl + Shift + O / Fn + ⌃⇧O — Select all cells that contain comments (notes) in the worksheet.

Select Current Region Around Cell

Ctrl + Shift + * / ⌃⇧Space — Selects a rectangular block of data surrounding the active cell.

Select Entire Region

Ctrl + A / ⌘A — Press once to select current region, twice to select entire worksheet.

Select Current Array

Ctrl + / / ⌃/ — Selects the full array formula range (for array-entered formulas).

Select Row Differences

Ctrl + \ / ⌃\ — Highlights cells in a row that differ from the first cell in that row.

Select Column Differences

Ctrl + Shift + | / ⌃⇧| — Highlights cells in a column that differ from the top cell in that column.

Select Direct Precedents

Ctrl + [ / ⌃[ — Selects cells directly referenced by the active cell.

Select All Precedents

Ctrl + Shift + { / ⌃⇧{ — Selects all cells (direct and indirect) that feed into the active formula.

Select Direct Dependents

Ctrl + ] / ⌃] — Selects cells that use the value from the active cell.

Select All Dependents

Ctrl + Shift + } / ⌃⇧} — Selects all formulas that rely on the active cell (directly and indirectly).

Select Visible Cells Only

Alt + ; / ⌘⇧Z — Useful when copying filtered data — skips hidden rows/columns.

Edit Active Cell

F2 / ⌃U — Enter editing mode within the current cell without double-clicking.

Cancel Entry

Esc — Exit edit mode or cancel changes made in a cell.

Select One Character Right

Shift + → / ⇧→ — Select one character to the right of the cursor while editing text.

Select One Character Left

Shift + ← / ⇧← — Select one character to the left of the cursor in edit mode.

Move One Word Right

Ctrl + → / ⌃→ — Jump to the beginning of the next word inside a cell.

Move One Word Left

Ctrl + ← / ⌃← — Jump to the beginning of the previous word in a cell.

Select One Word Right

Ctrl + Shift + → / ⌃⇧→ — Select the word to the right of the cursor during editing.

Select One Word Left

Ctrl + Shift + ← / ⌃⇧← — Select the word to the left of the cursor in edit mode.

Select to Beginning of Cell

Shift + Home / Fn⇧← — Highlight everything before the cursor inside a cell.

Select to End of Cell

Shift + End / Fn⇧→ — Select all text after the cursor in the current cell.

Delete to End of Line

Ctrl + Delete / Fn⌃Delete — Remove all content from the cursor to the end of the cell.

Delete Left Character

Backspace / Delete — Erase the character before the cursor inside the cell.

Delete Right Character

Delete / FnDelete — Erase the character after the cursor in cell editing mode.

Insert Line Break in Cell

Alt + Enter / ⌃⌥Return — Start a new line within the same cell (multi-line cell).

Enter and move down

Enter / Return — Confirms entry and moves to the next cell below.

Enter and move up

Shift + Enter / ⇧Return — Confirms entry and moves to the cell above.

Enter and move right

Tab / Tab — Confirms entry and moves to the next cell to the right.

Enter and move left

Shift + Tab / ⇧Tab — Confirms entry and moves to the cell to the left.

Complete entry and stay

Ctrl + Enter / ⌃Return — Keeps the active cell selected after entering data.

Enter same data in multiple cells

Ctrl + Enter / ⌃Return — Inputs the same value across all selected cells.

Insert current date

Ctrl + ; / ⌃; — Adds today’s date in the cell.

Insert current time

Ctrl + Shift + : / ⌘; — Adds current system time.

Fill down

Ctrl + D / ⌘D — Copies the value or formula from the cell above.

Fill right

Ctrl + R / ⌘R — Copies the value or formula from the cell to the left.

Copy formula from above

Ctrl + ' / ⌘' — Copies the formula from the cell above.

Copy value from above

Ctrl + Shift + " / ⌃⇧" — Copies just the value (not formula) from above.

Add hyperlink

Ctrl + K / ⌘K — Opens the hyperlink dialog to add a link.

Display AutoComplete list

Alt + ↓ / ⌥↓ — Shows suggestions from above entries in the column.

Flash fill

Ctrl + E / ⌃E — Auto-fills based on detected patterns.

Format anything

Ctrl + 1 / ⌘1 — Opens Format Cells dialog for full formatting options.

Open Font tab

Ctrl + Shift + F / ⌃⇧F — Opens Format Cells with Font tab active.

Bold text

Ctrl + B / ⌘B — Applies or removes bold formatting to selected cell(s).

Italic text

Ctrl + I / ⌘I — Applies or removes italic formatting.

Underline text

Ctrl + U / ⌘U — Toggles underline formatting on/off.

Strikethrough text

Ctrl + 5 / ⌘⇧X — Applies strikethrough to selected content.

Center align

Alt + H + A + C / ⌘E — Centers the cell content horizontally.

Left align

Alt + H + A + L / ⌘L — Aligns content to the left side of the cell.

Right align

Alt + H + A + R / ⌘R — Aligns content to the right.

Increase indent

Alt + H + 6 / ⌃⌥Tab — Indents the text inside a cell.

Decrease indent

Alt + H + 5 / ⌃⌥⇧Tab — Reduces the indent level in a cell.

Increase font size

Alt + H + F + G / ⌘⇧> — Increases text size incrementally.

Insert rows/columns

Ctrl + Shift + + / ⌘⇧+ — Insert new rows or columns.

Delete rows/columns/cells

Ctrl + - / ⌘- — Remove selected rows, columns, or cells.

Delete cell contents

Delete / Fn + Delete — Clears content without deleting the cell.

Hide columns

Ctrl + 0 / ⌃0 — Quickly hide selected columns.

Hide rows

Ctrl + 9 / ⌃9 — Quickly hide selected rows.

Unhide rows

Ctrl + Shift + 9 / ⌃⇧9 — Unhide previously hidden rows.

Unhide columns

Ctrl + Shift + 0 / ⌃⇧0 — Unhide previously hidden columns.

Group rows/columns

Alt + Shift + → / ⌘⇧K — Group the selected data.

Ungroup rows/columns

Alt + Shift + ← / ⌘⇧J — Ungroup the selected data.

Show/Hide outline symbols

Ctrl + 8 / ⌃8 — Toggle group outline visibility.

Zoom in

Ctrl + Alt + + / ⌥⌘+ — Zoom into worksheet.

Zoom out

Ctrl + Alt + - / ⌥⌘- — Zoom out of worksheet.

Zoom scroll

Ctrl + Mouse Scroll / ^scroll — Use scroll wheel to zoom.

Select pivot table

Ctrl + A / ⌘A — Selects the entire pivot table.

Toggle pivot field checkbox

Space / Space — Toggle selection of a field in PivotTable Field List.

Group items

Alt + Shift + → / ⌘⇧K — Group selected PivotTable items.

Ungroup items

Alt + Shift + ← / ⌘⇧J — Ungroup selected PivotTable items.

Hide pivot item

Ctrl + - / Ctrl- — Hide selected item from PivotTable.

Create pivot chart (same sheet)

Alt + F1 — Quickly create pivot chart in the same worksheet.

Create pivot chart (new sheet)

F11 / Fn + F11 — Create pivot chart in new worksheet.

Open PivotTable wizard

Alt + D + P / ⌘⌥P — Launch classic PivotTable wizard.

Insert new worksheet

Shift + F11 / fn⇧F11 — Adds a new worksheet to the workbook.

Next worksheet

Ctrl + PgDn / Fn⌃↓ — Move to the next worksheet tab.

Previous worksheet

Ctrl + PgUp / Fn⌃↑ — Move to the previous worksheet tab.

Next pane

F6 / FnF6 — Navigate to the next pane within the window.

Previous pane

Shift + F6 / Fn⇧F6 — Navigate to the previous pane.

Next workbook

Ctrl + Tab / ⌘` — Switch to next open workbook window.

Previous workbook

Ctrl + Shift + Tab / ⌘⇧` — Switch to previous open workbook window.

Minimize workbook

Ctrl + F9 / ⌘M — Minimize the current workbook window.

Maximize workbook

Ctrl + F10 / fn⌃F10 — Maximize current workbook window.

Select adjacent sheets

Shift + Click / ⇧Click — Select a range of sheets.

Select non-adjacent sheets

Ctrl + Click / ⌘Click — Select multiple non-contiguous sheets.

Toggle scroll lock

ScrLk / Fn⇧F14 — Enable or disable scroll lock.

Toggle full screen

Ctrl + Shift + F1 / ⌃⌘F — Fullscreen the Excel window.

Next control

Tab / Tab — Move to the next field or button.

Previous control

Shift + Tab / ⇧Tab — Move to the previous control.

Next tab

Ctrl + Tab / ⌃Tab — Move to the next tab in a dialog box.

Previous tab

Ctrl + Shift + Tab / ⌃⇧Tab — Move to the previous tab.

Accept and apply

Enter / Return — Confirm and apply dialog box changes.

Check/uncheck box

Space / Space — Toggle checkbox selection.

Cancel and close

Esc / Esc — Cancel and close the dialog box.

Check spelling

F7 / FnF7 — Run spell check on your workbook.

Thesaurus

Shift + F7 / Fn⇧F7 — Opens the thesaurus dialog box.

Open Macro dialog

Alt + F8 / Fn⌥F8 — View and run macros.

Open VBA Editor

Alt + F11 / Fn⌥F11 — Open Visual Basic Editor.

Open Power Query Editor

Alt + F12 / Fn⌥F12 — Launch Power Query Editor.

Duplicate object

Ctrl + D / ⌘D — Duplicate selected objects or cells.

Snap to grid

Alt / ⌘ — Align object to grid while moving.

Hide/show objects

Ctrl + 6 / ⌃6 — Toggle visibility of all objects.

Modify cell style

Alt + ' / ⌘⇧L — Open Modify Cell Style dialog box.

Right-click menu

Shift + F10 / Fn⇧F10 — Simulate right-click action.

Insert/edit note

Shift + F2 / Fn⇧F2 — Insert or edit a note in the cell.

Insert threaded comment

Ctrl + Shift + F2 / Fn⌘⇧F2 — Add a modern threaded comment.

Delete comment

Shift + F10 then D / Fn⇧F10 then D — Delete the selected comment.

Control menu

Alt + Space — Open the window control menu.

Apply general format

Ctrl + Shift + ~ / ⌃⇧~ — Applies default number formatting.

Apply currency format

Ctrl + Shift + $ / ⌃⇧$ — Formats cell as currency.

Apply percentage format

Ctrl + Shift + % / ⌃⇧% — Formats number as a percent.

Apply scientific format

Ctrl + Shift + ^ / ⌃⇧^ — Displays numbers in scientific notation.

Apply date format

Ctrl + Shift + # / ⌃⇧# — Formats as date.

Apply time format

Ctrl + Shift + @ / ⌃⇧@ — Formats as time.

Apply number format

Ctrl + Shift + ! / ⌃⇧! — Applies standard number formatting.

Add border outline

Ctrl + Shift + & / ⌘⌥0 — Adds outer borders to selected cells.

Add or remove border right

Alt + R / ⌘⌥→ — Toggles right-side border.

Add or remove border left

Alt + L / ⌘⌥← — Toggles left-side border.

Add or remove border top

Alt + T / ⌘⌥↑ — Toggles top border.

Add or remove border bottom

Alt + B / ⌘⌥↓ — Toggles bottom border.

Add or remove upward diagonal border

Alt + D — Toggles upward diagonal border.

Add or remove horizontal interior border

Alt + H — Toggles horizontal interior border.

Add or remove vertical interior border

Alt + V — Toggles vertical interior border.

Remove borders

Ctrl + Shift + _ / ⌘⌥_ — Removes all borders.

Toggle absolute and relative references

F4 / ⌘T — Switch between relative and absolute cell references.

Insert Function dialog box

Shift + F3 / Fn⇧F3 — Open Insert Function dialog.

Autosum selected cells

Alt + = / ⌘⇧T — Quickly insert a SUM formula.

Toggle formulas on and off

Ctrl + ` / ⌃` — Show or hide formulas in cells.

Insert function arguments

Ctrl + Shift + A / ⌃⇧A — Insert function argument names.

Enter array formula

Ctrl + Shift + Enter / ⌃⇧Return — Confirm as an array formula.

Calculate all worksheets

F9 / FnF9 — Recalculates formulas across sheets.

Calculate active worksheet

Shift + F9 / Fn⇧F9 — Recalculates active worksheet.

Force full workbook calculation

Ctrl + Alt + F9 — Forces all formulas to recalculate.

Evaluate part of a formula

F9 / FnF9 — Evaluate selected formula portion.

Toggle formula bar

Ctrl + Shift + U / ⌃⇧U — Expand or collapse the formula bar.

Open function arguments dialog

Ctrl + A / ⌃A — Opens the function dialog with arguments.

Open Name Manager

Ctrl + F3 / Fn⌃F3 — Manages defined names in workbook.

Define name from labels

Ctrl + Shift + F3 / Fn⌃⇧F3 — Use row/column labels to define names.

Select name box

Alt + F3 — Select the Name Box on the formula bar.

Paste name into formula

F3 / F3 — Inserts a defined name into formula.

Accept function autocomplete

Tab / Tab — Accept the autocomplete suggestion.