software

I was shown once, but I can't remember how it was done. I have a list of 5000
things and I need to number then 1-5000, but don't want to go through all
5000. I have seen it done where you type the first few like 1-7 and then use
a shortcut and drag it down the rest of the list and the numbers will
populate. Please help!


You can try something like this:

=IF(B1=quot;quot;,quot;quot;,COUNTA($B$1:B1)
copy down....or if there are no gabs in your list simply double click
on the lower right corner of the cell.

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497944I think you might be referring to Edit | Fill. Type your first entry
(1) in the first cell of a blank column. Highlight that cell down to
5000. Select Edit | Fill | Series, and you will need Linear with a Step
Value of 1. Click OK and your rows will be numbered.

You could also use the formula =ROW() and copy down, then fix the
values with lt;copygt; Edit | Paste Special | Values | OK then lt;escgt; or
lt;entergt;.

Hope this helps

PeteYAY!!!
thats what it was, drag the little box in the bottom right corner!!
THANKS!quot;pinmasterquot; wrote:

gt;
gt; You can try something like this:
gt;
gt; =IF(B1=quot;quot;,quot;quot;,COUNTA($B$1:B1)
gt; copy down....or if there are no gabs in your list simply double click
gt; on the lower right corner of the cell.
gt;
gt; HTH
gt; JG
gt;
gt;
gt; --
gt; pinmaster
gt; ------------------------------------------------------------------------
gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; View this thread: www.excelforum.com/showthread...hreadid=497944
gt;
gt;