Can I auto number a column of cells but?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I would like to autonumber the first column in a table. Every time you tab
to start a new row I would like the first cell to be autonumbered. However,
if the row is deleted I want the number to stay the same. I do not want it
to renumber upon a row delete. Is this possible? Thanks for the help.
bdunk
 
You can accomplish this in two steps. Apply autonumbers to the column. When
you have completed the table, before deleting rows, use the following macro
technique to convert the numbers to plain text:

1. Press Alt+F11 to open the VBA Editor.

2. Press Ctrl+G to open the Immediate window.

3. In that window, type:

ActiveDocument.ConvertNumbersToText

and press Enter.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Concatenate with line breaks but ignore blank cells 3
Auto re-numbering when a row is deleted 3
Linking Date formulas? 1
AutoNumber Field Broken: How To Fix? 9
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
auto numbering in a table 1
How Will I Number Each Columns in Word ? 2

Back
Top