Keyboard Shortcuts

Jedox offers a variety of shortcuts that enhance productivity and efficiency. Below you will find keyboard shortcuts for the Jedox Platform and the Jedox Excel Add-ins.

Jedox Platform Shortcuts

To do this Press Further Explanations
Jump to the next input component Tab None
Jump a cell back Tab + Shift None
Move up ↑ None
Move down ↓ None
Open folder → None
Close folder ← None
Write the value "0" (zero) Ctrl + Delete In a numeric cell with a PALO.DATA formula, writes 0 without deleting the existing formula.
Note that in consolidated numeric cells, the whole cube slice will be cleared. In the Reports mode, simply press the Delete key.
Write an empty string Ctrl + Delete In a string cell with a PALO.DATA formula, write an empty string without deleting the existing formula.
Deactivate an array function Ctrl + Enter Deactivate an array function by selecting the whole function array and using this shortcut in the formula bar at the end of the function.
Activate an array function Ctrl + Shift + Enter Activate an array function by selecting the whole function array and using this shortcut in the formula bar at the end of the function.
Add a value to various, noncontinuous cells
Ctrl + Selected cells Select one cell, then hold the Ctrl key and select additional cells. Once the cells have been selected, enter the value and press Enter . The value will then be applied to all the selected cells. You can also use input via a data validation list or the copy command.
Note that it is not necessary to press Ctrl + Enter, as it is with Microsoft Excel.
Rebuild a Jedox View Ctrl + Q None
Cancel changes to a formula Esc This is the same as clicking the X button on the toolbar.
Navigate up and down Page Up / Page Down In Jedox Spreadsheets
Close the current cell Shift + Enter Closes the current cell if input mode is active and selects only the one above it.
Close the current cell Shift + Tab Closes the current cell if input mode is active and selects only the one on its left.
To do this Press Further Explanations
Jump to cell to the right → None
Jump to cell to the left ← None
Jump to cell below ↓ None
Jump to cell above ↑ None
Jump to cell to the right Tab None
Jump a cell back Tab + Shift None
Jump to cell below Enter None
Insert a line break
Alt + Enter Inserts a line break when entering cell content in Jedox Spreadsheets. For Internet Explorer use Ctrl + Alt + Enter
Additionally select cells to the right →+ Shift None
Additionally select cells to the left ← + Shift None
Additionally select cells below ↓ + Shift None
Additionally select cells above ↑ + Shift None
Confirm input and jump to the cell below Type value + Enter None
Confirm input and jump to the next cell to the right Type value + → None
Select cell with an empty value Spacebar None
Insert a line break within the cell Alt + Shift None
Copy value Ctrl + C Windows
Paste Value Ctrl + V Windows
Copy value ⌘+C macOS Only works when the content of the cell is selected
Paste Value ⌘+V macOS Only works when the content of the cell is selected
Open the Macro editor Alt + F11 Windows
Open the Macro editor ⌥ +F11 macOS
Change the type of a cell reference F4 (Adds or removes the $ character)
It works after you have selected a part of the formula that is either a cell reference (e.g. A1) or a range reference (e.g. A1:A4)
Evaluate expressions in formulas or parts of formulas F9 None
To do this Press Further Explanations
Jump to cell in the next Combobox Tab None
Confirm the input Enter None
Open the Dropdown list Spacebar or ↓ None
To do this Press Further Explanations
Expand / collapse row or column Spacebar None
Note: when you use tabs and arrow keys to navigate between unlocked cells in Reports or in the User Mode of the Designer, the behavior can be inconsistent if you navigate to unlocked cells positioned outside of the viewport.
To do this Press Further Explanations
Opens the contextual page on the Knowledge Base website F1 None

Integrator Component Form Shortcuts
Jump to the next input component Tab None
Jump a cell back Tab + Shift None

Integrator Component Overview Shortcuts
Jumps from one element to the next element Tab E.g. Table header
Jumps to the next item → E.g. Table column header
Open the context menu ↓ None

You can use shortcuts when working in the element grid in the Jedox Modeler. Most Modeler shortcuts depend on the context, i.e., the current selection in the elements grid. Note that the shortcuts below apply to the “tree” view of the elements grid. Some of the shortcuts are not applicable to the “flat” view.

To do this Selection Press Further Explanations
Trigger deletion of the selected element Full row Delete Using this shortcut triggers a confirmation prompt.
Insert a new element row (i.e., allow creation of new element.) Full row (a collapsed consolidated or base element) Enter+ The row is inserted at the same level as the selected element, and the same parent (if any) is preselected for it.

Insert a new element row (i.e., allow creation of new element.)

 

 Full row (an expanded consolidated element) Enter+ The row is inserted as the last child of the selected element.
Change selection from full row to element name field Full row → None
Select the previous / next row Full row ↑ / ↓ None
Select the first / last row (on current page if paging is active) Full row PAGE UP
PAGE DOWN		 None
Trigger deletion of all selected elements Multiple rows Delete Using this shortcut triggers a confirmation prompt.
Insert a new element row (i.e., allow creation of new element.) Multiple rows Enter+ The row is inserted after the first selected element.
Trigger deletion of the selected element Element Name field Delete Using this shortcut triggers a confirmation prompt.
Insert a new element row (i.e., allow creation of new element.) Element Name field Enter+ The row is inserted at the same level as the previous element, and the same parent (if any) is preselected.
Open input field to rename element Element Name field F2 None
Expand the consolidated element Element Name field (a collapsed consolidated element) Ctrl + → None
Collapse the consolidated element Element Name field (an expanded consolidated element) Ctrl + ← None
Select the element name field in first / last row Element Name field PAGE UP
PAGE DOWN		 None
Add the element name fields above / below the currently selected field to selection Element Name field Shift + ↑
Shift + ↓		 None
Add the name fields from the currently selected field to the first / last name field (on current page) to selection. Element Name field Shift + PAGE UP
Shift + PAGE DOWN		 None
Select the full row Element Name field ← None
Select the Element Type field Element Name field → None
Start input of the element name (use ESC to cancel) Element Name field ALPHANUMERIC KEY None
Trigger deletion of the selected element Element Type field Delete Using this shortcut triggers a confirmation prompt.
Insert a new element row (i.e., allow creation of new element.) Element Type field Enter+ The row is inserted at the same level as the previous element, and the same parent (if any) is preselected.
Open the type Combobox for changing the element type Element Type field F2 None
Trigger change of the element type to “numeric” (if current type is “string”) Element Type field N Using this shortcut triggers a confirmation prompt.
Trigger change of the element type to “string” (if current type is “numeric”) Element Type field S Using this shortcut triggers a confirmation prompt.
Add the element type fields above / below the currently selected field to selection Element Type field Shift + ↑
Shift + ↓		 None
Add the type field from the currently selected field to the first / last name field (on current page) to selection Element Type field Shift + PAGE UP
Shift + PAGE DOWN		 None
Open the type Combobox to change the element’s type. Selected type will be set (after confirmation) for all selected elements Multiple Element Type fields F2 None
Change all selected elements to type “numeric” Multiple Element Type fields N Using this shortcut triggers a confirmation prompt.
Change all selected elements to type “string” Multiple Element Type fields S Using this shortcut triggers a confirmation prompt.
Remove the parent-child relation Parent field Delete Other parent-child relations for the current element remain intact.
Insert a new element row (i.e., allow creation of new element) Parent field Enter+ The row is inserted at the same level as the previous element, and the same parent (if any) is preselected.
Open the parent Combobox for changing the element’s parent Parent field F2 Other parent-child relations for the current element are not modified.
Remove the parent-child relation for all selected elements Multiple Parent fields Delete Other parent-child relations for the elements remain intact.
Open the parent Combobox to change the parent of all selected elements Multiple Parent fields F2 Other parent-child relations for the current element are not modified.
Insert a new element row (i.e. allow creation of new element) Element Weight field Enter+ The row is inserted at the same level as the previous element, and the same parent (if any) is preselected.
Open the input field for setting the weight (consolidation factor) of the element for the parent in selected row Element Weight field F2 None
Open the input field for setting the weight (consolidation factor) of all selected elements for the parents in selected rows Multiple Element Weight fields F2 None
Trigger deletion of the attribute value Attribute field Delete Using this shortcut triggers a confirmation prompt.
Insert a new element row (i.e., allow creation of new element) Attribute field Enter+ The row is inserted at the same level as the previous element, and the same parent (if any) is preselected.
Open the input field for setting the attribute value Attribute field F2 None
Start input of the attribute value Attribute field ALPHANUMERIC KEY Use ESC to cancel.
Trigger deletion of the attribute values Multiple Attribute fields Delete Using this shortcut triggers a confirmation prompt.
Open the input field for setting the attribute value Multiple Attribute fields F2 The entered value will be set on all selected elements.
Start input of the attribute value Multiple Attribute fields ALPHANUMERIC KEY Use ESC to cancel.
The entered value will be set on all selected elements.
Add a new row to create a new element

-

 Enter or + None
Open the currently selected field for editing - F2 None
Stop editing the current field and revert the changes - Esc None
Move the selection focus - ←↑↓→ None
Select the current row - Home None
Open the search input field - Ctrl + F None

 

Jedox Excel Add-ins Shortcuts

To do this Press Further Explanations
Clear cell content Ctrl + Delete You can use this shortcut in one cell or in a cell range with PALO.DATA functions to write the value "0" in the corresponding numeric cube cell(s) or an empty string in the corresponding string cube cell(s) without deleting PALO.DATA functions. The benefit of this shortcut (in comparison to splashing 0) is to write "0" or "empty string" in multiple Jedox OLAP cells.
Rebuild Views Ctrl + Shift + Q This shortcut applies as of Jedox version 7.0 SR1. In previous versions, the shortcut to rebuild Views was Ctrl + Q. This change was necessary because Microsoft Excel uses Ctrl + Q to display quick analysis options for selected cells.
Activate an array function Ctrl + Shift + Enter None
Deactivate an array function Ctrl + Enter None
To do this Windows Desktop & Browser macOS Desktop macOS Browser Further Explanations

General
Clear cell content Ctrl + Shift + Backspace Cmd + Shift + Backspace Ctrl + Shift + Backspace To replace a static View cell or a cell with a PALO.DATA formula with the value "0" (zero) in a numeric cell, or an empty string within a string cell, without deleting the existing formula.

Note that on consolidated numeric cells, the whole cube slice will be cleared.
Update Sheet Ctrl + Shift + F9 Cmd + Shift + F9 Ctrl + Shift + F9 To update both the static View and all PALO functions within the active spreadsheet.
Update Workbook Ctrl + Shift + F10 Cmd + Shift + F10 Ctrl + Shift + F10 To update both the static View and all PALO functions within the entire workbook.
Expand / collapse selected cell Alt + Shift + E Alt + Shift + E Alt + Shift + E None

Edit View
Select all Ctrl + A Cmd + A Cmd + A None
Expand / collapse the selected parent element ← / → ← / → ← / → None
Select / unselect the focus element Spacebar / Enter Spacebar / Enter Spacebar / Enter None
Move focus to the next element ↑ / ↓ ↑ / ↓ ↑ / ↓ None
Expands all collapsed dimensions of the same level * * * None

Planning Assistant Actions

To do this Press Further Explanations
Enter splash data k (thousand), m (million), g (billion) For example, #5k (or #5K) will splash 5,000, #17m will splash 17,000,000, and 2g will splash 2,000,000,000
Splashing, with Default option selected # + Enter None
Splashing, with Add value to cell option selected ## + Enter None
Splashing, with Set value to base cells option selected ! + Enter None
Splashing, with Add value to base cells option selected !! + Enter None
Copy "Copy" + Enter None
Like, with Absolute option selected <value> + space + "Like" + Enter None
Like, with Percentage option selected <value>% + space + "Like" + Enter None
Linear Regression "Predict" + Enter None
Reallocate ? + Enter None

See Planning Assistant for more information.

 

Updated September 27, 2024