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 •

#1
January 20, 2010 at 15:22:52
Hi,

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.

Regards


Report •

#2
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.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question