Loading…
Loading…
Select a whole column with Ctrl+Space and a whole row with Shift+Space, or click the column letter or row number. In Excel that is all 1,048,576 rows or 16,384 columns; this practice grid is smaller (40 rows, 14 columns), so a whole column here is B1:B40. Extend with Shift: Shift+→ adds the next column, Shift+Click on a header selects everything in between.
Example: Click any cell in column B and press Ctrl+Space to select the whole of column B.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.