Excel Find Cells Where Text not Visible

Microsoft Excel 2007
January 20, 2010 at 13:49:57
Specs: Windows Vista
I have a worksheet with cells that may contain text that sometimes exceeds the width and height of the cell. If I don't notice it and adjust the row height, the text shows up as cutoff. Does anyone have a VBA snippet or tool that can locate these cells so I can adjust them? Thanks!

See More: Excel Find Cells Where Text not Visible

Report •

January 20, 2010 at 15:22:52

Try this:

Select all the cells on the worksheet.
Right-click and select Format cells...
Select the Alignment tab.
Check the 'wrap text' box.

The row height should adjust for changes in the amount of text in the cells.


Report •

January 20, 2010 at 15:28:16
How about you select the whole sheet, then simply select an appropriate font size on the task bar.
That should get everything normalized.



Report •

Related Solutions

Ask Question