From the course: Excel 2013 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Adjusting row heights and column widths - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Exploring font styles and effects4m 7s
-
(Locked)
Adjusting row heights and column widths3m 37s
-
(Locked)
Working with alignment and Wrap Text4m 2s
-
(Locked)
Designing borders3m 26s
-
Exploring numeric and special formatting5m 36s
-
(Locked)
Formatting numbers and dates4m 31s
-
(Locked)
Conditional formatting4m 21s
-
(Locked)
Creating and using tables9m 59s
-
(Locked)
Inserting shapes, arrows, and other visual features6m 28s
-
(Locked)
-
-
-
-
-
-
-
-
-
-
-
-