Thread: autofill
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jimmy
 
Posts: n/a
Default 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