2

When a cell contains more information than the width of the cell allows, then content is hidden.

Is there any way to show this visually in Excel that this is the case (like an icon or similar)?

Dave
  • 25,513
Jezza
  • 21

1 Answers1

0

I think there are too many variables at play here. The main factors would be: font family, font size, wrap text, merge, and which characters are used.

The following might be a close hack. You could loop through the columns (and/or rows) and store the width of each in an array. Autofit the columns. Loop through the columns again and test if the current width is the same as the original. If it is not, then change it back and add some sort of indicator. The indicator could be a background highlight, cell comment, etc.

DiegoAndresJAY
  • 203