WEBVTT
Kind: captions
Language: en

00:00:07.319 --> 00:00:12.369
Formatting your spreadsheet can make it look
nicer and make it easier to use.

00:00:12.369 --> 00:00:18.900
You'll be amazed at how adding color, borders,
and different shading can really make information

00:00:18.900 --> 00:00:25.230
in your spreadsheet easier to read and use.
In Excel 2007, formatting your information

00:00:25.230 --> 00:00:32.029
as a table is effortless! To format your information
as a table, just select any cell that contains

00:00:32.029 --> 00:00:37.150
information.
Then, in the Styles group on the Home tab,

00:00:37.150 --> 00:00:44.150
click the Format as Table command.
A list of predefined tables appear.

00:00:44.789 --> 00:00:49.140
All you need to do is left-click a table style
to select it.

00:00:49.140 --> 00:00:55.850
Let's see, this one looks nice.
Once you select the table style you want,

00:00:55.850 --> 00:01:01.559
a dialog box will appear.
Excel has automatically selected the cells

00:01:01.559 --> 00:01:06.220
for your table.
We can see from the range listed that it has

00:01:06.220 --> 00:01:12.850
selected cells A1 to G47.
If you need to change that, you can do that

00:01:12.850 --> 00:01:19.850
right in this field.
It looks like I need to include G48.

00:01:20.960 --> 00:01:27.500
If you're table has headings like ours, be
sure this box is selected so Excel knows your

00:01:27.500 --> 00:01:32.979
table has headings.
And click OK.

00:01:32.979 --> 00:01:38.290
And now we can see that our table has been
formatted with the table style we chose.

00:01:38.290 --> 00:01:43.729
By default, the table will be set up with
the drop-down arrows in the header so that

00:01:43.729 --> 00:01:49.939
we can filter the table, if we'd like to.
You can also modify your table once you've

00:01:49.939 --> 00:01:55.710
inserted it.
As you can see, we're on the Table Tools Design

00:01:55.710 --> 00:01:59.710
tab.
This tab is visible once we are working in

00:01:59.710 --> 00:02:04.509
a table.
For example, if I click off the table the

00:02:04.509 --> 00:02:10.479
tab disappears.
As soon as I select a cell inside the table

00:02:10.479 --> 00:02:16.109
the tab is visible and active.
From here, you can make some changes to the

00:02:16.109 --> 00:02:21.290
way the table appears.
You can select a different table style in

00:02:21.290 --> 00:02:28.290
the Tables Styles group.
Or, in the Table Styles Options group, you

00:02:29.669 --> 00:02:36.669
can take away the header row.
You can remove banded rows or columns.

00:02:37.980 --> 00:02:44.980
I'll leave the banded rows because I think
it makes this spreadsheet easier to read.

00:02:45.299 --> 00:02:49.850
You can even make the first and last columns
bold.

00:02:49.850 --> 00:02:56.850
All of these options can be toggled on and
off by selecting and deselecting the box.

00:02:56.980 --> 00:03:01.750
You have some other options in the Tools and
External Data Table groups, but we're not

00:03:01.750 --> 00:03:07.690
going to explore those in this video.
In the Properties group you can name your

00:03:07.690 --> 00:03:14.690
table and you can click Resize Table, to change
the cells that make up your table.

00:03:15.100 --> 00:03:19.760
As you may have noticed, in Excel there are
often many ways you can accomplish the same

00:03:19.760 --> 00:03:24.320
task.
In addition to using the Format as table command,

00:03:24.320 --> 00:03:30.820
you can also select the Insert tab and click
the Table command.

00:03:30.820 --> 00:03:37.329
From here, the process is the same as what
we just went through to insert a table.

00:03:37.329 --> 00:03:43.130
Formatting Tables gives spreadsheets a polished
and professional look! In Excel 2007 you can

00:03:43.130 --> 00:03:46.080
spruce up your spreadsheets quicker than ever
before.