Cell Renumber Dialog
Renumbers the active cell. Each cell number has a maximum length of 10 characters and must have an alphanumeric prefix. The rest of the cell number may be a combination of letters and numbers.
To access the Cell Renumber dialog, right-click a cell and select Renumber Cell.
New cell number
If desired, enter a new number for the cell.
Renumber Options
Enter variables to control how the cell is renumbered.
Renumber all cells
Renumbers all cells with the same number.
Rereference calculations
Updates calculations that are dependant on the old cell number to the new one. For example, if a cell has the calculation c80 that returns the value of cell number c80 and cell number c80 is renumbered to c81, choose to replace calculations using c80 with c81 by selecting Reference calculations. The calculation in the cell being renumbered always remains intact. Only cells using this cell number in their calculations are affected.
Enabling this option also renumbers references in events and right-click menus.
Cell exists. Maintain original attributes
Maintains the same attributes as the existing cell.
Cell exists. Maintain original calculation
Maintains the same calculation as the existing cell.
Cell exists. Maintain original data
Maintains the same data as the existing cell.
Rereference Diagnostics
Updates any diagnostic conditions using the original cell number to the new cell number.
Rereference hide/skip conditions and objects
Use these options to maintain the existing cell number or to update skip criteria, section formatting, and graphs to the new cell number.
Rereference all hide/skip conditions and graphs to new cell number
Updates skipping criteria, section formatting, and cell linkage to graphs from the original cell number to the new cell number.
Do not rereference any hide/skip conditions and graphs
Maintains the original cell number used in skipping criteria and cell linkage in graphs.
Rereference hide/skip conditions and graphs only in current paragraph
Rereferences skip or hide conditions in the current paragraph containing the cell. Skip or hide conditions and cell linkage for graphs using the current paragraph will be renumbered to the new cell number.