Excel Question - autofill
[Deleted User]
Posts: 25,366
Forum Member
✭✭✭
Okay, so cells A1, 2, 3 each contains the value of "1". A4, 5, 6 each contains "2".....and so on.
How can I drag the cells down so that they autofill correctly (i.e. 3 cells containing the same value, then moving up by an increment of 1 for the next set of 3, etc.)?
How can I drag the cells down so that they autofill correctly (i.e. 3 cells containing the same value, then moving up by an increment of 1 for the next set of 3, etc.)?
0
Comments
=INT(1+((ROW()-1)/3))
Copy this formula as far down the column as you want to extend the list.
If then you want to fix the values:
-- Select cell A1
-- Press Ctrl+Shift+down arrow (to select the whole list)
-- Press Ctrl+C (to copy it to the clipboard)
-- Click on cell A1 again
-- Press Alt+E, then Alt+S, V, then Enter (to paste the clipboard contents as values)
the part of a cell with a $ does not update when copying cells