At 09:58 29.10.2003 +0100, you wrote:
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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Reply via email to