ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row Height 409.50 (https://www.excelbanter.com/excel-discussion-misc-queries/225929-row-height-409-50-a.html)

karthikbalaguru

Row Height 409.50
 
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

Row Height 409.50
 
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/ex...992911033.aspx

If this post helps click Yes
---------------
Jacob Skaria


"karthikbalaguru" wrote:

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


Bill Sharpe

Row Height 409.50
 
karthikbalaguru wrote:
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

Row Height 409.50
 
On Mar 29, 11:15 pm, Bill Sharpe wrote:
karthikbalaguru wrote:
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 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

Row Height 409.50
 
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.

karthikbalaguru wrote:

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

Bob I

Row Height 409.50
 
Use smaller font instead?

karthikbalaguru wrote:

On Mar 29, 11:15 pm, Bill Sharpe wrote:

karthikbalaguru wrote:

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

Row Height 409.50
 
karthikbalaguru wrote:

Any ideas ?

Use a font like Arial Narrow?

Bill

Jon Peltier

Row Height 409.50
 

"karthikbalaguru" wrote in message
...
On Mar 29, 11:15 pm, Bill Sharpe wrote:
karthikbalaguru wrote:
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 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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______



Bob I

Row Height 409.50
 


Jon Peltier wrote:

"karthikbalaguru" wrote in message
...

On Mar 29, 11:15 pm, Bill Sharpe wrote:

karthikbalaguru wrote:

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


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



All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com