View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default Drag cells autonumber feature went bye bye?!?!?

Hi,

How is it not working? Are you selecting both cells before dragging? Also
check Tools/Option/Edit/Allow cell drag and drop.

HTH
Jean-Guy

" wrote:

I had a simple spredsheet wherein column A I could enter the number 1
in column A2 and number 2 in A3 and simply drag the black corner of
the cell downward and it would automatically number them in increasing
order (3,4,5,6,7,etc) until I stopped dragging.

All of a sudden it wont do this anymore. Thoughts?

MANY thanks!