I'm not sure that there's a global way to do this.

But if you change the rowheight manually, excel won't automatically adjust it.

Maybe you could run a little macro that "adjusts" the rowheight--but not a
noticeable amount:

Option Explicit
Sub testme()

Dim wks As Worksheet
Dim myRow As Range
Dim myHeight As Double

For Each wks In ActiveWorkbook.Worksheets
With wks
For Each myRow In .UsedRange.Rows
With myRow
.RowHeight = .RowHeight + 0.01
End With
Next myRow
End With
Next wks

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

J wrote:

Thank you for your response.

To be clearer:

I have a notebook with 5 duplicate pages.

The row heights are all appropriately set for current contents.

All rows are not the same height.

Some of the cells do wrap text.

When I enter new data I do NOT want the height to change.

I want to be able to adjust the font size to fit the current height/width.

Any global setting to stop autofit?

J

"CyberTaz" wrote in message ...
Click the tab for the first sheet, then hold down Shift while you click the
tab for the last sheet to select all sheets. Then click the Select All Cells
button (empty gray 'box' where the column heading bar and the Row heading bar
meet). Go to FormatRowHeight and type whatever value you want to use for
row height. You can also drag any Row Separator while you have the cells
selected instead of using the menu to specify a height value.

HTH |:)

"J" wrote:

I have a notebook that I want to have all row heights set from sheet to sheet.

I do NOT want autofit to adjust row size.

Is it possible to disable this "feature?"

J




--

Dave Peterson