Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
How do I set up a way to add up the number of lines used when cal. | Excel Discussion (Misc queries) | |||
how do I put a a sequence number into colun A automatically witho. | Excel Discussion (Misc queries) | |||
How do I automatically pull a new invoice number into an excel te. | Excel Discussion (Misc queries) |