Aligning data


show more Aligning data provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Aligning data

Before printing a worksheet or making a presentation using a worksheet it's often better to first consider some alignment techniques that will make the presentation more appealing. It's going to make sense here for example in row 1 and in row 2 to center this data from left to right and one easy feature is simply to highlight the cells. Now the color is added that is your own discretion, but it makes sense to center this title across these cells here and of course Merge & Center. I say "of course" because it is widely known it's great tool for centering. But before doing that what you might also consider doing is selecting not just this data but the row below it.

Let's center both of these from left to right. Merge & Center, and we get a prompt saying that in effect this is going to throw away our second row. So if we click OK here at least throw away the data. What happens? It's gone. We don't want to do that. So it looks as if we got to do this...

Aligning data
Video duration: 3m 49s 3h 43m Intermediate

Viewers:

Aligning data provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...