About this lesson
Recognize the main terms used to describe Excel’s work canvas.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the Excel workbook used in the video tutorial and try the lesson yourself.The Work Surface.xlsx
Application Terminology – The Work Surface.
When to use
Use to understand the main terms used to describe Excel’s work canvas.
Reading the Grid
- Excel’s grid is broken into columns (lettered across the top of the grid) and rows (numbered down the left side of the grid)
- Cells are referred to by the coordinates, always citing the column first, then the row (i.e. A1, B10, D15)
The Name Box
- Located above the upper left of the grid, but below the Ribbon
- This box returns the address (coordinates) of the top left selected cell
- Entering a cell address in this box and pressing Enter will take you there
- If you have named objects in your workbook (like tables), selecting the name from this list will select the object
- Located in the bottom left corner of the interface
- Allows you to select different worksheets in the workbook
- Located above the grid, right of the Name box and below the Ribbon
- Shows you the true contents of the top left selected cell (i.e. formulas instead of the value that shows in the grid itself)
- Can be used to edit cell contents
- Located on the right edge (vertical) and bottom right corner (horizontal)
- These bars allow you to move the focus of the worksheet to other areas
- Located in the bottom right corner of the application
- Allows you to zoom in or out of the worksheet, making it appear larger or smaller
Quick Info Area
- Located in the bottom right corner, to the left of the Zoom Slider
- Takes effect when multiple cells are selected
- Provides quick information like SUMs and AVERAGEs of selected values
Lesson notes are only available for subscribers.