- [Instructor] Let's practice resizing rows and columns,
and in no time it's going to feel like second nature to you.
It's what you'll spend a lot of time doing, honestly,
and it's something that we all tend to do
right when we first open an Excel file,
because you just need to sort of adjust it
so that it makes sense to you.
For example, let's take this column C here.
I can see that a lot of these words are cut off,
so it's common practice
if you open up an Excel file to resize a column,
and the quickest way to resize a single column
is to hover your mouse right in the line between the column
and click and drag with your mouse.
You can make it wider or smaller.
So what I could do here is just slide it around manually
and feel it out and get it to a place
where it looks comfortable to read.
That's one way to resize a column.
Another way to resize a column is to autofit it,
that is, make it the smallest possible width
so that you can still read all of the text in the column.
The entire column is going to be as wide
as the longest value in any of the cells in that column.
To autofit a column, you can double click right in between
instead of clicking and dragging.
Instantly, the column becomes nice and snug,
but you can still read everything.
Sometimes you'll open up an Excel file
and you'll notice a lot of pound symbols in one column.
That's what happens when there's a number
and it's too small to fit the column.
What I can do now is autofit this column by double clicking,
and now I can read all of the extensions.
Now you might want to autofit all of the columns all at once.
You can do that by clicking in the column header
and dragging to select every column,
and now you can choose any column
and double click to autofit it.
It's going to autofit all of them.
You can also resize them all at once this way.
Just pick any column, click and drag,
and it's going to set every column to that exact same width.
Working with rows is the exact same way.
If I want this header to be a little bit wider,
I can hover my mouse in between row 1 and row 2
and click and drag to make it wider or more narrow.
I'll make it a little bit wider.
Now, something interesting about rows
is that here you'll notice
that the text is almost a little bit hard to read,
because it's aligned to the bottom of the cell,
so what I could do is click the row number
to highlight the entire row
and come up here and format it
to make it a little bit easier to read.
For example, I might middle align it to the cell.
You can also resize multiple rows this way.
I can select a row, hold the Shift key down,
select multiple rows,
click and drag with my mouse, and make them wider,
and every row becomes that wide.
Let's suppose you wanted to bring them back
to their defaults,
or at least a place where it's easier to read
and looks more like a traditional spreadsheet.
Up here in the Home ribbon tab,
click the down arrow next to Format.
Right at the very top, under Cell Size,
choose Autofit Row Height.
Now it's going to do that to the selected row.
You'll notice that this one is back to being nice and small.
If you want to do that to everything,
you can click right here
in the top corner of the spreadsheet.
It's going to select everything, all of your rows,
and if we do this again,
this time it brings everything back,
including that top header row
that we manually adjusted earlier.
Let's head over to the Comments sheet.
This is a completely different sheet from a hotel industry,
but here's some comments.
This is something else that you might come across
when you're looking at spreadsheets.
The way the text wraps in the cell is something
that you can control,
and it's going to adjust the height of that cell.
Here I can see that this text is being cut off
by this cell here,
but if I look in the Formula bar,
I can read the whole thing,
and in this cell, it's extending to the other column.
I can read it all,
but I wouldn't be able to read what's in this column.
What we can do is highlight the entire column
and choose Wrap Text from the Home ribbon tab.
This is going to wrap the text into multiple lines
so that we can read all of it all at once.
I'll do the same thing to this column.
Now I can read that text comfortably
and if I wanted to, of course,
I can still make any manual row
or column adjustments that I want,
but Excel will do it for me
when the column is said to have the text wrapped.