At 04:51 AM 10/29/2003, Edi Im Hof wrote:
At 09:58 29.10.2003 +0100, [Aalt Lokhorst] wrote:
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.

As described, it does only a fill down. But if you press and hold the ctrl key *before* dragging the square, it does an increment as desired.... to be exact, highlight cell A1, place the cursor on the small square in the right bottom corner -- the cursor should change to a dark cross (at least in Excel 97) -- then press and hold the ctrl key, a "+" appears to the right of the cursor, apparently indicating that dragging will increment, and then drag down will increment. Drag up decrements.


The device of creating a sortable record number (i.e., row number in Excel) is useful in many situations. For example, when manipulating Protel Spreadsheet data in Excel, it may be desireable to be able to paste the data back into the Spreadsheet with the original record order. By creating the record number, it then becomes possible to sort the data in various ways and then, when done, recover the original record sequence.



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