Rows, columns and sheets

Updated November 13, 2026

Rows and columns

  • Insert: select rows or columns, then Home › Insert, or Insert › Rows (Ctrl+Shift+=) or Insert › Columns.
  • Delete: select them, then Home › Delete, or Format › Delete Rows (Ctrl±) or Delete Columns.
  • Resize: drag the line between two headers, or choose Format › Row Height… or Column Width…. Double-click the line, or choose Format › AutoFit Column Width, to fit the contents.
  • Hide and show: Format › Hide & Unhide has Hide Rows (Ctrl+9), Hide Columns (Ctrl+0), Unhide Rows and Unhide Columns.
  • Select a whole row or column: Shift+Space selects the row, Ctrl+Space the column.

Sheets

  • Add a sheet: choose + beside the sheet tabs, or Insert › Sheet (Shift+F11).
  • Rename: double-click its tab, or Format › Rename Sheet.
  • Move or copy: drag the tab, or Format › Move or Copy Sheet….
  • Hide, show or delete: Format › Hide Sheet, Unhide Sheet… or Delete Sheet.

Was this article helpful?