Custom Spreadsheet Solutions
Productivity – powered by Excel

Workbook, Worksheets, and Cells.

There is some terminology that is important to understand when using an Excel spreadsheet.

The workbook is the whole file. You can change the name of the workbook by saving the file with a new name.

A workbook can have one or more worksheets. Each worksheet is listed across the bottom of the workbook in “tabs”. You can rename a worksheet, by right clicking on the “Tab” and choosing Rename.

Each sheet is made up of cells. These are the rectangles that information lives in within your spreadsheet. Each cell has a location/name designated by a letter and number, like a grid reference.

You can also rename cells, by using the Name box, found in the top left-hand corner of the sheet. Below, cell B93 has been called GivenName.

B93 has been renamed GivenName

Cell names are not allowed to have gaps in them.