• About cells
• Block Renumber dialog
• Calculation Explorer
• Calculation Reference Dialog
• Using The Cell Picker Dialog
• Cell Renumber dialog
• Cell Validation
• Clipboard Cell Conflict dialog
• Creating a Response and Assigning an Action for Invalid Input
• Creating A Validation Rule
• Modify Group Tab dialog
• Recalculate Error dialog
• Recalculation Error dialog
• Renumber Sum Group dialog
• Set Cell Group dialog
• Set Sum Group dialog

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.