WEBVTT
Kind: captions
Language: en

00:00:11.360 --> 00:00:14.070
In Excel, every workbook is different.

00:00:14.070 --> 00:00:17.480
That means you may want to modify certain
things—like the size and layout of your

00:00:17.480 --> 00:00:21.090
cells—to better fit the data you're working
with.

00:00:21.090 --> 00:00:25.460
This column has been resized, for example,
but not quite enough—most of the text is

00:00:25.460 --> 00:00:27.210
still getting cut off.

00:00:27.210 --> 00:00:31.360
I'm going to increase the width a little more
by positioning my mouse over the line in the

00:00:31.360 --> 00:00:35.800
column heading, then clicking and dragging
it to the right.

00:00:35.800 --> 00:00:38.500
Another option is to auto-size the column.

00:00:38.500 --> 00:00:43.430
This will automatically adjust the width,
so it fits the contents of the cells exactly.

00:00:43.430 --> 00:00:46.360
Just double-click the line instead of dragging
it.

00:00:46.360 --> 00:00:50.250
Now the column is perfectly sized to the text.

00:00:50.250 --> 00:00:51.790
Rows work the same way.

00:00:51.790 --> 00:00:57.360
You can adjust them manually, or auto-size
them to fit the height of your text.

00:00:57.360 --> 00:01:01.540
Sometimes it's useful to be able to resize
all of your cells at once.

00:01:01.540 --> 00:01:05.990
In this example, I'd like to make all of my
rows the exact same height.

00:01:05.990 --> 00:01:10.310
To do this, click the Select All button in
the top left corner.

00:01:10.310 --> 00:01:15.860
Then resize a row (it doesn't matter which
one)… and the change will be applied to

00:01:15.860 --> 00:01:18.580
the entire worksheet.

00:01:18.580 --> 00:01:21.000
Next I need to add another row to this list.

00:01:21.000 --> 00:01:23.979
I'd like to put it in between row 4 and row
5.

00:01:23.979 --> 00:01:29.140
To add a new row, all you have to do is select
the row heading below where you want the new

00:01:29.140 --> 00:01:32.350
one to appear.

00:01:32.350 --> 00:01:39.299
Then click the Insert command.

00:01:39.299 --> 00:01:42.630
The process is similar for inserting a new
column.

00:01:42.630 --> 00:01:47.439
Just select the column heading to the right
of where you want the new one to go.

00:01:47.439 --> 00:01:53.920
Click the Insert command… and a column will
appear to the left.

00:01:53.920 --> 00:01:56.650
Deleting columns and rows is just as easy.

00:01:56.650 --> 00:02:03.700
First, select the column or row you want to
delete… then click the Delete command.

00:02:03.700 --> 00:02:07.729
The column or row will be deleted, causing
the other cells to move and fill in the gap

00:02:07.729 --> 00:02:09.560
automatically.

00:02:09.560 --> 00:02:14.130
Just remember that there's a difference between
clearing and deleting: deleting cells removes

00:02:14.130 --> 00:02:18.650
them from your worksheet; clearing just removes
the contents.

00:02:18.650 --> 00:02:22.110
You can also move a column or row to a different
location.

00:02:22.110 --> 00:02:25.069
In this example, we'll move a column.

00:02:25.069 --> 00:02:29.440
All you have to do is select the one you want,
then click the Cut command.

00:02:29.440 --> 00:02:35.120
Next, select the column to the right of where
you want the column to be moved.

00:02:35.120 --> 00:02:42.700
Click the Insert drop-down menu on the ribbon…
then choose Insert Cut Cells.

00:02:42.700 --> 00:02:47.050
Another useful technique for rearranging data
is the ability to hide certain columns or

00:02:47.050 --> 00:02:48.050
rows.

00:02:48.050 --> 00:02:51.870
For example, I don't really need to see these
three columns right now; I'd rather focus

00:02:51.870 --> 00:02:54.480
on the customers' email addresses.

00:02:54.480 --> 00:03:01.940
If we right-click… then choose Hide from
the menu… the columns temporarily disappear.

00:03:01.940 --> 00:03:06.560
To unhide them, select the columns on either
side of the ones that are hidden… then right-click

00:03:06.560 --> 00:03:11.490
again… and choose Unhide.

00:03:11.490 --> 00:03:15.489
Let's fast forward to the finished worksheet.

00:03:15.489 --> 00:03:19.239
Next I'd like to take a look at wrapping text,
which is one way of addressing cells that

00:03:19.239 --> 00:03:22.069
contain more text than they can actually display.

00:03:22.069 --> 00:03:27.519
For example, I'd like to resize my column
of addresses to about half its current size,

00:03:27.519 --> 00:03:30.330
but still be able to see the contents.

00:03:30.330 --> 00:03:33.310
We can do this using the Wrap Text command
on the ribbon.

00:03:33.310 --> 00:03:38.080
As you can see, this displays the text on
multiple lines.

00:03:38.080 --> 00:03:42.810
Now for the finishing touch—combining the
cells in the top row, so the title of my worksheet

00:03:42.810 --> 00:03:45.720
can be centered in a single large cell.

00:03:45.720 --> 00:03:51.810
To do this, select the cells you want to merge…
then click the Merge & Center command.

00:03:51.810 --> 00:03:54.010
There, that's perfect.

00:03:54.010 --> 00:03:59.000
To access more merge options, open the drop-down
menu here.

00:03:59.000 --> 00:04:03.379
You can merge across, creating merged rows
instead of a single large cell (if you have

00:04:03.379 --> 00:04:05.409
multiple cells selected).

00:04:05.409 --> 00:04:11.560
You can also merge without centering, or split
your cells up again.

00:04:11.560 --> 00:04:15.269
The best way to learn about merging cells,
wrapping text, and working with columns and

00:04:15.269 --> 00:04:17.239
rows is to practice.

00:04:17.239 --> 00:04:21.030
So the next time you're using Excel, look
for ways that you can customize your worksheet

00:04:21.030 --> 00:04:22.129
to better fit your data.