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!

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!

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!