How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Keyboard Shortcut to Jump to the End of a ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the bottom edge of the current block of data…
- Excel Keyboard Shortcut to Insert a Row or LineIn Excel for Microsoft 365 on Windows, select a row and press Ctrl+Shift+= to insert a worksheet row above it; the shortcut…
- Excel Keyboard Shortcut to Insert a NoteIn Excel for Microsoft 365 on Windows, select a cell and press Shift+F2 to insert a note. If the selected cell already…
- Excel Insert Cut Cells Shortcut: Keys and How It WorksIn Excel for Microsoft 365 on Windows, cut the cells with Ctrl+X, select the destination cell, then use Ctrl+Shift++ to insert them…
- Excel Keyboard Shortcut to Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (Control plus the semicolon key) to insert today’s date into the selected cell.…
- Excel Shortcut to Insert Cells Down: Keyboard StepsIn Excel for Microsoft 365 on Windows, select the cell or range where you want space, then press Ctrl+Shift+Plus to open the…
- Excel Keyboard Shortcut to Insert a Column in a SheetIn Excel for Microsoft 365 on Windows, select the column where the new one should go with Ctrl+Space, then press Ctrl+Shift+Plus (Ctrl+Shift+=…
- Excel Keyboard Shortcut to Indent Cells in a WorksheetIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt+H, 6 to increase the indent; press Alt+H,…
- Excel Double-Click Cell Shortcut: Use F2 to Edit CellsIn Excel for Microsoft 365 on Windows, double-click a cell to edit it in place; the keyboard equivalent is to select the…
- Excel Keyboard Shortcut to Duplicate a Sheet QuicklyIn Excel for Microsoft 365 on Windows, there is no single dedicated key combination that instantly duplicates a worksheet. The quickest keyboard…
- Excel Go to Bottom of Data: Keyboard Shortcuts Explained ClearlyIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the bottom edge of the current block of data…
- Excel Decrease Decimal Shortcut: Steps, Mac, and FixesIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, 9 to decrease the displayed decimal…
- Excel Shortcut to Delete Cells and Shift Them UpwardIn Excel for Microsoft 365 on Windows, select the cells to remove, press Ctrl+- (Ctrl and the minus key), choose Shift cells…
- Excel Keyboard Shortcut to Delete a Column SafelyIn Excel for Microsoft 365 on Windows, select any cell in the column and press Ctrl+Space, then press Ctrl+- (the minus key)…
- Excel Shortcuts List: Essential Keys for Faster WorkFor Excel for Microsoft 365 on Windows, the most useful shortcuts include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo,…
- Excel Date and Time Shortcuts: Insert Both InstantlyIn Excel for Microsoft 365 on Windows, press Ctrl+; to insert the current date, or Ctrl+Shift+; to insert the current time. These…
- Excel Insert Shortcut: Add Cells, Rows, and ColumnsIn Excel for Microsoft 365 on Windows, select the cells, row, or column where you want space, then press Ctrl+Shift++ (Ctrl and…
- Excel Shortcut to Highlight All Data in a Column QuicklyIn Excel for Microsoft 365 on Windows, click the first cell in the column’s data and press Ctrl+Shift+Down Arrow to select the…
- Excel Shortcut to Insert Cells and Shift Them DownIn Excel for Microsoft 365 on Windows, select the cell or range, press Ctrl+Shift+Plus (+)—usually Ctrl+Shift+= on a standard keyboard—then choose Shift…
- Excel Group Shortcut: Group Rows, Columns, and DetailsIn Excel for Microsoft 365 on Windows, select the rows or columns you want to collapse and press Alt+Shift+Right Arrow to group…
- Excel Shortcut to Highlight Cells: Fill Color GuideIn Excel for Microsoft 365 on Windows, press Alt, then H, then H to open the Fill Color palette; choose a color…
- Excel Hide Shortcut: Hide and Unhide Rows or ColumnsIn Excel for Microsoft 365 on Windows, press Ctrl+9 to hide the selected row or rows, and Ctrl+0 to hide the selected…
- Excel Shortcut to Go to the Last Row With Data QuicklyIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow from a filled cell to jump to the bottom of that continuous…
- Excel Shortcut to Go to the Top of a Sheet ExplainedIn Excel for Microsoft 365 on Windows, press Ctrl+Home to go to the top-left of the worksheet, normally cell A1. On a…
- Excel Go To Special Shortcut: How to Select Cells FastIn Excel for Microsoft 365 on Windows, press Ctrl+G or F5 to open Go To, choose Special, select a cell type, and…
- Excel Undo Shortcut: Keys, Limits, and How It WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action. On a Mac, press Command+Z. Press the…
- Excel Shortcut to Go to a Cell: F5, Ctrl+G, and MoreIn Excel for Microsoft 365 on Windows, press F5 or Ctrl+G to open the Go To dialog, type a cell reference such…
- Excel Strikethrough Shortcut: Ctrl+5 and MoreIn Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5 to apply strikethrough; press the same shortcut…
- Excel Format Painter Shortcut: Keyboard and Ribbon OptionsIn Excel for Microsoft 365 on Windows, use the ribbon key sequence Alt, H, F, P to activate Format Painter; press the…
- Excel Shortcut for Highlighting a CellIn Excel for Microsoft 365 on Windows, press Alt, H, H to open the Fill Color palette, then use the arrow keys…