Automatically number lines

  • Thread starter Thread starter aletoconstco
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automatically set print area in Excel template? 5
putting number against certain words formula 0
Excel Numbering rows by font color, but skipping blanks 1
Automatic sequential numbering where a value changes 4
when I enter a number, only ###### shows? 3
Automatic Numbering 1
vlook up where one column has a range of numbers 1
Lookup Function? Employee Number with Employee Name 1

Back
Top