Category Shortcut (Windows) Shortcut (Mac) Description
Navigation Arrow keys Arrow keys Move one cell up/down/left/right.
Navigation Ctrl + Arrow ⌘ + Arrow / Ctrl + Arrow Jump to edge of data region in direction of arrow.
Navigation Home Fn + ← Move to beginning of row (column A).
Navigation Ctrl + Home ⌘ + Fn + ← Move to beginning of worksheet (A1).
Navigation Ctrl + End ⌘ + Fn + → Move to last used cell on sheet.
Navigation Page Up / Page Down Fn + ↑ / Fn + ↓ Move up or down one screen.
Navigation Alt + Page Up / Page Down Option + Fn + ↑ / ↓ Move left or right one screen.
Navigation Ctrl + G / F5 ⌘ + G Go To dialog - jump to a specific cell or named range.
Selection Shift + Arrow Shift + Arrow Extend selection by one cell.
Selection Ctrl + Shift + Arrow ⌘ + Shift + Arrow Select to the last nonblank cell in that direction.
Selection Ctrl + Space ⌘ + Space Select entire column.
Selection Shift + Space Shift + Space Select entire row.
Selection Ctrl + A ⌘ + A Select entire worksheet (press twice to include whole sheet when inside data).
Selection Ctrl + Shift + Space ⌘ + Shift + Space Select entire worksheet (alternate on some versions).
Selection Shift + Click Shift + Click Select a range between active cell and clicked cell.
Selection Ctrl + Click ⌘ + Click Add nonadjacent cells or ranges to selection.
Editing F2 Control + U Edit active cell / enter edit mode.
Editing Enter Return Complete cell entry and move down (change direction in options).
Editing Esc Esc Cancel cell entry.
Editing Ctrl + X ⌘ + X Cut selected cells.
Editing Ctrl + C ⌘ + C Copy selected cells.
Editing Ctrl + V ⌘ + V Paste (use Paste Special for options).
Editing Ctrl + Alt + V ⌘ + Control + V Open Paste Special dialog.
Editing Delete Delete Clear cell contents (not formatting).
Editing Ctrl + - ⌘ + - Delete selected cells/rows/columns dialog.
Editing Ctrl + Shift + + ⌘ + Shift + + Insert cells/rows/columns dialog.
Editing Ctrl + D ⌘ + D Fill down from cell above.
Editing Ctrl + R ⌘ + R Fill right from left cell.
Editing Ctrl + ; Control + ; Enter current date.
Editing Ctrl + Shift + ; Control + Shift + ; Enter current time.
Editing Alt + Enter Control + Option + Return Insert line break within a cell.
Formatting Ctrl + 1 ⌘ + 1 Open Format Cells dialog.
Formatting Ctrl + B ⌘ + B Bold.
Formatting Ctrl + I ⌘ + I Italic.
Formatting Ctrl + U ⌘ + U Underline.
Formatting Alt + H, A, C No direct shortcut Center align (Windows ribbon keys: Alt → H → A → C).
Formatting Ctrl + Shift + $ ⌘ + Shift + $ (varies) Apply currency format.
Formatting Ctrl + Shift + % ⌘ + Shift + % (varies) Apply percentage format.
Formatting Ctrl + Shift + # ⌘ + Shift + # (varies) Apply date format.
Formatting Alt + H, O, I No direct shortcut AutoFit column width (Windows ribbon keys sequence).
Formatting Ctrl + 9 ⌘ + 9 Hide selected rows.
Formatting Ctrl + 0 ⌘ + 0 Hide selected columns.
Formulas = = Start a formula in a cell.
Formulas Alt + = ⌘ + Shift + T (Excel Mac may vary) AutoSum (insert SUM formula for adjacent numbers).
Formulas F4 ⌘ + T Toggle absolute/relative references when editing a formula (cycle $A$1).
Formulas Ctrl + ` ⌘ + ` Show/hide formulas in worksheet.
Formulas Shift + F9 ⌘ + = Calculate active worksheet.
Formulas F9 Fn + F9 Evaluate selected part of formula (in formula bar) / calculate.
Formulas Ctrl + Shift + Enter ⌘ + Shift + Return (array formulas vary) Enter an array formula (pre-dynamic array versions).
Worksheet & Workbook Ctrl + N ⌘ + N Create new workbook.
Worksheet & Workbook Ctrl + O ⌘ + O Open workbook.
Worksheet & Workbook Ctrl + S ⌘ + S Save workbook.
Worksheet & Workbook Ctrl + W ⌘ + W Close workbook window.
Worksheet & Workbook Ctrl + Page Up / Page Down Fn + ⇧ + ⌘ + ←/→ (varies) Move to previous/next worksheet tab.
Worksheet & Workbook Shift + F11 ⌘ + T (varies) Insert new worksheet.
Worksheet & Workbook Alt + H, O, R No direct shortcut Rename worksheet (via ribbon sequence: Home → Format → Rename Sheet).
Data Ctrl + T ⌘ + T Create table (format as table).
Data Alt + A, T No direct shortcut Open Sort dialog (Windows: Alt → A → S or ribbon keys).
Data Alt + A, S, S No direct shortcut Sort ascending (ribbon keys sequence).
Data Ctrl + Shift + L ⌘ + Shift + F (varies) Toggle Autofilter on selected range.
Data Alt + A, G, G No direct shortcut Open Group dialog (Group rows/columns).
Data Alt + A, U, L No direct shortcut Remove duplicates (Data → Remove Duplicates).
Data F2 then Ctrl + Enter Control + U then ⌘ + Return Edit cell and keep selection (multiple cell editing technique).
Charts Alt + F1 No direct shortcut Insert default chart in current worksheet (based on selected range).
Charts F11 No direct shortcut Create chart on a new chart sheet.
Review & Collaboration Ctrl + F ⌘ + F Open Find dialog (search in worksheet).
Review & Collaboration Ctrl + H ⌘ + H Replace dialog.
Review & Collaboration Alt + R, A, C No direct shortcut Add a comment / New Note (varies by Excel version—use Review tab shortcuts).
Review & Collaboration Ctrl + Alt + M No direct shortcut Insert a comment (legacy shortcut in some Excel versions).
View & Window Ctrl + F2 ⌘ + P Open Print Preview (or Print dialog).
View & Window Alt + W, F No direct shortcut Freeze Panes (Windows ribbon key sequence).
View & Window Ctrl + Alt + V then W No direct shortcut Switch windows (Open Window dialog) - may vary by Excel version.
View & Window Ctrl + ` ⌘ + ` Toggle show formulas (same as in Formulas section).
Printing & Export Ctrl + P ⌘ + P Open Print dialog / Print Preview.
Printing & Export Alt + F, A ⌘ + Shift + S Save As (Windows ribbon: File → Save As).
Miscellaneous Ctrl + Z ⌘ + Z Undo last action.
Miscellaneous Ctrl + Y ⌘ + Y Redo last undone action (or repeat).
Miscellaneous Ctrl + K ⌘ + K Insert hyperlink.
Miscellaneous Alt (single press) Control + Option (varies) Activate ribbon keys / show KeyTips for ribbon navigation.
Miscellaneous Ctrl + Shift + <plus> ⌘ + Shift + <plus> Insert cells (alternative to Ctrl+Shift+Plus shown earlier).
Miscellaneous Ctrl + Shift + <minus> ⌘ + Shift + <minus> Delete cells (alternative to Ctrl+Minus).
Miscellaneous Alt + F11 Option + F11 Open Visual Basic for Applications (VBA) editor.
Miscellaneous Ctrl + Shift + U ⌘ + Shift + U Expand or collapse the formula bar.
Miscellaneous Alt + Enter (in name box) Option + Return In Name Manager or other dialogs, insert line break; also used in cells for line breaks.
Data Alt + N, V No direct shortcut Open PivotTable creation dialog (Windows ribbon keys: Insert → PivotTable).
Data Alt + A, R, A No direct shortcut Refresh all data connections (ribbon keys sequence).
Formulas Ctrl + Shift + Enter ⌘ + Shift + Return Legacy array formula enter (repeat—important in older Excel).
Formatting Ctrl + 5 ⌘ + 5 Apply or remove strikethrough (varies by Mac version).
Editing Alt + E, S, V No direct shortcut Open Paste Special → Values (Windows ribbon accelerator sequence).
Miscellaneous Ctrl + Alt + Shift + F9 No direct shortcut Force full recalculation of all open workbooks (Excel desktop).
Navigation Ctrl + F3 ⌘ + F3 Open Name Manager (Windows opens Name Manager; Mac behavior varies).
Formatting Ctrl + Alt + 1/2/3 No direct shortcut Apply or remove specific custom styles (if defined); behavior varies.
Miscellaneous F7 ⌘ + Shift + : (varies) Spell check.
Tip: Type "Ctrl", "Alt", "F4", "filter", or a function name in the search box to quickly narrow results. Mac shortcuts shown are general equivalents—some Mac Excel versions differ; ribbon accelerator keys shown are Windows-specific.