Cell Tools

Edit Cells: provides a means to locate and insert or delete text within selected cells. There is an undo operation available on the last change, so to be safe have a backup. When inserting a word within text use the space bar when a gap between words is needed. Use the undo function and reinsert if not sure where space should appear.

Tracker: is used for keeping track of position, while working through a list. When activated by double-clicking the cell, the tool will colour the cell and move to the next cell in a designated order and direction. When the copy function is turned on the next selected cell will be copied. 

Hide Cells: is a format function that hides the cell contents of a selected range of cells from view. When the format is applied, values can only be seen within the formula bar. The formula bar can be hidden or unhidden using the form. Right-click on the hidden cells and select format cells to view the custom cell format code.

Look Find and Filter

Multi-Find: searches an open worksheet for multiple items, either by specifying a search column or by selecting a sheet range, entire column(s) or row(s). Where items are found the cell fill colour is changed to highlight the cells found. Colour options are available on the form. 

Multi-Lookup: searches designated open workbooks and sheets for matching items and returns all related values contained within a specified column that matches the lookup item in a comma-separated format.

Text Tools

Change Case: provides the option to change the case of cell text values to either UPPER, lower or Proper case

Remove Single Quotes: will remove single quotes from within cell text values. It will not remove a single quote used to justify or align text to the left of the cell.

Remove Double Quotes: will remove all double quotes from within cell text values 

Insert Text: provides a means to store and format a limited amount of text that can later be used to insert into any worksheet or workbook. 

Show Duplicates

Show Duplicates: provides case and non-case sensitive search options to find duplicates. Items that are duplicated are highlighted.

All Repeats: finds all repeating values including the duplicates and highlights there cells with an infill colour. When done a form loads containing a list of the repeat values. The list can then be used to navigate and view the repeat items on the worksheet.

Date Tools

Check if Date: highlights non-date items with a cell infill colour

Convert Date to Text: converts a date format to a text value as 'mmm-yy'

Convert Text to Date: converts a text formatted date from 'mmm-yy' to the 1st of the month.

Convert Text Format to Date: European date formats  dd.mm.yy in some regions can be treated as text by Excel. This macro converts this text format to a date.

Convert Date to Week Number: Converts text date format 'yyyymmdd' to a date

Convert Date to Quarter: converts a date to a text week format similar to yy-ww that can be sorted.

Show Weekends: changes the font colour of dates that fall on a weekend to red.

Free Joomla! templates by Engine Templates