Changeable Row sizes to fit in the text!

Kazuki · 06-06-2006, 02:10 AM

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

**raypayette** · 06-06-2006, 05:25 AM

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

HTH

Kazuki · 06-08-2006, 01:40 AM

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
>
>

**raypayette** · 06-08-2006, 11:07 AM

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** · 06-08-2006, 01:41 PM

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

Kazuki · 06-12-2006, 12:15 AM

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
>
>

**raypayette** · 06-12-2006, 03:03 AM

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.