Hello forum Mr Lomax wrote: When I start, I insert a field, put 1 into the first record (say that is cell A1), put =A1+1 into the next record and fill down. Then I select that field entirely (all records) and Copy. Then I Paste Special/Values. I've now numbered all the records. (Again, there is likely a faster way....)
Yes there is, Put 1 in cell A1, put 2 in cell A2, select both cells and then use the small square in the right bottom corner to drag it as far as you wish. See the Excel help 'Fill in a series of numbers, dates, or other items' for more options. I don't know about a simpe 'Select cells and collapse into one cell' option. Anybody else? ============================== Aalt Lokhorst Schut Geometrische Meettechniek bv Duinkerkenstraat 21 9723 BN Groningen P.O. Box 5225 9700 GE Groningen The Netherlands Tel: +31-50-5877877 Fax: +31-50-5877899 E-mail: [EMAIL PROTECTED] ============================== * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
