Keyboard Shortcuts Google Sheets Navigation

Google Sheets is the browser-based spreadsheet tool in Google Workspace. It shares many shortcuts with Microsoft Excel, but has its own unique ones for features like named ranges, smart fill, and the Explore sidebar. These shortcuts work in Chrome and other modern browsers.

Essential Navigation

  Arrow keys             → Move one cell in any direction
  Ctrl + Arrow           → Jump to edge of data block
  Ctrl + Home            → Jump to cell A1
  Ctrl + End             → Jump to last used cell
  Ctrl + G  or  F5       → Go to specific cell or named range

  MOVE TO ANOTHER SHEET:
  Ctrl + Shift + Page Down → Next sheet
  Ctrl + Shift + Page Up   → Previous sheet

  MOVE BETWEEN SHEETS WITH KEYS:
  Alt + Down Arrow (on sheet tab area) → Sheet options menu

Selecting Ranges

  Shift + Arrow          → Extend selection one cell
  Ctrl + Shift + Arrow   → Extend selection to data edge
  Ctrl + A               → Select all cells with data (then entire sheet)
  Shift + Space          → Select entire current row
  Ctrl + Space           → Select entire current column

  SELECTING A NAMED RANGE:
  Ctrl + G → type the range name → Enter
  → Selects the named range (e.g., "SalesData" jumps and selects it)

Entering and Editing Data

  Enter           → Confirm entry and move down
  Tab             → Confirm and move right
  Esc             → Cancel editing without saving
  F2              → Edit the current cell (move cursor inside formula)
  Delete          → Clear cell content
  Ctrl + D        → Fill Down (copy top cell to selected cells below)
  Ctrl + R        → Fill Right (copy left cell to selected cells right)

  FILL DOWN EXAMPLE:
  A1: "=B1*1.1"   A2:A10 selected
  Ctrl + D → fills A2:A10 with the same formula pattern

Smart Fill and Autocomplete

  Ctrl + Shift + Y  → Smart Fill (Explore suggests a pattern and fills)
  (Similar to Excel's Flash Fill — Ctrl + E in Excel)

  EXAMPLE:
  Column A: "Alice Smith", "Bob Jones", "Carol White"
  Column B: "Alice"
  → Press Ctrl + Shift + Y → Sheets fills B2: "Bob", B3: "Carol"

Formulas in Google Sheets

  =               → Start a formula
  F4              → Cycle reference type ($A$1 → A$1 → $A1 → A1)
  Ctrl + Shift + Enter → Enter as array formula (wraps in ARRAYFORMULA)

  UNIQUE GOOGLE SHEETS FORMULAS (no shortcut but worth knowing):
  ARRAYFORMULA, QUERY, IMPORTRANGE, UNIQUE, FILTER, SORT
  → These functions process entire ranges at once — no Ctrl+Shift+Enter needed

Insert and Delete Rows / Columns

  Select row → Ctrl + Alt + Shift + = → Insert row above
  Select col → Ctrl + Alt + Shift + = → Insert column to left
  Select row → Ctrl + Alt + -          → Delete row
  Select col → Ctrl + Alt + -          → Delete column

  ALTERNATIVE (context menu approach):
  Select row with Shift + Space
  → Right-click (or App key) → Insert / Delete options appear

Format Cells in Google Sheets

  Ctrl + 1          → Open Format Cells dialog (same as Excel)

  QUICK NUMBER FORMATS:
  Ctrl + Shift + 1  → Format as number (1,234.56)
  Ctrl + Shift + 2  → Format as time (HH:MM)
  Ctrl + Shift + 3  → Format as date (DD/MM/YYYY)
  Ctrl + Shift + 4  → Format as currency ($1,234.56)
  Ctrl + Shift + 5  → Format as percentage (12.34%)
  Ctrl + Shift + 6  → Format as scientific notation (1.23E+03)
  Ctrl + Shift + 7  → Add border around cells

Explore Sidebar — AI-Assisted Analysis

  Alt + Shift + X   → Open Explore sidebar

  EXPLORE SIDEBAR FEATURES:
  ✔ Automatic chart suggestions for selected data
  ✔ Natural language questions: type "total sales by month"
  ✔ Summary statistics: sum, average, count shown automatically
  ✔ Formatted insights about the selected data

  Click a suggested chart to insert it instantly.

Quick Reference

  ACTION                        SHORTCUT
  ──────────────────────────────────────────────────────
  Jump to data edge             Ctrl + Arrow
  Jump to A1                    Ctrl + Home
  Go to cell                    Ctrl + G
  Next sheet                    Ctrl + Shift + Page Down
  Fill Down                     Ctrl + D
  Fill Right                    Ctrl + R
  Smart Fill                    Ctrl + Shift + Y
  Insert row/column             Ctrl + Alt + Shift + =
  Delete row/column             Ctrl + Alt + -
  Format as currency            Ctrl + Shift + 4
  Format as percentage          Ctrl + Shift + 5
  Open Explore sidebar          Alt + Shift + X

Ctrl + D (Fill Down) and Ctrl + R (Fill Right) are the Google Sheets shortcuts that most users discover too late. Instead of manually copying a formula and pasting it into dozens of cells below, select the formula cell and the empty cells below it, then press Ctrl + D — the formula fills all of them instantly, adjusting relative references correctly in each row.