Jumping to specific elements of a table

<< Click to Display Table of Contents >>

Jumping to specific elements of a table

Use the three buttons in the lower right corner of the document window to jump to a specific content of a table (for example, to the next cell with an error value or a comment)

goto_scrollbar

You use these buttons as follows:

If you click on the button with the red dot, a small menu will appear. Then select the type of Go to operation you want to perform from the menu (see below).

If you click on the button with the up arrow, PlanMaker will jump to the previous position. If, for example, you selected "Error value" in the menu, the previous cell with an error value will be displayed.

If you click on the button with the down arrow, PlanMaker will jump to the next position, for example, to the next cell with an error value.

You can therefore determine what to search for by using the menu that opens after clicking on the red dot. The menu has the following items:

Menu item

Explanation

Formula

Jump to cells that contain a formula

Array formula

Jump to cells that contain an array formula

Constant

Jump to cells that contain a fixed value

Error value

Jump to cells that contain an error value (see the section Error values)

Faulty cell

Jump to cells that have been imported incorrectly – for example, cells using an Excel arithmetic function that PlanMaker doesn't support.

Comment

Jump to cells that contain a comment

Conditional formatting

Jump to cells that use conditional formatting

Input validation

Jump to cells that use input validation

Search all worksheets

If this option is enabled, PlanMaker searches all worksheets instead of just the current one.