jeberle.github.io

Excel Keys

Selection

Sh-<Space>: Select Row / Table Row

Ctrl-<Space>: Select Column / Table Column

Ctrl-<Star>: Select contiguous cells

F8: Select mode

Sh-F8: Add select

Worksheet Edits

Cmd-<Plus>: Insert Cells, Rows, Cols (quantity of whatever is selected)

Cmd-<Minus>: Delete Cells, Rows, Cols (whatever is selected)

Scrolling / Navigation / UI

Ctrl-<Up, Down, Left, Right>: Go to next boundary of contiguous cells

Ctrl-<Home>: Go to top-left corner

Ctrl-<End>: Go to bottom-right corner (outermost modified cell)

Opt-<PageUp, PageDown>: Move one screen left / right

Opt-Cmd-R: Toggle Ribbon

Opt-Left / Right: Switch to Prev / Next Worksheet Tab

Ctrl-F: Find

Values / Formulas

F2: Edit cell contents

Cmd-D: Fill (or copy) down

Cmd-R: Copy Right

Sh-F3: Formula Builder

Opt-Cmd-<Equals>: Autosum

Ctrl-<Semi>: Insert current date

Edit Mode

F2: Toggle between Point and Edit mode

F4 / Cmd-T: Cycle through Absolute, AbsRow, AbsCol, Relative addressing

Cmd-R: Align Right

Tab: Tab-complete selection drop-down

Tables

Cmd-T: Create Table

Sh-Ctrl-L: Toggle Table Filter buttons

Names

Name columns, ranges, as well as cells. They work like worksheet-level Table refs

Ctrl-G / F5: Goto Name

F3: Paste Name

Ctrl-L: Define name

Cmd-F3: Define Name dialog

Sh-Cmd-F3: Create Names dialog

Insert > Name > Define Name...

Cell Format

Ctrl-1: Format Cells dialog

Ctrl-~: General Format

Ctrl-!: Number Format: 0,000.00

Ctrl-@: Time Format

Ctrl-#: Date Format

Ctrl-$: Currency Format

Ctrl-%: Percentage Format

Various

Ctrl-Cmd-V: Paste Special

Ctrl-E: Flash fill

Sh-F10: Context menu

Select References

Ctrl-[: Select only cells that are directly referred to by formulas in the selection

Ctrl-{: Select all cells that are directly or indirectly referred to by formulas in the selection

Ctrl-]: Select only cells with formulas that refer directly to the active cell

Ctrl-}: Select all cells with formulas that refer directly or indirectly to the active cell

• Right drag corner for options on fill
• Edit > Paste Special: Add adds value from clipboard to paste range
• Select cell w/ desired format. “Paint Format” other cells to copy formatting
• Select range, enter 1st value, Shift-enter to fill all cells w/ value
• Use INDEX & MATCH instead of VLOOKUP, HLOOKUP

Keyboard shortcuts in Excel