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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access