Advanced Microsoft® Office Documents 2007 Edition Inside Out

Chapter 13. Data-Based Documents: Formatting and Managing Worksheets

Chapter Assumptions

What’s New for Worksheets in Excel 2007

When Your Document Lives in Excel

Streamlining Worksheet Formatting

Treat Your Workbooks Like the Documents They Are

Do you think of your Microsoft Excel files as documents? If not, you might be selling them short. Text-based documents, such as reports that require complex formatting with text, tables, and graphics, surely belong in Microsoft Word. But, when you share a Microsoft Excel file containing worksheets data, charts, or maybe even PivotTable reports, you are absolutely sharing a document.

So, in the first of this book’s chapters on Microsoft Office Excel 2007, we’re looking at formatting documents. From cells, rows, ...