Home | Tips | Library | Other Authors | Other WP Sites | Writer's Links | Contact | Site Map | Donate

Barry MacDonnell's
Toolbox for WordPerfect

Macros, tips, and templates for Corel® WordPerfect® for Windows®
© Copyright 1996-2017 by Barry MacDonnell. All Rights Reserved.

Page updated Jun 8, 2015

Add incrementing numbers in a table column
with optional prefix and/or suffix characters

Download QWIKFILL.ZIP (v1.21; 04/16/07; 9835 bytes)

Compatible with WordPerfect 9 and later versions

WordPerfect 11 users: See important information about using macros in the first release of WP11 (11.0.0.233) at the top of this page.

Downloading, Documentation, Modifications, and Support

QwikFill.wcm is a WordPerfect 9 (and later version) macro that adds incrementing numbers (1..n) in the current table column from the current cell to the bottom of the column, in a manner similar to WordPerfect's QuickFill feature 1 -- but easier and with more options. [Screen shot of the macro's menu.]

You can add your own prefix and/or suffix characters to numbers, such as "#" and/or periods/full stops or other punctuation marks. Characters can include symbols (with Insert>Symbol or <Ctrl+W>).

You can also use fixed-width (Bates) numbers (i.e., numbers with leading zeros).

Any column in the table can be numbered, starting in any row. Simply place your cursor in the desired "beginning" cell and play the macro. (See "Known limitations" below.)

Examples

Plain numbering (like
WordPerfect's QuickFill

feature):
1    
2    
3    
Prefix added
to numbers:

#1    
#2    
#3    
Suffix added
(period/full stop):

1.    
2.    
3.    
Perfix and
suffix added:

(1)    
(2)    
(3)    
Bates ("fixed width") numbers:
[See also BATES in the Library.]

001    
002    
003    
Bates ("fixed width") numbers
with a prefix and a suffix:

#001:    
#002:    
#003:    

How it works

From the current table cell, this macro -

(1) deletes any existing items (cell contents and formulas) in the current column from the cursor location to the last cell in that column; then it

(2) adds incrementing numbers (1 .. n) in that column up to, and including, the last cell in that column.

Caution: Obviously, since the macro deletes any existing items in some cells, you should make a backup of your document first.

Modifications

See the redlined User Modifcation Area in the macro's code. (You can open the macro like any other WordPerfect document, make changes, and then click the Save & Compile button on the macro toolbar.)

Known limitations and caveats

(1) The column cells' Numeric Format must be set to General (the typical default) and not to Text.

(2) The macro language does not offer a way to detect if the cursor is in a header row of a table. (See Table>Format>Row for the header row setting in effect for the current row.) Be sure to start numbering in a non-header row.

Tip

Assign this macro to a menu, keystroke combination, or toolbar button. See here.




Footnote 1

WordPerfect has a QuickFill feature for tables, which can increment dates as well as numbers (Arabic and Roman).

It cannot, however, automatically add custom prefix and/or suffix text like the QwikFill macro can do.

From WordPerfect X6's Help (F1):

To fill a table with incremental numbers or dates

1.   Select the cells that contain the incremental or decremental pattern of values as well as the cells in which you want to continue the pattern.

2.   Click Table > QuickFill.

Note

You can use Roman numerals, days of the week, months, or quarters, even if only one cell is used to establish the pattern. To repeat incremental or decremental numbers, however, you must select at least two cells with values to establish a pattern. 

Tip

You can also fill a table with incrementing numbers or dates by clicking the QuickFill button on the Table formula toolbar. To display the Table formula toolbar, click Table > Formula toolbar.