Chromebook: Work with the Spreadsheet Area

By Mark LaFay

The spreadsheet area of your Sheets workspace is located directly under the Formula bar. The spreadsheet is made up of a grid of columns and rows. The top of the columns is the column header, and the left side of the rows is the row header.

Columns are referenced by letters, and rows are referenced by numbers. There are permanent scroll bars located at the right and bottom of your spreadsheet so that you can quickly scroll through your sheet.

At the bottom of the spreadsheet area, a tab labeled Sheet1 appears. The name of your current sheet is Sheet1. You can, however, have multiple spreadsheets in one Sheets document.

Row numbers and column letters are imperative for precisely communicating locations within a spreadsheet. A cell’s coordinates are always communicated first with the column letter and then with the row number. For example, A8.

Coordinating a range of cells in a single row or column can be done by specifying the starting cell coordinates and the ending cell coordinates separated by a colon. For example

A8:A24

This example references a range of cells starting in the A column at row 8 and ending at row 24. This figure illustrates what this range would look like.

image0.jpg

If you would like to reference a matrix of cells (meaning a range of cells, spanning multiple rows and columns), you can do so by specifying the coordinates of the top-left corner and the bottom-right corner of the matrix separated by a colon. For example

A8:C24

This figure illustrates what this range looks like in the spreadsheet when selected.

image1.jpg