The grid practice exercises

New to spreadsheets? Start here. Learn how cells, rows and columns are named, how to select a range and how to type text and numbers, one small step at a time.

Start the first exercise

How cells, rows and columns work

A spreadsheet is a grid. Columns run left to right and are named with letters, rows run top to bottom and are numbered, and every cell has an address made of the two: column first, then row. The cell where column B and row 3 meet is B3. A range is a block of cells, written with a colon between the first and last cell, so A1:C5 is every cell from A1 to C5. This works the same in Excel and Google Sheets.

Type 25 in B2 and 40 in B3, then type =B2+B3 in B4, and the sheet shows 65. The total changes when you change a number. =SUM(B2:B3) gives the same result using a range.

Text is left-aligned and numbers are right-aligned by default, which is a quick way to spot a number stored as text. Press Enter to confirm what you typed and Esc to cancel it. Be careful with slashes, because Excel may turn 3/5 into a date, Mar 5. The exercises below cover finding your way around the grid, selecting ranges, and typing text and numbers.

  1. 1WelcomeGet started: see how a lesson works and make your first click in the spreadsheet.
  2. 2Cells, rows and columnsFind your way around the grid. Click cells by their address and type in one.
  3. 3Select a rangeSelect ranges of cells with the mouse, and learn how a range is written.
  4. 4Type text and numbersType a heading, a number and a correction into the sheet.

Read the guide

Questions

What is the difference between a workbook and a worksheet in Excel?

A worksheet is one grid of cells, shown as a tab at the bottom of the window. A workbook is the whole Excel file and can hold many worksheets. In Google Sheets the file is called a spreadsheet and the tabs are called sheets. When people say they have an Excel sheet, they usually mean the whole workbook.

Why is my number on the left side of the cell?

Excel treats it as text, not as a number. Common causes are an apostrophe in front, a space or a symbol typed in with the number, or numbers imported from another system. A small green triangle often shows in the corner of the cell. Retype the number cleanly, and check that the alignment hasn't just been set to left.

How many rows and columns does Excel have?

A worksheet in current versions of Excel has 1,048,576 rows and 16,384 columns. The columns run from A to XFD, so the last cell is XFD1048576. You will rarely get near that. Press Ctrl+End to jump to the last cell that is actually in use, which tells you how large your data is.