Open an existing worksheet

1. If your worksheet is not open,
2. Choose File / Open.
3. The Open dialog box appears.
1. Select the appropriate drive, folder, and filename.
2. Click Open.

Top of Page

Formatting a worksheet

Your sheet will look like the one illustrated below when you complete this activity.

Changing Font

1. Select all the cells that contains names of the months.

To do this, point to the cell that contains Jan, hold down the left mouse button, and drag the mouse pointer until Feb, Mar, . . ., Nov, and Dec have been selected.

If the formatting toolbar is visible,

2. Choose a font typeface from the drop-down list.
3. Choose a font size from the drop-down list.
4. Choose bold, italic, underline. (optional)

If the formatting toolbar is not visible,

2. Choose Format / Cells.
3. Select the Font Tab. (See below)

4. Choose a font typeface from the drop-down list.
1. Choose a font size from the drop-down list.
2. Choose bold, italic, underline. (optional)
5. Click OK.

Top of Page

Centering Data

1. Select all the cells that contains temperatures in Alaska and Michigan.

If the formatting toolbar is visible,

2. Click on the Center button.

If the formatting toolbar is not visible,

2. Choose Format / Cells.
3. Select the Alignment Tab. (See below)
1. Choose Center.
4. Click OK.

   Top of Page

Shading Data

1. Select all the cells that names of states (Alaska and Michigan).
2. Choose Format / Cells.
3. Select the Pattern Tab.
1. Choose a light color or light gray.
4. Click OK.

Top of Page

Using AutoFormat

1. Select all the cells in your worksheet. (A1 through M3).
2. Choose Format / AutoFormat.
3. Select a format from the drop-down list.

The example is Classic 3.

4. Click OK.

Top of Page

Adding a Heading or Title Row

1. Select any cell in row 1 of your worksheet by clicking on it.
2. Choose Insert / Rows.

The new row will be inserting above the selected cell.

3. Click on cell A1.
4. Type the heading or title of your sheet.

For example, Temperatures in Alaska and Michigan.

Top of Page

Merging Cells and Centering Data Across Columns

Note that the heading is left-justified. We would like to center the heading across all the columns of our sheet.

1. In row 1, select cells A1 through M1. (All the cells in row 1.)

If the formatting toolbar is visible,

2. Click on the Merge and Center button.


If the formatting toolbar is not visible,

2. Choose Format/Cells.
3. Select the Alignment Tab.
1. Choose Center Across Selection.
4. Click OK.

Top of Page

Changing the Text Color

Let’s change the color of the heading.

1. In row 1, select cells A1 through M1. (All the cells in row 1.)

If the formatting toolbar is visible,

2. Click on the Font Color button.

3. Click on the color of your choice.

If the formatting toolbar is not visible,

2. Choose Format / Cells.
3. Select the Font Tab.
1. Choose Color.
2. Click on color choice from the palette.
4. Click OK.

Changing the Background Color

Let’s change the background color of the heading.

In row 1, select cells A1 through M1. (All the cells in row 1.)

If the formatting toolbar is visible,

1. Click on the Fill Color button.

2. Click on the color of your choice.

If the formatting toolbar is not visible,

2. Choose Format / Cells.
3. Select the Patterns Tab.
1. Click on color choice from the palette.
2. Click OK.

Save your worksheet

Print your worksheet

Caution: Some color choices do not print on black and white printers. You may need to experiment to see what colors choices will work.

Top of Page

Copyright - Technology Training Team

Please contact us at TechTrainTeam