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

Chapter 5. How to Work a Worksheet > Looking at Worksheets

Looking at Worksheets

Excel provides a few helpful features that you can use to change the way worksheets are displayed. You can set up your workspace for specific tasks, and then save the same view settings for the next time you need to perform the same task.

Splitting Sheets into Panes

Sheet panes allow you to view different areas of your worksheet simultaneously. You can split any sheet in a workbook vertically, horizontally, or both vertically and horizontally, with synchronized scrolling capability. In the worksheet shown in Figure 5-16, columns B through M and rows 4 through 37 contain data. Column N and row 38 contain the totals. In normal view, it's impossible to see the totals and the headings at the same time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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