Automatically number lines
 

There are many occasions when I would like to number the line items in
the far left column of the spreadsheet I am working on, so that the
numbers print (the spreadsheet is already numbered, but on the frame of
the page, not in a column that will print).

It would make sense to me that Excel has a feature that will
automatically number your entries when you provide the cells and give
the correct command. I haven't been able to figure out how to do that.


:) Thanks.


--
aletoconstco
------------------------------------------------------------------------
aletoconstco's Profile: http://www.excelforum.com/member.php...o&userid=35336
View this thread: http://www.excelforum.com/showthread...hreadid=551052

Automatically number lines
 

Hi,
I'm not sure if i inderstood your idea, but look at the formula above,
which i entered in cell A3:

=IF(B3="","",ROW())

If cell B3 is not empty, then the row number will appear in cell A3.

Hope it helps


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=551052

Automatically number lines
 

Hi, Aletoconstco,

try the tips on this web page

http://www.j-walk.com/ss/excel/usertips/tip035.htm

Hope this helps!
regards from Brazil
Marcelo

"aletoconstco" escreveu:


There are many occasions when I would like to number the line items in
the far left column of the spreadsheet I am working on, so that the
numbers print (the spreadsheet is already numbered, but on the frame of
the page, not in a column that will print).

It would make sense to me that Excel has a feature that will
automatically number your entries when you provide the cells and give
the correct command. I haven't been able to figure out how to do that.


:) Thanks.


--
aletoconstco
------------------------------------------------------------------------
aletoconstco's Profile: http://www.excelforum.com/member.php...o&userid=35336
View this thread: http://www.excelforum.com/showthread...hreadid=551052

Automatically number lines
 

Thank you very much for the information! I found it....... :)


--
aletoconstco
------------------------------------------------------------------------
aletoconstco's Profile: http://www.excelforum.com/member.php...o&userid=35336
View this thread: http://www.excelforum.com/showthread...hreadid=551052