WEBVTT
Kind: captions
Language: en

00:00:07.550 --> 00:00:13.620
Now that our table is formatted, let's take
a look at some of our text alignment options.

00:00:13.620 --> 00:00:20.510
Before we do that, let's turn off Filtering.
In Excel, every column in the table has filtering

00:00:20.510 --> 00:00:27.510
enabled in the header row so that you can
filter or sort your table data without having

00:00:27.640 --> 00:00:33.700
to go through a lot of extra steps! To do
this, we can just go back to the Home tab,

00:00:33.700 --> 00:00:40.700
and click the Sort & Filter command
and select Filter from the list.

00:00:40.739 --> 00:00:47.739
Now, over in the Alignment group we have some
Alignment commands that we can use to format

00:00:48.100 --> 00:00:55.100
our text so our table really looks professional.
I think I want to insert another row with

00:00:55.609 --> 00:01:02.609
the title of our table in A1.
We'll call this Scoops Shop Inventory, 

00:01:04.660 --> 00:01:11.240
that's the name of my ice cream shop.
I want this title to appear centered over

00:01:11.240 --> 00:01:18.240
my entire table, so I'll just select A1 through
G1, and then in the Alignment group, I'll

00:01:18.890 --> 00:01:25.890
select the Merge & Center command.
Now my title appears centered across the table.

00:01:27.000 --> 00:01:32.930
As you can see, the column markers don't appear
anymore in row 1, which indicates those cells

00:01:32.930 --> 00:01:37.950
have been merged into one.
If you change your mind, you can always click

00:01:37.950 --> 00:01:44.840
the drop-down arrow next to the command, and
choose Unmerge Cells.

00:01:44.840 --> 00:01:49.470
Now that our title is centered, I'd like to
center my column headings.

00:01:49.470 --> 00:01:56.470
First, I just need to select those cells,
and then click the Center Alignment command.

00:01:57.430 --> 00:02:04.430
If I wanted to, I could align the text to
the left or align it to the right 

00:02:06.200 --> 00:02:12.360
but I think it looks best centered.
Now, I do think the Package Size would look

00:02:12.360 --> 00:02:19.360
best right aligned, so I'll just left-click
the column heading to select column E, and

00:02:20.400 --> 00:02:27.400
then click the Align Text Right command.
Another set of alignment commands in the group

00:02:29.000 --> 00:02:35.450
are the Top Align, Middle Align, and Bottom
Align commands.

00:02:35.450 --> 00:02:43.840
To see how these work, let's increase the
height of row 1 and I'll just go ahead and

00:02:43.840 --> 00:02:53.860
make our title bigger and bold it.
Now, if I click the Top Align command, the

00:02:53.860 --> 00:02:59.090
title will align to the top of the cell.
The Bottom Align command moves the text to

00:02:59.090 --> 00:03:04.090
the bottom of the cell, and the Middle Align
command centers it in the middle.

00:03:04.090 --> 00:03:09.750
A really useful Alignment command is the Wrap
Text command.

00:03:09.750 --> 00:03:16.750
To show you how this works, let me start a
new column in H1.

00:03:17.790 --> 00:03:23.850
As I move down to the next cell, Excel realizes
that I am adding to the table and automatically

00:03:23.850 --> 00:03:30.850
formats it for me.
Now, in H2, I want to type a reminder to myself.

00:03:36.040 --> 00:03:39.760
As you can see the text is overflowing to
the next cell.

00:03:39.760 --> 00:03:44.830
If I want to format this so I can view all
the text, I can select the cell and click

00:03:44.830 --> 00:03:50.140
the Wrap Text command.
All the text is wrapped and appears in the

00:03:50.140 --> 00:03:56.220
cell.
If you don't want to format each cell individually,

00:03:56.220 --> 00:04:01.319
you can select multiple cells and then click
the Wrap-Text command.

00:04:01.319 --> 00:04:08.319
Now, when I enter text into the cell, it will
automatically wrap so that it all appears.

00:04:10.280 --> 00:04:16.569
You can still adjust the column width, and
the text will wrap to fit the new column size.

00:04:16.569 --> 00:04:21.180
The final command I want to show you is the
Orientation command.

00:04:21.180 --> 00:04:28.180
This one allows you to format text in a variety
of ways such as clockwise, vertical, and rotated.

00:04:28.680 --> 00:04:34.949
I think I'll insert another column and add
more information here along the left.

00:04:34.949 --> 00:04:42.650
After inserting the column, I need to type
in the information, then select a couple of cells 

00:04:42.650 --> 00:04:47.960
here on the side, and click Merge and
Center.

00:04:47.960 --> 00:04:54.960
Now, if I click the Orientation command, and
click Rotate Text Up, the text will be formatted

00:04:56.949 --> 00:05:01.689
here on the side.
I need to increase my text size so it will

00:05:01.689 --> 00:05:08.689
line up with the top of my spreadsheet.
There, that looks pretty good! 
0:05:10.509,0:05:08.689
Whether we are moving, rotating, or wrapping text, Excel
2007 makes Aligning text easy.