- [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 opened 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 column
is to hover your mouse right in the line
in 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 here, I can read 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 all of the columns.
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 row to be a little bit wider,
I can hover my mouse in between row one and two
and click and drag to make it wider again 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 in the cell
or center it also.
You can also resize multiple rows this way.
I can select a row, hold down the shift key
and select another row,
click and drag with my mouse, make it wider.
And every row becomes that wide.
Let's suppose you wanted to bring them back
to their defaults
or at least to 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,
in the cells area.
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 this one's small.
If you want to do that to everything,
you can click here in the top corner of the spreadsheet.
It's going to select everything, all your rows.
And if we do that again,
this time it brings everything back,
including that top header row
that we manually adjusted earlier.
Let's head over to this 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 the text is being cut off by this cell here.
But if I look in the formula bar,
I can read the whole thing.
In this cell, it's extending over to this column.
I can read it all,
but I wouldn't be able to read what was 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 it comfortably.
And if I wanted to,
I could make any manual adjustments I want.
But Excel will do it for me
when the column is said to have the text wrapped.