Simplifying Data Organization
When you use Excel, you’re working in an environment designed for logic and clarity. Excel is a spreadsheet after all—no matter what kind of great formatting you use in your workbooks, the concepts of Excel remain black and white. So, for best results whenever you create Excel documents or use Excel to create content for other documents, let the logic of Excel work for you.
Keep in mind that something as simple as the Freeze Panes feature on the View tab can help you review your worksheet data more effectively. Or, when you need to keep an eye on a few specific, important cells in any open workbook, regardless of which open workbook is active at the time, use the Watch Window (available from the Formula Auditing group ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
