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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Reply via email to