Keyboard Shortcuts Excel Row Column Operations

Inserting, deleting, hiding, and resizing rows and columns in Excel is something spreadsheet users do constantly. These operations are far faster with keyboard shortcuts than with right-click menus, especially when working with large datasets that require frequent structural changes.

Selecting Rows and Columns

  Shift + Space      → Select the entire current row
  Ctrl + Space       → Select the entire current column
  Ctrl + Shift + Plus(+) → Insert (after selecting row or column)
  Ctrl + Minus (-)   → Delete selected row, column, or cells

  WORKFLOW — Insert a new row:
  Click any cell in row 5
  Shift + Space      → Row 5 is fully selected
  Ctrl + Plus (+)    → New blank row inserted above row 5
                       Old row 5 becomes row 6

Insert Rows and Columns

  SELECT FIRST, THEN INSERT:
  Select row(s): Shift + Space → Ctrl + Plus
  Select column(s): Ctrl + Space → Ctrl + Plus

  INSERT MULTIPLE ROWS AT ONCE:
  Select 3 rows (Shift + click row headers, or Shift+Space + Shift+Down)
  → Ctrl + Plus → 3 new rows inserted above selection

  EXAMPLE:
  Rows selected: 5, 6, 7 (3 rows)
  Ctrl + Plus → 3 new blank rows appear above row 5

Delete Rows and Columns

  SELECT THEN DELETE:
  Select row: Shift + Space → Ctrl + Minus
  Select column: Ctrl + Space → Ctrl + Minus

  DELETE vs CLEAR:
  Ctrl + Minus (after selecting row)   → REMOVES the row entirely
                                         (rows below shift up)
  Delete key (after selecting row)     → CLEARS content only
                                         (row still exists, now empty)

  COMMON MISTAKE:
  Pressing Delete on a selected row clears the content
  but the empty row remains. Use Ctrl + Minus to remove the row itself.

Hide and Unhide Rows and Columns

  HIDE:
  Select row(s) → Ctrl + 9       → Hide rows
  Select column(s) → Ctrl + 0   → Hide columns

  UNHIDE:
  Select rows on BOTH SIDES of the hidden rows
  → Ctrl + Shift + 9             → Unhide rows

  Select columns on BOTH SIDES of the hidden columns
  → Ctrl + Shift + 0             → Unhide columns

  VISUAL EXAMPLE (hidden row 3):
  ┌──────┬─────────┐
  │  1   │ Alice   │
  │  2   │ Bob     │
  │  4   │ Diana   │  ← row 3 (Charlie) is hidden
  └──────┴─────────┘

  Select rows 2 and 4 (both neighbors)
  Ctrl + Shift + 9 → row 3 reappears

Auto-Fit Column Width and Row Height

  SELECT COLUMN(S) → Ctrl + Space → then:
  Alt + H → O → I     → AutoFit Column Width
                        (expands column to fit the longest content)

  SELECT ROW(S) → Shift + Space → then:
  Alt + H → O → A     → AutoFit Row Height

  QUICK AUTOFIT (mouse alternative):
  Double-click the column divider in the column header
  → Column auto-fits to content width instantly

  AUTOFIT ALL COLUMNS AT ONCE:
  Ctrl + A → Alt + H → O → I
  (select all cells first, then autofit all columns)

Grouping Rows and Columns

  GROUP (collapse/expand):
  Select rows or columns → Alt + Shift + Right Arrow → Group
  → A bracket appears on the side with a [-] collapse button

  UNGROUP:
  Select grouped rows/columns → Alt + Shift + Left Arrow

  COLLAPSE/EXPAND GROUPS:
  Alt + A → H  → Hide (collapse) selected group
  Alt + A → J  → Show (expand) selected group
  Ctrl + 8      → Toggle outline symbols (show/hide +/- buttons)

  USE CASE: Monthly detail rows grouped under quarterly summary rows.
  Click [-] to collapse months and see only quarterly totals.
  Click [+] to expand and see the monthly breakdown.

Freeze Panes (from Previous Topic — Quick Reminder)

  Alt + W → F → F  → Toggle Freeze Panes
  (freezes rows above and columns left of the active cell)

Format Cells Dialog

  Ctrl + 1         → Open Format Cells dialog
  ┌─────────────────────────────────────────────────────────┐
  │  Number │ Alignment │ Font │ Border │ Fill │ Protection │
  └─────────────────────────────────────────────────────────┘
  → Set number formats, borders, backgrounds, fonts from one place

Quick Reference

  ACTION                        SHORTCUT
  ──────────────────────────────────────────────────────
  Select entire row             Shift + Space
  Select entire column          Ctrl + Space
  Insert row/column             Ctrl + Plus (+)
  Delete row/column             Ctrl + Minus (-)
  Hide rows                     Ctrl + 9
  Hide columns                  Ctrl + 0
  Unhide rows                   Ctrl + Shift + 9
  Unhide columns                Ctrl + Shift + 0
  AutoFit column width          Alt + H → O → I
  Group rows/columns            Alt + Shift + Right Arrow
  Ungroup                       Alt + Shift + Left Arrow
  Format Cells dialog           Ctrl + 1

Ctrl + Minus and Ctrl + Plus for deleting and inserting rows are the operations that save the most time in everyday spreadsheet editing. Clicking through right-click menus for these actions is slow when you need to insert or delete dozens of rows in sequence. Mastering the select-then-act pattern — Shift + Space to select a row, then Ctrl + Minus to delete it — makes row management feel effortless.