Columns, Rows, Cells, and Ranges
Selecting a Column
To select a column, click on column header.
Selecting a Range of Connecting Columns
Click on the first column you want and then drag right or left until the last column you want.
Selecting a Range of Non-Connecting Columns
Click on the first column you want then click other columns wanted while holding Ctrl key.
Selecting a Row
To select a row click on row number.
Selecting a Range of Connecting Rows
Click on the first row you want and then drag down or up until the last row you want.
Selecting a Range of Non-Connected Rows
Click on the first row you want then click other rows wanted while holding Ctrl key.
Selecting a Cell
To select a cell, simply click on a cell under a column from a row. You will see the cell address appears on the Name Box to the left of the formula bar.
Selecting a Range of Connecting Cells
Click and drag to select multiple cells. Name Box will show how many rows and columns you are selecting.
Once you’re done selecting range, Name Box will only show the first cell address from the range you selected.
Selecting a Range of Non-Connecting Cells
To select non-connecting or non-adjacent cells, select the first cell and then hold the Ctrl key while selecting other cells. Name Box will show the last selected cell address.
Selecting the Entire Worksheet
To select entire worksheet, click the corner between column A and row 1 heading. Alternatively, use Ctrl + A shortcut.
Second is Creating Worksheet Labels
- On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename.
- Select the current name, and then type the new name.
The third is Entering and Deleting Data
Entering Data
- On the worksheet, click a cell.
- Type the numbers or text that you want to enter, and then press ENTER or TAB.
- To enter data on a new line within a cell, enter a line break by pressing ALT+ENTER.
Deleting Data
You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders) and any attached comments. The cleared cells remain as blank or unformatted cells on the worksheet.
- Select the cells, rows, or columns that you want to clear.
- On the Home tab, in the Editing group, click the arrow next to the Clear button, and then do one of the following.
- To clear all contents, formats, and comments that are contained in the selected cells, click Clear All.
- To clear only the formats that are applied to the selected cells, click Clear Formats.
- To clear only the contents in the selected cells, leaving any formats and comments in place, click Clear Contents.
- To clear any comments that are attached to the selected cells, click Clear Comments.