Quick Tools

Estimated reading time: 5 minutes

Overview

The Quick Tools window provides a convenient set of macro tools suggested by our users.


These tools are efficient ways to complete the most common actions in Interject.

Note: The Quick Tools are actions and cannot be undone with the Excel Undo feature (Ctrl-Z). Be sure to save your work beforehand.



Quick Tools

Type Tool Description  
Pane Freeze/Unfreeze Panes Unfreezes or freezes the current sheet panes using jFreezePanes() settings  
Pane Freeze all Tabs Unfreezes or freezes all sheet panes using jFreezePanes() settings  
Format Center Across Columns Centers across columns without merging cells for the selected cells  
Format Remove Wrap Removes the word wrap formatting for the selected cells  
Format Inverse Sign Reverses the sign of any numeric amount for the selected cells  
Format To Lower Case Converts text to 'lower case' for the selected cells  
Format To Proper Case Converts text to 'Proper Case' for the selected cells  
Format To Upper Case Converts text to 'UPPER CASE' for the selected cells  
Format Trim Values Trims spaces from start and end of text for the selected cells  
Formula Remove External References Removes all external references in the workbook with their values  
Edit Blanks to Zeros Replaces any blank cells with zeroes for the selected cells  
Edit Zeroes to Blanks Replaces any zero values with blanks for the selected cells  
Edit Remove Sheet Objects Removes any shapes, pictures or other objects from the current sheet  
Names Remove Names with Ref Errors from Book Removes all named ranges with invalid references (Ref!) in the workbook]()  
Names Remove All Names from Sheet Removes all user named ranges that are scoped to the current sheet  
Names Remove All Names from Book Removes all user named ranges in the workbook  
Names Create Range Name for Sheet Creates a named ranged scoped to the sheet for the selected range  
Names Create Range Names for Sheet for 2 Column Selection For every value in the first column, creates named ranges in the second column (scoped to the sheet). Create names InterjectConfig_NamedRangePrefix and InterjectConfig_NamedRangeSuffix to modify name created.  
Hyperlink Reset Hyperlink Targets for Selection Fixes hyperlink targets to point to current sheet for selected cells  
Hyperlink Create/Edit Interject Hyperlink Opens a window to create/edit special Interject Hyperlinks. Add name range InterjectStyle_Hyperlink on formatted cell to preserve style of hyperlink.  
Other Unique List from Selection Create a unique list of values from selected cells places in a new tab  
Other Unhide All Sheets Unhides all hidden sheets in the workbook