Microsoft Office Tutorials and References
In Depth Information
Splitting, Freezing, and Locking Panes
INSIDE OUT Find worksheet tabs without scrolling
If you create a workbook with a large number of worksheets, you have to scroll one tab
at a time to see each sheet name. This technique is especially tedious if you used the
Tiled or Vertical options to arrange windows and thereby cut your worksheet to half (or
less) of its normal width. The secret solution? Right-click any of the four scroll buttons
to the left of the sheet tabs to display a menu containing the names of all worksheets
in the current workbook. Click any name to jump straight to that worksheet.
Splitting, Freezing, and Locking Panes
You don’t need to open a second window to compare two different parts of the same
document. Instead, you can split the screen—vertically, horizontally, or both. Each split screen
region scrolls independently, allowing you to compare a block of data in rows 2 through 5
with the contents of rows 2002 through 2005.
To split the current worksheet, use either of the two split boxes. One is located at the top
of the vertical scroll bar, the other at the right of the horizontal scroll bar. Click either split
box, and drag the two-headed split pointer toward the center of the worksheet, as shown
in Figure 14-1.
Horizontal split box
Drag handle to
adjust split location
Vertical split box
Figure 14-1 When you drag the split pointer, it automatically snaps to the nearest row or
column border. Release the mouse button to position the split bar at the current location.
Once the split bar is in place, you can scroll each pane independently and edit cell contents
or formatting in either location. Click and drag the split bar to change its location.
Doubleclick the split bar to remove it and return to a normal, single-pane worksheet window.
Search JabSto ::

Custom Search