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-2012 by Barry MacDonnell. All Rights Reserved.

Page updated Sep 2, 2009
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 is a WordPerfect 9/10/11/12/X3/X4+ 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 -- but easier and with more options. [Screen shot or 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 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

With the cursor positioned inside a table:
From the current 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 the column; (2) it then adds incrementing numbers (1..n) in that column up to and including the last cell in the column.

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

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.