Excel - Autofill - Too Clever
Thread Starter
Scooby Regular
Joined: Oct 2002
Posts: 565
Likes: 1
From: ex UK [SE], now Sunshine State [QLD,AUS]
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
Dec 28, 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM
bluebullet29
General Technical
9
Oct 5, 2015 02:17 PM