Auto numbering stop

andem · Mar 28th, 2002, 02:41 PM

I have an Excel document with over 960 items. In a column I used for numbering the items, each time a group of items was added I was pulling down from the corner to auto-number. When I reached 958 suddenly I was no longer able to do this. When I place the cursor over the lower right corner of the cell now it does not change to a cross. Also I am no longer able to change the print area by dragging down the dark blue line at the bottom of the previously set print area.
I'm sure there must be a simple explanation for this but I haven't been able to find it.
Thanks for any help.
(BTW- I just found your site and can't wait until I have some time to sift through the archives. I couldn't find a way to search for references to this particular question though.)
Andem

Juan Pablo González · Mar 28th, 2002, 02:44 PM

I'd suggest, instead of filling out everything again, just use this formula from A2 and below. That way you can just drag the last one everytime you add something.

=A1+1

Juan Pablo González · Mar 28th, 2002, 02:44 PM

BTW, couldn't replicate your problem... may be a memory issue then ?

andem · Mar 28th, 2002, 02:56 PM

Thanks guys for the quick response. The work around sounds great to me as the idea of plugging in each number was not a thrill.

As for the question of memory- I don't know really. I have 512 MB of memory in this machine which should take care of it; however, I recently switched to Windows XP and have had problems several times with Photoshop that seemed to relate to memory. It was saying it didn't have enough scratch disk space (absurd since it had over 20G clear) but shouldn't have even had to go to the scratch disk if it had been using the memory properly. Maybe???? I seem to be a record holder when it comes to generating computer problems.

Mar 28th, 2002, 02:44 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	I'd suggest, instead of filling out everything again, just use this formula from A2 and below. That way you can just drag the last one everytime you add something. =A1+1 __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 28th, 2002, 02:44 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	BTW, couldn't replicate your problem... may be a memory issue then ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 02:41 PM	#1
andem New Member Join Date: Mar 2002 Posts: 2	I have an Excel document with over 960 items. In a column I used for numbering the items, each time a group of items was added I was pulling down from the corner to auto-number. When I reached 958 suddenly I was no longer able to do this. When I place the cursor over the lower right corner of the cell now it does not change to a cross. Also I am no longer able to change the print area by dragging down the dark blue line at the bottom of the previously set print area. I'm sure there must be a simple explanation for this but I haven't been able to find it. Thanks for any help. (BTW- I just found your site and can't wait until I have some time to sift through the archives. I couldn't find a way to search for references to this particular question though.) Andem

Mar 28th, 2002, 02:56 PM	#4
andem New Member Join Date: Mar 2002 Posts: 2	Thanks guys for the quick response. The work around sounds great to me as the idea of plugging in each number was not a thrill. As for the question of memory- I don't know really. I have 512 MB of memory in this machine which should take care of it; however, I recently switched to Windows XP and have had problems several times with Photoshop that seemed to relate to memory. It was saying it didn't have enough scratch disk space (absurd since it had over 20G clear) but shouldn't have even had to go to the scratch disk if it had been using the memory properly. Maybe???? I seem to be a record holder when it comes to generating computer problems.