Home > Tips > Split a Worksheet Into Multiple Panes

Split a Worksheet Into Multiple Panes

February 11th, 2009 Leave a comment Go to comments

You can split a worksheet area into vertical and/or horizontal panes so that you can click inside any one pane and scroll to locate information in that pane while the other panes remain in place.

Drag a split box (the small box at the top of the vertical scroll bar, or at the right end of the horizontal scroll bar) in the direction you want the split to appear. To remove the split, move the pointer over the split until the pointer changes to a double-headed arrow, then double-click the split.

Bookmark and Share
Categories: Tips Tags: ,
  1. No comments yet.
  1. No trackbacks yet.