<< 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)
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. |