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.
Even faster: Put 1 in cell A1, drag the small square and press the ctrl-key.
Edi
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] ==============================
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + IH electronic + Phone: ++41 52 320 90 00 + + Edi Im Hof + Fax: ++41 52 320 90 04 + + Doernlerstrasse 1, Sulz + URL: http://www.ihe.ch + + CH-8544 Rickenbach-Attikon + E-Mail: [EMAIL PROTECTED] + + Switzerland + + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
