Thread: Autofill lists
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Autofill lists

I don't see how you could highlight column A and then enter a value in
some other cell (eg B1) - the highlight would disappear when you
clicked on B1 to enter the number 70.

You can autofill quite easily by entering 1 in A1. Select A1 again and
hold the <shift key down while pressing <page_down or <arrow_down
until you reach A70, then release <shift - this will have highlighted
the range. Then Edit | Fill | Series and check Linear with a step value
of 1, then click OK. Is this any use?

Pete