Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill
how do I autofill in the reverse direction?
for example, cell A1=AM20 I want to drag cell A1 down so that A2=AM19. Currently if I drag down, A2=AM21. Thanks, Jimmy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill
Try entering =OFFSET($AM$20,1-ROW(),0) in cell A1. When you drag that down,
the ROW() function result increases so that the row of the source cell decreases. "Jimmy" wrote: how do I autofill in the reverse direction? for example, cell A1=AM20 I want to drag cell A1 down so that A2=AM19. Currently if I drag down, A2=AM21. Thanks, Jimmy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill
Thank you very much!!!
"bpeltzer" wrote: Try entering =OFFSET($AM$20,1-ROW(),0) in cell A1. When you drag that down, the ROW() function result increases so that the row of the source cell decreases. "Jimmy" wrote: how do I autofill in the reverse direction? for example, cell A1=AM20 I want to drag cell A1 down so that A2=AM19. Currently if I drag down, A2=AM21. Thanks, Jimmy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-sheet autofill | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) |