From the course: Excel 2010 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 columns, rows, and text

Adjusting columns, rows, and text - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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 altogether if you…

Contents