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.