Sequentially number lines automatically

S

Steevee

Version: v.X Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How can automatically number the lines as I enter data.

so box A1 would automatically be 1
and the next time I created an entry on another line that line would be 2, etc.

The reason is so that I can sort, delete and the numbers will remain, so I can also go back to the order than things were entered into.

Could do this manually, but a pain.

Or could possibly do this with a date and time?

Thanks Steevee
 
J

John_McGhie_[MVP]

See the Excel help topic "Enter a series of numbers, dates, or other items"

Enter "1" in the first cell and fill down as many rows as you like.

Cheers

Version: v.X Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How
can automatically number the lines as I enter data.

so box A1 would automatically be 1
and the next time I created an entry on another line that line would be 2,
etc.

The reason is so that I can sort, delete and the numbers will remain, so I can
also go back to the order than things were entered into.

Could do this manually, but a pain.

Or could possibly do this with a date and time?

Thanks Steevee

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

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

Top