Excel Keyboard Shortcuts
Work 10x faster in Excel with our interactive shortcut list. Search by key combination or category, and click any shortcut to view the step-by-step guide.
Copy, Cut, & Paste
Standard clipboard operations to duplicate or move cells, formulas, or formatting within your workbook.
Fill Right & Down
Instantly copy the cell value or formula from the top or left adjacent cell down or right into the selection.
Paste Special
Open Paste Special options to paste only cell values, formatting, column widths, or formulas, or transpose rows/columns.
Navigate Cells
Move selected cell box horizontally using Tab or vertically using Enter. Hold Shift to navigate backwards.
Select Row / Column / Sheet
Highlight the entire current row, column, or worksheet instantly without using your mouse pointer.
Hide Rows & Columns
Instantly hide the selected rows or columns from display visibility. (Ctrl+9 for Rows, Ctrl+0 for Columns).
Undo, Redo, & Repeat
Revert actions using Undo, restore them using Redo, or instantly repeat your last formatting action using F4.
Find & Replace
Search for specific text or numbers in your sheet (Ctrl+F) or replace matching text globally with new values (Ctrl+H).
Print & Print Preview
Open Excel print dialog options (Ctrl+P) or load print preview layout (Ctrl+F2) to adjust pages margins before printing.
Save & Save As
Quickly save progress on your workbook file (Ctrl+S) or assign a new filename or folder path (F12).
Rotate Selection Corners
Move the active cell cursor corner-to-corner clockwise within a selected range to review boundaries.
Switch Worksheets
Toggle and navigate between tabs/worksheets in the current active workbook (PageDown for Next, PageUp for Previous).
Switch Workbooks
Toggle focus and navigate between multiple opened Microsoft Excel window files or workspace documents.
Find Next/Prev Match
Instantly jump to the next or previous matching value cell after running your initial search query.
Create Chart
Instantly plot selected data into a new chart sheet (F11) or insert it directly onto the current sheet (Alt+F1).
Quick Number Formatting
Apply currency format (Ctrl+Shift+$), percentage format (Ctrl+Shift+%), date format (Ctrl+Shift+#), or standard number format.
Quick Cell Formatting
Apply Bold (Ctrl+B), Italic (Ctrl+I), Underline (Ctrl+U), or Strike-Through (Ctrl+5) formatting to cell contents.
AutoSum Formula
Automatically insert the `=SUM()` formula matching the current horizontal row or vertical column cell range.
Insert Date & Time
Insert static values for current Today’s Date (Ctrl+;) or Current Time (Ctrl+Shift+:) instantly into active cells.
Ribbon Controls
Toggle the ribbon panel visibility (Ctrl+F1) or show access keys/letter overlays (Alt) to navigate menus with the keyboard.
Workbook Management
Instantly spawn new workbooks (Ctrl+N), open existing files (Ctrl+O), or close the active workbook window (Ctrl+W).
Ribbon Controls Navigation
Navigate and move focus between different tabs, buttons, or group elements in the Ribbon controls using keyboard arrow keys.
Filter Management
Toggle filters on/off (Ctrl+Shift+L) or open the header drop-down options on the active column cell (Alt+Down Arrow).
Convert Range to Table
Instantly convert the selected flat cell data range into a fully structured, filterable, and dynamic Microsoft Excel Table.
Advanced Drag & Drop
Hold Shift while dragging a selected cell border to move the data and insert it between existing cells, shifting others instead of replacing.
Locate Active Cell
Scroll back to instantly view the active cell cursor on the screen without losing your currently selected cell ranges.
Trace Precedents & Dependents
Audit cell formula links. Select cells referenced by the active formula (Ctrl+[) or cells that refer to the active cell (Ctrl+]).
Go To Dialog & Comments
Open the Go To navigation dialog box (F5) or instantly highlight all cells containing text comments (Ctrl+Shift+O).
Edit Cell & Add Notes
Enter cell edit mode positioning the cursor at the end of the text (F2) or insert/edit a cell note comment box (Shift+F2).
Confirm or Cancel Edits
During active cell edits: press Enter to apply modifications and shift down, or Esc to cancel edits and revert.