A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Maximum Row Height Greater than 409.5



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 05:11 PM posted to microsoft.public.excel.misc
PSULionRP
external usenet poster
 
Posts: 116
Default Maximum Row Height Greater than 409.5

I read and Googled how I can increase the height of a row in Excel. Someone
suggested merging two cells together. When I tried that, Excel came back and
warned me that it would inly keep the Upper Left-Hand column and it didn't
lie. I have data in columns A thru E.

How can I keep the data and make the row height more than 409.5???

The font size is already really small.

Any help would be greatly appreciated. Thanks in advance for your review and
hopeful for a Reply.

PSULionRP
  #2  
Old April 23rd, 2010, 05:49 PM posted to microsoft.public.excel.misc
dlw
external usenet poster
 
Posts: 1,600
Default Maximum Row Height Greater than 409.5

what exactly are you trying to do? If you have large amounts of text, maybe
a table in Word would be better. Those tables can also do calculations...

"PSULionRP" wrote:

I read and Googled how I can increase the height of a row in Excel. Someone
suggested merging two cells together. When I tried that, Excel came back and
warned me that it would inly keep the Upper Left-Hand column and it didn't
lie. I have data in columns A thru E.

How can I keep the data and make the row height more than 409.5???

The font size is already really small.

Any help would be greatly appreciated. Thanks in advance for your review and
hopeful for a Reply.

PSULionRP

  #3  
Old April 23rd, 2010, 07:34 PM posted to microsoft.public.excel.misc
PSULionRP
external usenet poster
 
Posts: 116
Default Maximum Row Height Greater than 409.5

The Excel spreadsheet contains procedures for doing certain "Data Repairs".
This one row has a lot of procedures and like I said I've reduced the font,
but we're still not seeing the entire cell. So we'd like to expand that row
height so we can see the entire procedure rather than having to click into
the cell and going through it that way.

Any suggestions???

Thanks!

"dlw" wrote:

what exactly are you trying to do? If you have large amounts of text, maybe
a table in Word would be better. Those tables can also do calculations...

"PSULionRP" wrote:

I read and Googled how I can increase the height of a row in Excel. Someone
suggested merging two cells together. When I tried that, Excel came back and
warned me that it would inly keep the Upper Left-Hand column and it didn't
lie. I have data in columns A thru E.

How can I keep the data and make the row height more than 409.5???

The font size is already really small.

Any help would be greatly appreciated. Thanks in advance for your review and
hopeful for a Reply.

PSULionRP

  #4  
Old April 23rd, 2010, 11:37 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Maximum Row Height Greater than 409.5

You cannot increase the row height above 409.5.


Gord Dibben MS Excel MVP

On Fri, 23 Apr 2010 11:34:11 -0700, PSULionRP
wrote:

The Excel spreadsheet contains procedures for doing certain "Data Repairs".
This one row has a lot of procedures and like I said I've reduced the font,
but we're still not seeing the entire cell. So we'd like to expand that row
height so we can see the entire procedure rather than having to click into
the cell and going through it that way.

Any suggestions???

Thanks!

"dlw" wrote:

what exactly are you trying to do? If you have large amounts of text, maybe
a table in Word would be better. Those tables can also do calculations...

"PSULionRP" wrote:

I read and Googled how I can increase the height of a row in Excel. Someone
suggested merging two cells together. When I tried that, Excel came back and
warned me that it would inly keep the Upper Left-Hand column and it didn't
lie. I have data in columns A thru E.

How can I keep the data and make the row height more than 409.5???

The font size is already really small.

Any help would be greatly appreciated. Thanks in advance for your review and
hopeful for a Reply.

PSULionRP


  #5  
Old April 24th, 2010, 06:20 PM posted to microsoft.public.excel.misc
Billns
external usenet poster
 
Posts: 88
Default Maximum Row Height Greater than 409.5

On 4/23/2010 11:34 AM, PSULionRP wrote:
The Excel spreadsheet contains procedures for doing certain "Data Repairs".
This one row has a lot of procedures and like I said I've reduced the font,
but we're still not seeing the entire cell. So we'd like to expand that row
height so we can see the entire procedure rather than having to click into
the cell and going through it that way.

Any suggestions???

Thanks!

"dlw" wrote:

what exactly are you trying to do? If you have large amounts of text, maybe
a table in Word would be better. Those tables can also do calculations...

"PSULionRP" wrote:

I read and Googled how I can increase the height of a row in Excel. Someone
suggested merging two cells together. When I tried that, Excel came back and
warned me that it would inly keep the Upper Left-Hand column and it didn't
lie. I have data in columns A thru E.

How can I keep the data and make the row height more than 409.5???

The font size is already really small.

Any help would be greatly appreciated. Thanks in advance for your review and
hopeful for a Reply.

PSULionRP


Would increasing the column width help?

If the procedures are as lengthy as you suggest, how about putting each
procedure in a text document and hyperlinking in Excel to that document
instead?

Bill


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.