Happy new year to you all
Is it possible to change the Autofill setting from 'fill series' to 'copy cells' in Excel 2003? Otherwise I have to keep changing it after each autofill, which is an additional two mouse clicks - not that I'm lazy...just trying to be more efficient
Last edited by Prium; 01-08-2009 at 02:42 PM.
Use the fill handle by dragging the bottom right corner of the cell, when the box pops up click on it and select copy instead of fill.
That doesn't answer my question.
Excel will always default to fill series. Would be nice if it remembered the last setting used (i.e., copy cells)....kinda like what OO Calc does.
Why not just copy and the select the range to paste?
The number of times I have to do this is mind-numbing.
I figured if I can get away with just using the mouse and just using a double click per copy then i could get it done faster, without RSI, and without doubling back on any accidental range-paste-mistakes.
It's actually from a Pivot Table. All I am doing is filling in all the blanks manually - the blanks that excel leaves when it groups items.
Last edited by Prium; 01-07-2009 at 10:37 PM.
hi
This doesn't answer your question either but it is a solution & will help you be more efficient ;-)
Select the entire range starting in the top left header/grouping cell, press [F5], choose Special - Blanks & [enter], type "=", press the up arrow (which should then make your formula say something like "=A1"), make sure there are no dollar signs forcing an absolute or mixed reference and then press [ctrl + enter] which then makes all the blank cells equal to the value above them.
Reselect your entire range, [ctrl + c] to copy, [alt + e + s + v] & [enter] to paste special as values & BINGO!
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Incredible!
Truly grateful for that broro183. Ka pai
Original question is moot now. I suspect the default autofill cannot be easily changed anyway.
Thanks for the feedback :-)
If you have any other mind-numbing repetitive Excel tasks it may be worth opening a new thread for each because chances are that there are other techniques which seem as incredible & before you know it you could have halved your work time! ;-)
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Hi! You can also hold ctrl when you pull down the autofill - this seems to be the most practical way of doing it for me as i often use this function also in my job. This way the autofill function automatically reverts to copy.
Ha - just realised someone has already put this above!!- Still it works for me!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks