Jump to the end of a list (any direction):Ctrl+Arrows
Select an entire column / row:Ctrl / Shift+Space
Insert a new row or column:Ctrl++
Delete a row or column:Ctrl+-
🧪 Smart Data Editing & Formatting
Flash Fill: Automatic pattern detection.Ctrl+E
Quick Find & Replace:Ctrl+H
Convert to a dynamic Table: Adds filters in a second.Ctrl+T
Quick currency ($) or percent (%) formatting:Ctrl+Shift+$ / %
📐 Formulas & Calculations
AutoSum: Sums everything above.Alt+=
Lock a cell ($) in a formula: (critical before dragging)F4
Show all formulas in the sheet:Ctrl+~
🔥 The Shift Trick: Want to move an entire row without deleting anything? Select it, hold Shift, and drag the cell border with your mouse to the new location.
