Over 100 utilities loaded with 1 add-in file
• Each utility’s file extension is .lad, and only opens through the main add-in
• Only one utility is loaded at a time and closes the previous one, to preserve memory
LAD Utilities Ribbon

LAD Progress Bar

Built-In Excel Features

Clear Active Sheet

Copy Sum

Text Tools Quick Actions

Quick UPPERCASE
Quick Proper Case
Quick Remove All Excess Spaces
Quick Remove Non-Breaking Spaces
Quick Action

Remove Hyperlink
Removes all hyperlink from the Active sheet
Formula to Value
This changes all the formula to value in used range on the active sheet
Strikethrough
This first checks if the font is strikethrough or not and alternate off or on. Saves time by going to the Format Cells Font tab
Clear Formats
This clears all the formatting of the selection
Clear Filters
Another build-in excel feature I use a lot, instead of switching ribbon tabs
Slash to Dash
This replaces slashes to dashes, to help me with renaming files. Slashes cannot be used in a filename. I also added all the other slashes as per my Fix Dashes util under my Utilities Menu
Remove Front Apostrophe
This removes the blind apostrophe in front of a word or value. This is still WIP because my code can remove from both value and number, but it also removes all the formatting. See my post about it.
https://www.excelforum.com
Format default short date
This formats each cell in selection to your PC’s default short date
Apply F2 & Enter
This helps if you have a lot of numbers that are Text formatted. The numbers are left-aligned. You change the format to general and use this to align to the right
Clipboard

About

Options


LAD Calculator
This is just a plain calculator. There is an option to copy a value from a cell to the calculator and also to paste the value from the calculator to the selected cell. You can calculate different cells. You also have 4 different formats to paste your value to the selected cell.

LAD Date Picker
You can customize a selection of dates and insert them at the current selected cell. You have various options.
- Number of dates with date increments (see screenshot)
- 28 different date formats to use.
- Button to go to today’s date.
- Option to have your week started on a Monday.
- With the “Format Only” you can select a range of dates and update it to the selected date format.
- When you insert your dates, you can choose whether to close the date picker or not. (tick Close Form)
- Custom Date
