Formatting as a table


show more Formatting as a table provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Formatting as a table

The previous movies in this chapter showed you how you can format different sections of the spreadsheet independently of one another, by using the Font, Alignment, and Numbering commands, and groups, on your home ribbon. Now I'm going to take a look at some of the more powerful style options by using this style grouping, and specifically the format as a table option. For those of you that would like to follow along, please open the regional EatCake Sales Forecast spreadsheet in your Exercise Files. To use this particular functionality, we're going to start with the title row in our table, and we're only going to highlight the area that we're looking at on the screen here. And I've done that by placing my mouse in cell A3 and clicking and dragging down to sell E29, and releasing the mouse. So you'll notice that I have a highlighted area in front of me here.

The reason I'm doing this is just to easily show you what's happening here, but this can be placed o...

Formatting as a table
Video duration: 2m 27s 5h 13m Beginner

Viewers:

Formatting as a table provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

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