Excel - Autofill - Too Clever
#1
Scooby Regular
Thread Starter
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like
on
1 Post
Excel - Autofill - Too Clever
When copying a number down, one can drag down using the bottom right corner of the cell. [cursor changes to a large +]
Excel is good, as it can work out the increment if multi cells are selected, and use the same increment basis.
However when copying a single cell, excel ASSUMES [incorrectly] that I want to increment by 1, when mostly I don't.
Where do these options live, as I beleive you can set basic rules.
ie - single cell - no increment
multi cells - use same increment
Ta.
Excel is good, as it can work out the increment if multi cells are selected, and use the same increment basis.
However when copying a single cell, excel ASSUMES [incorrectly] that I want to increment by 1, when mostly I don't.
Where do these options live, as I beleive you can set basic rules.
ie - single cell - no increment
multi cells - use same increment
Ta.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM