Formula jumping

Ctrl + Shift + J Jump to first precedent
Ctrl + Shift + K Jump back to original cell

Quickly navigate between the first precedent of a selected formula and the original cell. The first precedent is the first cell that the formula references to and is dependent on. This feature is useful for quickly navigating through formulas to understand dependencies and relationships between cells.

Exact copy paste formulas

Alt > X T C E Copy exact
Alt > X T P E Paste exact

Copy and paste formulas exactly as they are composed in the original cell, treating all relative references as absolute.

While building a model, if you would like to reuse formulas while keeping the references intact, you would use absolute references as indicated by the dollar sign prefix.
However, during development, the use of relative references may significantly speed up the development process as the user can extrapolate formulas to the whole range without much effort.

This feature allows the user to use both absolute and relative references while building the calculations, but still copy the whole formula range as if all references were absolute.

Quickly enable / disable formulas

Alt > X T F D Formula disable
Alt > X T F E Formula enable

Quickly disable and enable formulas in a selected range. While building a model, it can be useful to disable formulas you don't need anymore, but which you don't want to delete yet in case you would need them later. In case of circular references or resource-intensive formulas, it can be useful to temporarily disable some formulas during development.

Formula Disable will attach a prefix apostrophe to each of the in the selected range, thereby rendering them inactive.
Formula Enable will remove the apostrophe prefix if present, thereby rendering the formulas active again.

Apply check format

Alt > X T D A Apply check format

Apply conditional formatting for model checks to a selected range.

Good quality checks are an indispensable part of any model. They allow users to quickly identify errors and inconsistencies in the calculations. This function applies conditional formatting to a selected range, highlighting cells that significantly deviate from zero in red, while all other cells are formatted in green.

The default treshold bounds are set at -0.01 and +0.01 (symmetrical bounds), which means that any cell with a value below -0.01 or above 0.01 will be highlighted in red. These bounds can be adjusted to any value by the user (see sensitivity control function below).

Add checks summary

Alt > X T D S Summarize checks

Summarize the results of all checks on the active sheet in the active cell, to quickly identify whether a sheet contains any errors or inconsistencies as flagged by check cells.

All cells that contain the conditional formatting for check cells applied by this addin will be included. The maximum error (deviation from zero) will be shown in the summary cell.

To prevent performance issues, this function will not work on sheets with a large number of formulas or a large number of checks.

Add check sensitivity control

Alt > X T D C Add sensitivity control

Add a cell to control the sensitivity of the check format applied by this addin.

The default treshold bounds applied in the conditional formatting for the checks are set at -0.01 and +0.01. This treshold can be adjusted by the user. This function will add a named range to the workbook referencing the active cell, which will be used to control the treshold bounds.

Only one sensitivity control can be added per workbook.

Change case

Alt > X T U C UPPERCASE
Alt > X T L C lowercase
Alt > X T S C Sentence case
Alt > X T C C Capitalized Case

Change the case of the text in the selected range to uppercase, lowercase, sentence case or capitalized case. This will only affect the text in cells with values. Cells containing formulas will not be affected.

Delete empty rows

Alt > X T D E Delete empty rows

Swiftly remove all empty rows in a selected range. Only cells in the selected range will be affected. All cells below the selected range will be shifted up in case some rows in the selected range are empty.

Reverse order

Alt > X T F V Flip vertical
Alt > X T F H Flip horizontal

Reverse the order of the rows (flip vertical) or columns (flip horizontal) in a selected range.

This function will only work on contiguous ranges that do not contain any formulas (to prevent unexpected results).

Color alternating rows

Alt > X T A C Color alternating rows

Quickly color alternating rows in a selected range in steel blue and light steel blue to improve readability.

Remove worksheet protection

Alt > X T W P Unprotect functions - XML

Remove all worksheet-level protection for the selected workbook.

Excel workbooks that can be viewed by others but are protected from editing do not involve encryption and are therefore easily circumvented. This function will remove all worksheet-level protection from the selected workbook. All passwords will be removed.

Make sure the workbook is closed before applying this function (from another excel instance / workbook).

Note: Workbooks that require a password to be opened typically do involve encryption and won't be unlocked by this function. The only way to circumvent this protection method is to bruteforce the password. RX Tools does not support this at this time, as bruteforcing typically takes a long time and its outcome is unreliable. This may change in the future.

Unprotect VBA

Alt > X T W P Unprotect functions - VBA

Circumvent VBA protection, enabling the user to view all VBA code of the opened workbooks.
Excel workbooks, especially those with an .xlsm extension, can contain VBA code that is protected from viewing or editing. This function will circumvent Excel's VBA protection, enabling the user to view and edit the VBA code, or remove and / or change the password protection.

Note: This function does not remove the VBA password protection, but merely circumvents it. Restarting excel will lock the VBA code again. To prevent this, the user can use this function to unlock the VBA code and then change or remove the password in the VBA editor.

Unhide hidden names

Alt > X T W N Uncover hidden names

Uncover all hidden names in the selected workbook, making the visible to the user through the name manager.

Excel workbooks often contain hidden names, which are not visible to the user through the name manager. These names are often remnants of previous workbooks from which sheets or ranges were copied.

A large number of hidden names can significantly slow down the performance of the workbook. Typically, hidden names can only be removed or edited using VBA code.

This function will uncover all hidden names, making them visible to the user through the name manager so they can be removed. Uncovered names can be recognized in the name manager by the prefix added by RX Tools in the comment section.

Remove macro's

Alt > X T W M Remove all macros

Remove all macros from the active workbook, including VBA modules, VBA forms and sheet-level VBA code.

This function will only work on workbooks that do not have their VBA project protected by a password. In case password protection is in place, make sure to disable it before applying this function using the RX Tools VBA Unprotect function.

Note: It is not sufficient to enable VBA password circumvention using the RX Tools function. The VBA project will only be unlocked once the user opens the VBA editor and opens the VBA project manually first.

Count external references

Alt > X T W R External references - Count

Review the active workbook for external references and compile a detailed report.

In addition to cell formulas, external references can also be found in charts, pivot tables, named ranges, data validation and shapes. Often, they are artifacts from previous workbooks from which sheets or ranges were copied. As they may be hard to find and can result in unexpected behavior, performance issues and frustrating popups, we provide a function to do a thorough scan of the active workbook.

Dependending on the size of the workbook and the user's search criteria, this function may take a while to complete. we have tried to optimize the performance as much as possible.

Remove external references

Alt > X T W R External references - Delete

Delete all external references from the active workbook.

The user can indicate where to search for external references and what method to use to delete them. Depending on the settings and the size of the workbook, this function may take a while to complete.

When encountering an external reference in a workbook, the ideal approach would be to replace the reference by the latest cached value of that reference. However, for some categories this could increase execution time significantly and would require complex functionality that exceeds the scope of this free addin. We could offer this in a paid version in the future.

Depending on the category (chart, pivotTable, named range, data validation, shape or cell formula), we offer to replace remove the entire formula or to replace the formula by it's cached value (sheets and names only).

Save snapshot

Alt > X T W S Save snapshot

Quickly save a snapshot of the current workbook as a separate file.

Hide and show gridlines

Alt > X T G H Hide all gridlines
Alt > X T G S Show all gridlines

Hide and show all gridlines in the active workbook (all the sheets).

Hide and show sheets

Alt > X T F S Focus sheets
Alt > X T U A Unhide all sheets

Focus sheets will hide all but the selected sheets. Unhide all sheets will show all sheets again. This function is useful when working on formulas that reference multiple sheets. Hiding all non-relevant sheets will prevent the user from having to navigate unnecessarily through the sheets.

Another use case is when presenting the workbook to a stakeholder. Hiding all sheets except the relevant ones prevents distraction, confusion or unwanted interaction with other sheets.

Change scroll area on sheet

Alt > X T V S Selected range
Alt > X T V U Used range
Alt > X T V W Whole sheet

Hides all columns and rows outside the working area, making the sheet more readable and prevents jumps to the end of the sheet when navigating cells and formulas.

Selected range hides all columns and rows outside the selected range.
Used range hides all columns and rows outside the used range.
Whole sheet hides all columns and rows outside the whole sheet.

Note: The used range is the range that contains data or formulas. The used range is managed by excel and can sometimes include cells that seem to be empty. Saving the workbook usually resets the used range.

Close duplicate windows

Alt > X T C D Close duplicate windows

Close all duplicate windows of the active workbook.

This function will close all duplicate windows of the active workbook, retaining only the active window. Duplicate windows are very useful when working on a model, but nobody likes to open a workbook that was saved with multiple windows open.