WEBVTT
Kind: captions
Language: en

00:00:12.050 --> 00:00:15.720
When you open a new blank workbook, cells
are set to a default size.

00:00:15.720 --> 00:00:20.310
However, as seen here, you may want to go
beyond the default size depending on the type

00:00:20.310 --> 00:00:22.450
of spreadsheet you're working on.

00:00:22.450 --> 00:00:26.860
This column has been resized, for example,
but not quite enough - a couple addresses

00:00:26.860 --> 00:00:28.480
are still getting cut off.

00:00:28.480 --> 00:00:32.500
I'm just going to increase the column width
a little by positioning my mouse over the

00:00:32.500 --> 00:00:37.489
line in the column heading, then clicking
and dragging it to the right.

00:00:37.489 --> 00:00:41.630
You can get even more precise results with
the Format command.

00:00:41.630 --> 00:00:45.039
Choose Column Width to change the column to
a specific measurement.

00:00:45.039 --> 00:00:48.190
The width is measured in pixels.

00:00:48.190 --> 00:00:52.379
Another option is to AutoFit the column, which
will automatically adjust the column so it

00:00:52.379 --> 00:00:55.219
fits the contents of the cells exactly.

00:00:55.219 --> 00:00:59.050
Just go to Format, AutoFit Column Width.

00:00:59.050 --> 00:01:03.260
Now the column is perfectly sized to the text.

00:01:03.260 --> 00:01:04.790
Rows work the same way.

00:01:04.790 --> 00:01:10.430
You can click and drag the line to adjust
the height manually… or use the Format command

00:01:10.430 --> 00:01:16.030
to AutoFit, or specify the height.

00:01:16.030 --> 00:01:18.830
Now I need to add another name to this contact
list.

00:01:18.830 --> 00:01:22.330
I'd like to put it in between rows 3 and 4.

00:01:22.330 --> 00:01:26.580
To insert a new row, all you have to do is
select the row below where you want the new

00:01:26.580 --> 00:01:28.320
one to appear.

00:01:28.320 --> 00:01:31.580
Now click the Insert command.

00:01:31.580 --> 00:01:36.210
Your row appears along with the Insert Options
button, which lets you choose the formatting

00:01:36.210 --> 00:01:37.540
for your new cells.

00:01:37.540 --> 00:01:45.470
I'm going to keep the default, which is the
same formatting as the row above.

00:01:45.470 --> 00:01:48.720
The process is similar for inserting a new
column.

00:01:48.720 --> 00:01:52.470
Just select the column to the right of where
you want the new one to go.

00:01:52.470 --> 00:01:57.560
Click the Insert command, and the new column
will appear to the left.

00:01:57.560 --> 00:02:01.710
Always make sure you select the entire row
or column (by clicking the heading) when you're

00:02:01.710 --> 00:02:03.520
getting ready to insert a new one.

00:02:03.520 --> 00:02:06.530
Otherwise, you'll only insert a cell.

00:02:06.530 --> 00:02:10.390
This is also a good rule to remember for deleting
columns and rows.

00:02:10.390 --> 00:02:15.700
You'll want to make your entire selection,
then click the Delete command.

00:02:15.700 --> 00:02:20.300
Now let's take a look at wrapping text, which
is one way of addressing cells that contain

00:02:20.300 --> 00:02:23.010
more text than they can actually display.

00:02:23.010 --> 00:02:28.250
For example, I'd like to resize my column
of addresses to about half its current size,

00:02:28.250 --> 00:02:30.970
but still be able to see the contents.

00:02:30.970 --> 00:02:35.310
The Wrap Text command can help by displaying
the text on multiple lines.

00:02:35.310 --> 00:02:39.750
Just click, and the text and the rows adjust
automatically.

00:02:39.750 --> 00:02:44.251
Now for the finishing touch - combining the
cells in the top row of my spreadsheet, so

00:02:44.251 --> 00:02:47.590
the title can be centered in a single large
cell.

00:02:47.590 --> 00:02:54.810
To do this, select the cells you want to merge
together, then click the Merge & Center command.

00:02:54.810 --> 00:02:56.740
There - that's perfect.

00:02:56.740 --> 00:03:00.840
To access more merge options, open the drop-down
menu here.

00:03:00.840 --> 00:03:05.320
You can merge your cells across, creating
merged rows instead of a single large cell,

00:03:05.320 --> 00:03:07.730
if you have multiple cells selected.

00:03:07.730 --> 00:03:13.069
You can also merge without centering, or split
your cells up again.

00:03:13.069 --> 00:03:17.470
The best way to learn about merging cells,
wrapping text, and inserting and deleting

00:03:17.470 --> 00:03:19.920
columns and rows, is to practice.

00:03:19.920 --> 00:03:47.170
So give it a try with your own Excel spreadsheet,
and have fun!