Cell Addresses

Cell addresses

Each cell has a name or a cell address based on the column and row it is located. For example, this cell in the picture below is C3 because it is where column C and row 3 meet. This means that the row is row3 while the column is column C. as shown in the picture below.

• You can 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 B1, B2, B3, B4, and B5 would be written as B1:B5.

• There is need that you may want to change the default reference style for Excel in case the column in your spreadsheet are labeled with numbers instead of letters. Review our Extra on What are Reference Styles.

The Office Button

How to edit or delete text

•  Select the cell.

• Press the Backspace key on the keyboard to delete text and make a correction.

Or

• Press the Delete key to delete the entire contents of a cell.

• You can also make changes to and delete text from the formula bar. Just select the cell, then place your insertion point in the formula bar. 

How to move through a worksheet using the keyboard

• Press the Tab key to move to the right of the selected cell.
• Press the Shift key then the Tab key to move to the left of the selected cell.
• Use the Page Up and Page Down keys to navigate the worksheet.
• Use the arrow keys.

How to modify columns, rows, and cells