From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Adjusting row heights and column widths
From the course: Excel 2016 Essential Training
Adjusting row heights and column widths
- You can easily adjust the width of columns and the height of rows. And as we look at this worksheet called Rows and Columns in the workbook called 04 - Formatting, maybe we want to make sure that these columns here, B, C, D, E, F and G are all exactly the same width. Much of the time, when you adjust column widths and/or row heights, you need not go into the menu system. You can simply use the boundaries between columns or the ones between row numbers to make adjustments. Now two possibilities here. If we want all of these monthly columns to be wider, since we've dragged across to select them, we can point to any boundary between the column letters, click and drag. Notice as we do this, we see the number of pixels above it. Now most of the time, we don't really care but sometimes you might. I'll make these 75. Main idea is I want them of a certain width, and I want them all to be the same. So if I were to click right here on the boundary between F and G, holding down the mouse, it's…
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
-
-
-
-
-
-
Exploring font styles and effects3m 17s
-
(Locked)
Adjusting row heights and column widths5m 40s
-
(Locked)
Working with alignment and Wrap Text6m 34s
-
(Locked)
Designing borders2m 55s
-
(Locked)
Exploring numeric and special formatting8m 1s
-
(Locked)
Formatting numbers and dates7m 18s
-
(Locked)
Using conditional formatting8m 13s
-
(Locked)
Creating and using tables11m 18s
-
(Locked)
Inserting shapes, arrows, and other visual features9m 35s
-
-
-
-
-
-
-
-
-
-
-
-
-