Jumping to specific cell addresses

<< Click to Display Table of Contents >>

Jumping to specific cell addresses

The command Home | Go to goto_icon (in the group Search) is used to set the cell frame to a specific cell in the table.

The program displays a dialog box in which you can enter the desired cell address. Both an individual cell address (for example, D2) and a cell range (for example, D2:D4) are permitted.

In the list below the input field, all areas of the table named with the ribbon command Formula | Named area | Edit names are still listed so that they can also be accessed immediately.

If you confirm with OK, PlanMaker will immediately select the corresponding cell or cell range.

Tip: A faster method

There is also a faster method: In the Edit toolbar (above the table window), there is a dropdown list on the left, which usually shows in which cell the cell frame is currently located.

range_list_sample

Here, you can enter the address of a cell or cell range – just like in the dialog box of the command Home | Go to. When you press the Enter key, PlanMaker highlights the corresponding cell(s).

In addition: If you click on the small arrow to the right of the list, it will open and display all named ranges for selection. If you click on a name, the corresponding cell range will be immediately selected.