1
Understand spreadsheet selection
In this tutorial, you will learn how to select cells, rows, and columns.
These selection tools help you format and organise your spreadsheet with confidence.
Selecting Cells, Rows, and Columns in a Spreadsheet
Learn the essential selection tools in the Spreadsheet block. This guide covers how to select individual cells, multiple cells, entire rows, and full columns so you can format, organise, and edit your spreadsheet with ease.
Selecting Cells, Rows, and Columns
- Select individual cells, multiple cells, rows, columns, or the entire spreadsheet.
- Use selections to format, edit, adjust layouts, or make bulk changes efficiently.
Select cells, rows, and columns
2
Select a single cell
Click once on any cell to select it.
The selected cell will be highlighted with a border.
3
Select multiple cells by dragging
Click and drag across neighbouring cells to select a range.
This is useful when you want to format or edit several nearby cells at once.
4
Select multiple cells with Shift
You can also hold Shift and click another cell.
This highlights everything between the first selected cell and the second point.
5
Select an entire row
Click the row number on the left side of the spreadsheet.
The entire row will be highlighted.
6
Select an entire column
Click the column letter at the top of the spreadsheet.
This selects the full column.
7
Select multiple rows or columns
Click and drag across multiple row numbers or column letters.
This lets you select more than one row or column at a time.
8
Select all cells
Click the top-left corner button where the row numbers and column letters meet.
This highlights the entire spreadsheet.
FAQs