Excel helpers: row height, notes and regex

Three tools with no AI

Task menu ▸ Excel Helpers

None of these three send anything to the AI service. They work entirely on your own machine.

Adjust Cell Height

Fits the row height to the content – including merged cells. That is the whole point: Excel's own automatic row height does not work on merged cells, so the text gets cut off.

Select the rows or cells and run the feature.

Adjust Size of Notes

This concerns legacy notes – the yellow boxes from older Excel versions, not today's threaded comments. Their boxes keep their size even when the text no longer fits inside.

The feature resizes them so the content is visible.

Regex Search & Replace

Searches using patterns rather than fixed strings and replaces within the selected cells.

Save first. There is no preview of the matches and no per-match confirmation.

In two steps:

1. Patterns, one per line. Then the options, as letters: i ignores case, m multiline, s singleline, c compiled, r right to left, e explicit capture. For the syntax itself the add-in points you to vischerlnk.com/regexinfo.
2. Replacement texts, one per line, in the same order as the patterns.

If the line counts do not match, the add-in aborts without changing anything. So does an invalid pattern – telling you which one.

At the end you are told how many replacements were made in the selected cells.

Careful with formulas and numbers

The replacement operates on the cell content. If a pattern hits a formula, the formula is changed. And text made of digits can be reinterpreted as a number or a date after replacement – 03-04 becomes 3 April.

So select the specific column you mean rather than the whole sheet.