Drag cells autonumber feature went bye bye?!?!?
 

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!

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!

Drag cells autonumber feature went bye bye?!?!?
 

ToolsOptionsEdit "allow cell drag and drop"


Gord Dibben MS Excel MVP

On 16 Feb 2007 08:19:02 -0800, 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!