Row Height > 409.50

[karthikbalaguru]

Hi,

I am using Microsoft Excel 2007.
How to increase the row height
to a value greater thatn 409.50.

Currently,
If i try to increase it above 409.50,
it is displaying the below message :
"Row Height must be between 0 and
409"

Any ideas ?

Thx in advans,
Karthik Balaguru

 

[Jacob Skaria]

Karthik

In MS Excel 2007 the maximum row height is 409. Please refer the below link
for more on the specifications and limits

http://office.microsoft.com/en-us/excel/HP051992911033.aspx

If this post helps click Yes

 

[Bill Sharpe]

Hi,

I am using Microsoft Excel 2007.
How to increase the row height
to a value greater thatn 409.50.

Currently,
If i try to increase it above 409.50,
it is displaying the below message :
"Row Height must be between 0 and
409"

Any ideas ?

Thx in advans,
Karthik Balaguru

409 points is 5.68 inches. Why do you need a row height greater than that?

I'd use Word or some presentation program instead to get lines bigger
than this.

Bill

 

[karthikbalaguru]

409 points is 5.68 inches. Why do you need a row height greater than that?

I have a row that requires 1 more inch.
I need this so that it can be viewed
without clicking and scrolling for the
data that comes near the end of the
cell.

I tried with the following also -
1. Format - Row Height - set value to 410 and
2. Format - Autofit Row Height.

It allowed me to chang till 409.50
But, it did not allow me to change
more than 409.50 . Even though
it displays the message as
'Row Height must be between 0
and 409' only and not with 409.50.

How to change the Row Height to be
greater than 409.50 ?

Why has it been fixed at 409 ?
Nowadays we have big slim montors and
also multiple-displays are also possible.
Any ideas ?

Thx in advans,
Karthik Balaguru

 

[Dave Peterson]

I don't think any one of the posters here know why MS made the decision. They
only know that this is what it is.

 

[Bob I]

Use smaller font instead?

I have a row that requires 1 more inch.
I need this so that it can be viewed
without clicking and scrolling for the
data that comes near the end of the
cell.

I tried with the following also -
1. Format - Row Height - set value to 410 and
2. Format - Autofit Row Height.

It allowed me to chang till 409.50
But, it did not allow me to change
more than 409.50 . Even though
it displays the message as
'Row Height must be between 0
and 409' only and not with 409.50.

How to change the Row Height to be
greater than 409.50 ?

Why has it been fixed at 409 ?
Nowadays we have big slim montors and
also multiple-displays are also possible.
Any ideas ?

Thx in advans,
Karthik Balaguru

 

[Bill Sharpe]

Any ideas ?

Use a font like Arial Narrow?

Bill

 

[Jon Peltier]

I have a row that requires 1 more inch.
I need this so that it can be viewed
without clicking and scrolling for the
data that comes near the end of the
cell.

I tried with the following also -
1. Format - Row Height - set value to 410 and
2. Format - Autofit Row Height.

It allowed me to chang till 409.50
But, it did not allow me to change
more than 409.50 . Even though
it displays the message as
'Row Height must be between 0
and 409' only and not with 409.50.

How to change the Row Height to be
greater than 409.50 ?

Why has it been fixed at 409 ?
Nowadays we have big slim montors and
also multiple-displays are also possible.
Any ideas ?

I think the designers of Excel said, let's use Excel for spreadsheets. Folks
who want to do word processing and even page layout can use Word. People who
need ten bazillion records can use Access, and hey, this PowerPointy thing
is good for making fancy overheads.

While there is a certain flexibility among the different software tools,
there are limits, just like you get poor results using the wrong wrench to
pound in the wrong bolt.

- Jon

 

[Bob I]

I think the designers of Excel said, let's use Excel for spreadsheets. Folks
who want to do word processing and even page layout can use Word. People who
need ten bazillion records can use Access, and hey, this PowerPointy thing
is good for making fancy overheads.

While there is a certain flexibility among the different software tools,
there are limits, just like you get poor results using the wrong wrench to
pound in the wrong bolt.

Not a problem if you use a Cresent Hammer! (Pat. Pend.)

 

[missnz]

I just found this thread as I was having trouble with adjusting column height too... i found a way round it by inserting a new column and cutting the text that wouldn't fit and pasting it into the cell beside it, and then merging the heading, so essentially it is all the info under the same heading.

Hope this helps someone

 

[Dez]

This is the workaround:
1. Paste all your data in a cell
2. Cut the data that cuts off and paste it in the cell below
3. Go to the column directly next to your 2 cells and merge the 2 cells
4. U should now be able to copy the entire data set into the 2 merged cells
Example:
If your data is split between cells A1 and A2, merge cells B1 and B2.
Paste your clunk of data in the merged cells

Let me know if this helps