Special Edition Using Microsoft® Office XP

Secrets of the Office Masters: Creating Custom Views of Worksheet Data

When you share workbooks within an organization, it's always a challenge to help other users see the data in its best light. A complex workbook can contain several worksheets, charts, and various regions containing data. By selecting the correct worksheet, hiding rows and columns, freezing panes, setting zoom levels, and defining print areas, you can focus on exactly the data you want to. But it's a huge waste of time to repeat all those actions every time you open the worksheet.

Although you can create both custom views and scenarios for use with your own workbooks, these tools are most useful when you want other members of your workgroup to see a workbook exactly as you ...