From the course: Excel 2013 Essential Training

Unlock the full course today

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

Adjusting row heights and column widths

Adjusting row heights and column widths - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Adjusting row heights and column widths

You can easily adjust the width of columns and the height of rows whenever needed. You're much more likely to need these with columns. Rather than using commands, although you can, it's much, much easier to use the actual column separators. If I want to make column B wider, I'll point the mouse on the boundary between B and C, where the actual letters are, click and drag to make it wider or in some cases narrower. If you make a column too narrow for the numbers to be displayed properly, you will see pound signs. A better solution sometimes is simply to double-click a boundary, and that means in effect, make the column wide enough to handle the widest entry; so we'll double-click. Now, if at a later time, if we happen to put a word here or a long number, maybe I'll put in a long word like this, and press Enter. The column width doesn't adjust, but if I double-click the boundary between B and C, it certainly does. I misspelled it anyway, but if I take that out, what happens? The column…

Contents