View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Laura Laura is offline
external usenet poster
 
Posts: 77
Default 1st Version of Excel to allow

That's all on. I should just be double clicking on the autofill, correct? I
shouldn't have to highlight the cells I want autofilled, correct?

"Dave Peterson" wrote:

Try toggling this setting:

Tools|Options|Edit tab|Check Allow Cell drag and drop.

If you don't have this option toggled on, then you won't see that autofill box
in the lower right corner of the selected cell.

Laura wrote:

Which was the first version of excel to allow users to click in the lower
right-hand corner of a cell to autofill the cells below it? I have a 2002
edition that doesn't allow it. I still have to copy the cell and then drag
the new cells I want to copy the formula in.
Thanks in advance!


--

Dave Peterson