Automatically number lines

A

aletoconstco

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

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


:) Thanks
 
O

oteixeira

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 help
 
Top