Cell dragging autofill (Excel 2007)
Cell dragging autofill (Excel 2007)
(OP)
I have two rows of cells (in COL A, rows 1 and 2) that I want to select and use the lower right drag to fill in the next several columns.
When I select both cells (A1:A2) and drag, it looks like this:
COL
ROW A B C D
1 50.0% 150.0% 250.0% 350.0%
2 30.00 31.00 32.00 33.00
But when I select only A1 or only A2 and drag across it just repeats 50.0% or 30.00 all the way across, which is what I want it to do.
I know that there are other ways to accomplish this, for instance COPY & PASTE seems to work just fine, and does exactly what I want.
I'm just wondering if anyone knows why the drag action does this? If there is a mysterious check box somewhere to stop it? Or if this is just a bug in my machine...
When I select both cells (A1:A2) and drag, it looks like this:
COL
ROW A B C D
1 50.0% 150.0% 250.0% 350.0%
2 30.00 31.00 32.00 33.00
But when I select only A1 or only A2 and drag across it just repeats 50.0% or 30.00 all the way across, which is what I want it to do.
I know that there are other ways to accomplish this, for instance COPY & PASTE seems to work just fine, and does exactly what I want.
I'm just wondering if anyone knows why the drag action does this? If there is a mysterious check box somewhere to stop it? Or if this is just a bug in my machine...






RE: Cell dragging autofill (Excel 2007)
Interesting. Behaves the same on my installation as well.
BUT, if I drag A1 to B1, then A2 to B2, then select A1:B2 and drag, it does exactly what you want it to do. Perhap Excel is assuming that when you select multiple cells in only one column (or row) that it has to increment by 1.
Ralph
Structures Consulting
RE: Cell dragging autofill (Excel 2007)
RE: Cell dragging autofill (Excel 2007)
Or in this case, it needs 2 equal values on athe same row to not increment by 1.
Ralph
Structures Consulting
RE: Cell dragging autofill (Excel 2007)
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Cell dragging autofill (Excel 2007)
I think that it might have something to do with how the various cells are formatted. When I formatted them all as numbers (before, some were currency, percents, general, number) it did not increment any of them when I dragged the entire column over.
RE: Cell dragging autofill (Excel 2007)