Prev: lookup an address in a worksheet
Next: Can't open already opend files since changeover.
From: PSULionRP on 23 Apr 2010 12:11
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
From: dlw on 23 Apr 2010 12:49
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
From: PSULionRP on 23 Apr 2010 14:34
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
From: Gord Dibben on 23 Apr 2010 18:37
You cannot increase the row height above 409.5.


Gord Dibben MS Excel MVP

On Fri, 23 Apr 2010 11:34:11 -0700, PSULionRP
<PSULionRP(a)discussions.microsoft.com> 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

From: Billns on 24 Apr 2010 13:20
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


 | 
Pages: 1
Prev: lookup an address in a worksheet
Next: Can't open already opend files since changeover.