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

Chapter 7. Creating a Worksheet with Excel > Splitting a Worksheet in Panes

Splitting a Worksheet in Panes

If you are working on a large worksheet, it can be time consuming and tiring to scroll back and forth between two parts of the worksheet. You can split the worksheet into four panes and two scrollable windows that you can view simultaneously but edit and scroll independently. As you work in two parts of the same worksheet, you can resize the window panes to fit your task. Drag the split bar between the panes to resize the windows. No matter how you display worksheets, Excel's commands and buttons work the same as usual.

Split a Worksheet in Panes

  • Split. Click the Window menu, and then click Split.

  • Remove Split. Click the Window menu, and then click Remove Split.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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