Page 332 - Excel Workbook for Dummies

35_798452 ch24.qxp 3/13/06 7:48 PM Page 315
Chapter 24: Top Ten Tips for Using Excel like a Pro 315
Side button that you can use to close the windows as soon as you’re done comparing
or transferring data between the two.

While the two workbook windows are in open in Excel, you can select different work-
sheets and scroll to different regions in either one by using its sheet tabs and scroll
bars that appear at the edge of the window when you make its workbook active (either
by clicking the window’s title bar or one of the cells of its worksheets).

To move or copy data between the open workbook files, you have a choice between
using the drag-and-drop or copy-and-paste method. To use drag-and-drop, select the
data to be moved or copied in the worksheet of the one window and then drag the
outline of the cell selection to the desired cell in the worksheet displayed in the other
window. If you want to copy the cell selection rather than move it to the workbook in
the other window, you must remember to hold down the Ctrl key as you drag its out-
line to its new position, releasing the Ctrl key only when you’re in position and ready
to drop the copied data into place.