Mac Works: How to Increment Numbers in Spreadsheet and
  
PSS ID Number: Q135775
Article last modified on 10-22-1998
 
2.x 3.x 4.0 4.0a 4.0b
 
MACINTOSH
 

======================================================================
 
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 2.x, 3.x, 4.0, 4.0a,
   and 4.0b
----------------------------------------------------------------------
 
SUMMARY
=======
 
This article explains how to create columns of incrementing
numbers in both the Spreadsheet and the Database portions
of Works.
 
MORE INFORMATION
================
 
Making an Incremental Number List in the Spreadsheet
----------------------------------------------------
 
To make a column of incremental numbers in the Spreadsheet, do the
following:
 
1. Click cell A1.
 
2. Type in the number "1" (without the quotation marks), and press RETURN.
 
3. Click cell A2.
 
4. Type the formula "=A1+1" (without the quotation marks), and press
   RETURN.
 
5. Select cell A2 and extend the highlight to include the cells below cell
   A2.
 
6. On the Edit menu, click Fill Down.
 
This creates a list of numbers starting at 1 and increasing in increments
of 1. To change the number where the list starts, change the number entered
into cell A1. To change the increment amount, change the formula in cell
A2.
 
Making an Increment Number List in the Works 4.0 Database
---------------------------------------------------------
 
NOTE: These instructions apply only to the Works 4.0 Database. To create
an incremental number list in versions 2.x and 3.x, follow the instructions
in the Making an Increment Number List in the Spreadsheet. Then, paste the
spreadsheet information into a new database field.
 
To increment numbers in the Database, do the following:
 
1. On the View menu, click List View.
 
2. On the Insert menu, click Insert Field.
 
3. In the Type section of the New Field Dialog Box, click Serialized.
 
4. In the Appearance section, type the prefix, number, and suffix
   you want.
 
5. In the Increment By box, change the increment to the value you want to
   use.
 
6. Click OK.
 
A serialized field is created. Lines are added automatically to the
serialized field as you enter new records into your database.
 
For more help on creating serialized fields in a database,
see page 224 of the Works 4.0 manual.
 
KBCategory: kbusage kbhowto
KBSubcategory: macworkskb
 
Additional reference words: kbhowto 2.00 3.00 4.00 4.00a 4.00b 3.00a 2.00a
mac m_works mwksdb mwksss
======================================================================
Version           : 2.x 3.x 4.0 4.0a 4.0b
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.
