Here's our Microsoft Office Tip for.. October 24, 2006
Click Here to see a complete list of all of our previously released Tips!
Prevent Your Sheet from Scrolling
Several tips ago, we showed you how to copy data from one sheet to another. You simply hold down the Alt key while you drag the cell or cells to the appropriate sheet tab at the bottom of your screen. Excel automatically jumps to that sheet and continues to drag the data to its new home in the target sheet.
You can also use the Alt key while dragging data to prevent the sheet from scrolling. If you've ever had to drag data right to the edge of the worksheet, you already know that Excel can overreact and send you scrolling into oblivion. Holding down the Alt key allows you to move a block of data right to the edge without all that trouble.