How to Adjust Columns, Rows and Text in Excel 2010


show more Adjusting columns, rows, and text provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Adjusting columns, rows, and text

This worksheet is partially formatted and you can see we have our header formatted, we have our column headers formatted, and we have our Total in addition to the numbers. But there's some additional formatting that we need to do. We want to talk about column widths and row height, maybe text alignment. Let's start at the top. Now Row 1, our report header, should be maybe a little taller. When your mouse becomes two-headed arrow here, it has to be on the border between the Row 1 and Row 2 header and click and drag down to make the header a little taller. Click the header so it's selected and it looks great, but it's down on the bottom.

We want this to be vertically centered. So make sure you're on the Home tab and in the Alignment section these three buttons deal with Vertical Alignment. Click the middle one and now it's aligned to the middle. Now we have some room. We could make it a little bigger. Choose a bigger font, if you want. Maybe you choose a different file...

Adjusting columns, rows, and text
Video duration: 5m 2s 6h 21m Beginner

Viewers:

Adjusting columns, rows, and text provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...