Introduction to Excel Yitzchak Rosenthal

Example –making cells bold

• Click on cell A1 and drag to cell A3.
• Then press the Bold button to make cells A1,A2,A3 bold.
• You could also press the font or background color buttons to change the color or apply any other formatting you like (this is not shown below).

Other Ways of Selecting More Than One Cell

• To select a large range of cells, click on the upper left cell in the range. Then hold the shift key and click on the lower right cell in the range.
• You can select different “non-contiguous” areas of cells by holding down the Ctrl key while clicking and dragging.

Selecting Non-Contiguous Ranges

• Click and drag to select the first range.
• Ctrl-click and drag to select additional ranges

(This cell is also selected even though it appears white).

Selecting entire Rows, entire Columns or all cells on the worksheet.

• To select an entire column, click on the letter for the column header. To select several columns, click on the header for the first column and drag to the right.
• To select an entire row, click on the number for the row header. To select several rows, click on the header for the first row and drag down.
• To select all of the cells on the spreadsheet, click on the upper left hand corner of the spreadsheet (where the column headers meet the row headers)

Select Entire Columns/Rows/Worksheet

To select ENTIRE COLUMN B click on “B” column header

To select COLUMNS B,C,D click on “B” column header and drag to right

To select COLUMNS B,C and F,G,H

• click on “B” column header, drag to right,
• then Ctrl-Click on “F” column header and drag right

To select ENTIRE ROW 2 click on “2” row header