In my excel sheet, columns widths are fixed and cannot be edited. When data
is added, the row height would be changed and words are wrapped.

But the row height is not getting adjusted to show the text contents when i
double-clicked on the border of the row when the adjust symbol is shown.

What should I do since I cannot hand edit the row height for hundreds of
rows.....

Put this code in each worksheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows("1:65536").EntireRow.AutoFit
End Sub

HTH


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=548858

I am new to use excel. So I do not know where to use this code. Please help!

"raypayette" wrote:


Put this code in each worksheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows("1:65536").EntireRow.AutoFit
End Sub

HTH


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=548858

Call the Visual Basic Editor either by clicking Alt+F11 or
by clicking on the Tools, Macros, Visual Basic Editor.
You should see the Project Explorer; click Ctrl+R if you don't.
In the Microsoft Excel Objects there should be a list of your
worksheets;
initially they should be named Sheet1, Sheet2 and Sheet3.
Click on each name and place the macro in each one.
Save the file and return to your Worksheet; press Alt+F11 to do this.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=548858

I took it for granted that your cells would wrap text. To do this select
the ranges, click Format, Cells, Alignment, and Wrap text.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=548858

I have already selected word wrap for the whole sheet.
I had already tried this option
Format -- Row -- Autofit
I guessed this should change the row height to display the whold text.
Rather this option is reducing the size to a normal row height and displaying
only 1 line of the wrapped text in the selected row....
The same happens when I use this macro in VBA rditor also.....
What should I do?

"raypayette" wrote:


Call the Visual Basic Editor either by clicking Alt+F11 or
by clicking on the Tools, Macros, Visual Basic Editor.
You should see the Project Explorer; click Ctrl+R if you don't.
In the Microsoft Excel Objects there should be a list of your
worksheets;
initially they should be named Sheet1, Sheet2 and Sheet3.
Click on each name and place the macro in each one.
Save the file and return to your Worksheet; press Alt+F11 to do this.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=548858

Indeed it should work!
Check again that the cell' Word wrap option is selected.
When I do it, and I write overflowing data the row automatically
expands and allows for word wrap!
Check that you don't use an Autoformat or Style that override these
commands.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=548858