Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you speed UP drag speed?
Our company has recently switched over to Excel 2003 from 2000 and we've come
to find out that the drag speed is far to slow for us. I know many people had problems with going to fast... I guess it worked for us. I'm wondering if there is any way to speed UP the drag speed? On some of our reports we're dragging 24,000 rows and Autofill doesn't work for us as there are blanks in the information to the left. |
#2
|
|||
|
|||
Can you speed UP drag speed?
Can you split the window? If you split it such that the first few and last
few rows are visible, you can select the entire area to fill without having to scroll. Select the first cell to fill, then click in the first cell to be filled ('above' the split), ctrl+click in the last cell to be filled ('below' the split) and paste. (In order to effect the split, ctrl+end, go up a few rows, select the row and Window Split). HTH. --Bruce "Ryan W" wrote: Our company has recently switched over to Excel 2003 from 2000 and we've come to find out that the drag speed is far to slow for us. I know many people had problems with going to fast... I guess it worked for us. I'm wondering if there is any way to speed UP the drag speed? On some of our reports we're dragging 24,000 rows and Autofill doesn't work for us as there are blanks in the information to the left. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed up and slow down, the auto-scroll. | Excel Discussion (Misc queries) | |||
Prevent Drag & Drop | Excel Discussion (Misc queries) | |||
How to Reduce Spreadsheet Size and Speed | Excel Worksheet Functions | |||
How do you control scroll rate when click and drag to select cell | Excel Discussion (Misc queries) | |||
I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) |