EdTech Help GuidesED206 Excel TCAHow Do I Format The Data In A Spreadsheet?

How Do I Format The Data In A Spreadsheet?

Below is instructions on how to format data in a spreadsheet.  Formatting options include font, merge and center, and backgrounds.

Format the data (A1-F19) to Courier New 10 pt. black

1. Select the home tab.

2. Highlight all of the data from A1-F19.

3. Select which font you want to use, using the icon shown above.

4. Select the size you want to use.

5. Change the color of the font by selecting the icon shown above. (An A with a line underneath).

Format the text in Row 1 to Courier New 16 pt. purple, bold

1. Select the home tab.

2. Click into cell A1.

3. Select the size you want to use, using the icon shown above.

4. Select the bold button.

5. Change the color of the font by selecting the icon shown above. (An A with a line underneath).

Merge and center the text in Row 1 across columns A-F

1. Select the home tab.

2. Highlight the data from A1-F1.

3. Select the merge and center drop-down box.

4. Select the merge and center option.

Format the headings in Row 5 to Courier New 12 pt. black, italic, centered.

1. Select the home tab.

2. Highlight the data from A5-F5.

3. Select the italic button.

4. Select which font you want to use, using the icon shown above.

5. Select the size you want to use, using the icon shown above.

6. Select the center text button.

Add a light yellow cell background to the headings in Row 5.

1. Highlight the data from A5-F5.

2. Select the fill color button, using the icon shown above.  

3. Select the color you want to use.

The color does not have to be the exact shade of light yellow shown in the example above. It should, however, look as close to the final excel project as possible.

Created by Emily H

0 Comments

Add your comment

E-Mail me when someone replies to this comment