• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Using Excel in a Workgroup > Creating Custom Views of Worksheet Dat...

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 different regions containing data. By choosing the right 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 do.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint