From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Adjust single and multiple row heights and column widths without commands

Adjust single and multiple row heights and column widths without commands

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Adjust single and multiple row heights and column widths without commands

“

- One of the most common needs in Excel is adjusting the width of columns and to a lesser extent the hight of rows. A lot of the times this is automatic. For example, I want the titles here in these cells to use a larger font. I'll simply go on the Home tab, the option right here, Font Size, I want those to be 14, 16, 18. As I scroll up and down, look what's happening to the row height. It will adjust automatically. Maybe 14 is good enough. Now, meanwhile, the column width isn't quite what I want, it could be related to the titles I just put in, or as we look at some of these, maybe these are already too wide or too narrow, like we see in column B. Now, it's easy to adjust a column width. There might be a tendency, if you're not too familiar with shortcuts, to say, "Well, are their command for this "and where are they?" Perhaps the Home tab? That's where we do a lot of formatting. And sure enough they're found there. It's been a long, long time since I've used these but here they are…

Contents