Formatting a data table


show more Formatting a data table provides you with in-depth training on Business. Taught by Garrick Chow as part of the Computer Literacy for Windows 7 show less
please wait ...

Formatting a data table

Formatting a spreadsheet is very similar to formatting a word processing document. You first just select the text or cell you want to format and then apply your changes. I am working with a very simple spreadsheet I previously created. So let's take a look at some formatting things we can do. First of all, we've already seen that you can use the Number section of the Home tab to specify the appearance of numbers like Currency or Percentages or Date or Time and so on. The Home tab also contains many of the same options you'll find for formatting text under the Font and Alignment areas.

For example, I'll select the cells for Job A and Job B by dragging through them. Now I can make them, say Bold and I can center them. I can also change the color and outline of selected cells. I'll select the Annual Income cells right here, and I'll make them a light green. Excel even has several built-in formatting options under the Style section, under Format as Table. First I'll...

Formatting a data table
Video duration: 2m 19s 3h 33m Beginner

Viewers:

Formatting a data table provides you with in-depth training on Business. Taught by Garrick Chow as part of the Computer Literacy for Windows 7

Subject:
Business
Software:
Windows
Author:
please wait ...