Shortcuts in Excel Add-in

image_pdfimage_print

Shortcut Ctrl + Delete

With Jedox Excel Add-in, you can use Ctrl + Delete 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.

Shortcut Ctrl + Shift + Q

As of Jedox version 7.0 SR1 the shortcut to rebuild views is Ctrl + Shift + Q. In former 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.

Shortcut to activate / deactivate an array function

To activate an array function press Ctrl + Shift + Enter.    
To deactivate an array function press Ctrl + Enter.

Shortcuts for entering splash data

With Jedox Excel Add-in, you can use k (thousand) and m (million) to enter splash data. For example, #5k (or #5K) will splash 5000, while #17M will splash 17,000,000.

Shortcuts for Splashing Wizard

In Excel Add-in, you can use shortcuts to open the Splashing Wizard to a particular option by selecting a Jedox cell (or range of cells) with a PALO.DATA, PALO.DATAC, or a PALO.DATAX function. The table below shows the shortcuts with a description of their behavior:

# + Enter Opens Splashing Wizard on “Generic Splashing” page with preselected option “Default”.
## + Enter Opens Splashing Wizard on “Generic Splashing” page with preselected option “Add”.
! + Enter Opens Splashing Wizard on “Generic Splashing” page with preselected option “Set value to base cells”.
!! + Enter Opens Splashing Wizard on “Generic Splashing” page with preselected option “Add value to base cells”.
“Copy” + Enter Opens Splashing Wizard on “Copy/Like/Predict” page with preselected option “Copy”.
“Predict” + Enter Opens Splashing Wizard on “Copy/Like/Predict” page with preselected option “Predict linear regression”.
Value + Space + “Like” + Enter Opens Splashing Wizard on “Copy/Like/Predict” page with preselected option “Absolute” and sets value for absolute value or if value is containing ‘%’ then pre-select “Percentage” and set value for percentage value.
? + Enter Opens Splashing Wizard on “Goalseek” page.
image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...