Software Tools Snapshots‎ > ‎Excel‎ > ‎

Basics 1 - Row and Column Selection

Enter a small spreadsheet or download a spreadsheet.

 

Contents of the Exercise

ID

Task

Suggested Method(s)

1

Select column A

Put the cursor on the label “A” and click

The column will become shaded

2

Select row 2

Put the cursor on the label “2” and click.

The row will become shaded.

3

Adjust width of a column

1 - Grab a right column margin and move it

 (or)

 2 – Select option Home / Cells / Format. (A drop-down menu will open up. ) Choose the option “Column width …l”

This “Format” menu is very useful, so put it in your Quick Access Toolbar..

4

Adjust height of a row

1 – Grab a row bottom row margin and move it.

 (or)

 2 – Select optn Home / Cells / Format. Choose the option “Row Height …”

5

Select Columns B through D

Select column B and drag cursor to column D

6

Adjust width of columns B through D

-          Select columns B through D

-          Adjust width of column B

 

(All column widths are adjusted)

7

Select Rows 2 through 4

Select  row 2 and drag cursor to row 4

8

Adjust height of rows 2 through 4

Select rows 2 through 4

Adjust height of row 2