Formatting Tools

Formatting Tools - utilities that assist in formatting cells

Change Case: Changes the Case of the selected Range - except cells with formulas - based on the user choice.

Column to Multi-Column: Adds a new Sheet with information distributed into the number of required columns based on the selected cells in a column and the inputted number of columns.

Concatenate Range: Inserts the function - EnPConcat which concatenates a range of cells using an optional delimiter.

Delimiter (Optional): user defined separator between elements.

AsShown (Optional): False displays actual values (default) while True displays the text as formatted.

OmitBlanks (Optional: True omits blanks cells while False includes them (default).

Cycle Fill Colours: Cycles the fill colours of the selected shapes through Light Blue, Dark Blue, Light Grey, Orange and White.

Delete Hidden Rows: Deletes all the hidden rows on the active sheet. Particularly useful when using auto filter.

Duplicate Finder: Finds duplicate rows based on selected column(s) content. Example: if A1 and C1 match A3 and C3, the rows are considered a match. The user is given a choice to delete all but the first row of the group of "duplicates" or not. If not, the rows are grouped and sorted to the top. The groups are highlighted with alternating colours.

Fill Same: Fills blank cells with the value above in the selected range. Works best with values not formulas. Use the Formula to Value tool in Misc Tools to convert formulas to values.

Format Range: Applies borders and alternating rows fills to the current Selection.

Join, Merge and Wrap: Based on the selected cells, merges the cells and text within the cells inserting a carriage return between cell entries.

Join and Merge: Based on the selected cells, merges the cells and text within the cells.

Make Cells Square: Sets the cells in a worksheet to be square based on a row height of 15.

Merge Same: Merges cells in a column with the same value in the selected range. Works best with values not formulas. Use the Formula to Value tool in Misc Tools to convert formulas to values.

Reset Used Range: Resets the active area in the current worksheet. Typically used after many rows of data have been deleted.