In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.
Cells are the basic building blocks of a worksheet. They can contain a variety of content such as text, formatting attributes, formulas, and functions. To work with cells, you'll need to know how to select them, insert content, and delete cells and cell content.
Optional: You can download this example for extra practice.
Each rectangle in a worksheet is called a cell. A cell is the intersection of a row and a column.
Each cell has a name, or a cell address based on which column and row it intersects. The cell address of a selected cell appears in the name box. Here, you can see that C5 is selected.
You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.
If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how.
You can also navigate your worksheet and select a cell by using the arrow keys on your keyboard.