Microsoft Office Tutorials and References
In Depth Information
Comparing sheets side by side
Multiple windows make copying or moving information from one worksheet to another easier. You can use Excel’s
drag-and-drop procedures to copy or move ranges.
Comparing sheets side by side
In some situations, you may want to compare two worksheets that are in different
windows. The View Side by Side feature makes this task a bit easier.
First, make sure that the two sheets are displayed in separate windows. (The sheets can be
in the same workbook or in different workbooks.) If you want to compare two sheets in the
same workbook, choose View Window New Window to create a new window for the active
workbook. Activate the fi rst window; then choose View Window View Side by Side. If
more than two windows are open, you see a dialog box that lets you select the
window for the comparison. The two windows are tiled to fi fill the entire screen.
When using the Compare Side by Side feature, scrolling in one of the windows also
scrolls the other window. If you don’t want this simultaneous scrolling, choose
Synchronous Scrolling (which is a toggle). If you have rearranged or
moved the windows, choose View Window Reset Window Position to restore the
windows to the initial side-by-side arrangement. To turn off the side-by-side viewing, choose
View Window View Side by Side again.
Keep in mind that this feature is for manual comparison only. Unfortunately, Excel doesn’t
provide a way to actually point out the differences between two sheets.
Splitting the worksheet window into panes
If you prefer not to clutter your screen with additional windows, Excel provides another
option for viewing multiple parts of the same worksheet. Choosing View Window Split
splits the active worksheet into two or four separate panes. The split occurs at the location
of the cell pointer. If the cell pointer is in row 1 or column A, this command results in a
two-pane split; otherwise, it gives you four panes. You can use the mouse to drag the
individual panes to resize them.
Figure 14.7 shows a worksheet split into two panes. Notice that row numbers aren’t continuous.
The top pane shows rows 8 through 20, and the bottom pane shows rows 694 through 708. In
other words, splitting panes enables you to display in a single window widely separated areas of
a worksheet. To remove the split panes, choose View Window Split again.
Search JabSto ::

Custom Search