Using the [Alt] key during a drag-and-drop procedure in Excel

Holding down the [Alt] key when you drag a cell to move it or make a copy is useful in two ways:

1. It prevents the screen from scrolling out of control while you're dragging a cell along the edge of the worksheet frame.

2. It allows you to drag a cell to another worksheet. To do this, you hold down [Alt] as you drag a cell or range onto the tabof the desired worksheet. Excel activates that worksheet and allows you to continue dragging the selection to the spot at which you want to move it. To copy the selection rather than moving it to another worksheet, hold down [Ctrl][Alt] while you drag.

Office 97 Index

Main Index