Advanced Microsoft® Office Documents 2007 Edition Inside Out

Streamlining Worksheet Formatting

Formatting worksheet content has been a source of stress for many in the past, because doing so has been quite inflexible relative to formatting documents in Word or even in Microsoft PowerPoint. If you combine the new formatting capabilities in Excel with a methodical approach to worksheet formatting, that stress can be a thing of the past.

Taking a methodical approach in this case means to remember that, regardless of what part of a workbook you’re using, the entire workbook is a single unit. The workbook is comprised of sheets, which are comprised of rows and columns, which are in turn comprised of cells.

Why am I stating what seems to be so obvious? Because, if you’re like most Excel users, you don’t usually ...