PC Review


Reply
Thread Tools Rate Thread

Changing the row height at a particular column

 
 
I NEED HELP FAST!
Guest
Posts: n/a
 
      1st Apr 2008
Hello, My question is regarding chnaging the row width at a particular
column. For example, I have the height of a row at 4.5 pixels, which is
extremely small (it's a spacer row), but when I reach column M I want the
height to be different the rest of the way. How can I make it so that row 4
has one height from columns A-L and another height from columns M-T?
 
Reply With Quote
 
 
 
 
Tyro
Guest
Posts: n/a
 
      1st Apr 2008
Not possible. The row height applies to the entire row. Column width
applies to the entire column. You can play with inserting rows and columns
and merging cells to achieve certain effects.

Tyro

"I NEED HELP FAST!" <I NEED HELP FAST!@discussions.microsoft.com> wrote in
message news:356E2C4C-8B12-49F0-81DF-(E-Mail Removed)...
> Hello, My question is regarding chnaging the row width at a particular
> column. For example, I have the height of a row at 4.5 pixels, which is
> extremely small (it's a spacer row), but when I reach column M I want the
> height to be different the rest of the way. How can I make it so that row
> 4
> has one height from columns A-L and another height from columns M-T?



 
Reply With Quote
 
T. Valko
Guest
Posts: n/a
 
      1st Apr 2008
>How can I make it so that row 4 has one height from
>columns A-L and another height from columns M-T?


You can't. A row (or column) has the same height (or width) in the *entire*
row (or column).

An alternative would be to merge cells in 2 rows starting at column M but
merging cells usually cause more unforseen problems that they're worth.

--
Biff
Microsoft Excel MVP


"I NEED HELP FAST!" <I NEED HELP FAST!@discussions.microsoft.com> wrote in
message news:356E2C4C-8B12-49F0-81DF-(E-Mail Removed)...
> Hello, My question is regarding chnaging the row width at a particular
> column. For example, I have the height of a row at 4.5 pixels, which is
> extremely small (it's a spacer row), but when I reach column M I want the
> height to be different the rest of the way. How can I make it so that row
> 4
> has one height from columns A-L and another height from columns M-T?



 
Reply With Quote
 
I NEED HELP FAST!
Guest
Posts: n/a
 
      1st Apr 2008
Thank you for the reply

"Tyro" wrote:

> Not possible. The row height applies to the entire row. Column width
> applies to the entire column. You can play with inserting rows and columns
> and merging cells to achieve certain effects.
>
> Tyro
>
> "I NEED HELP FAST!" <I NEED HELP FAST!@discussions.microsoft.com> wrote in
> message news:356E2C4C-8B12-49F0-81DF-(E-Mail Removed)...
> > Hello, My question is regarding chnaging the row width at a particular
> > column. For example, I have the height of a row at 4.5 pixels, which is
> > extremely small (it's a spacer row), but when I reach column M I want the
> > height to be different the rest of the way. How can I make it so that row
> > 4
> > has one height from columns A-L and another height from columns M-T?

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Row Height/Column Width DJ Microsoft Excel Misc 4 27th Feb 2009 02:07 AM
Changing row height/column width & see the value change while drag DJ Microsoft Excel Misc 0 24th Feb 2009 04:42 PM
Column width & Row Height changing using macro/vb Ram B Microsoft Excel Programming 2 8th Aug 2008 02:01 PM
need to dbl row height without changing height of cell next to it =?Utf-8?B?RXhjZWwtSWxsaXRlcmF0ZQ==?= Microsoft Excel New Users 1 16th May 2006 01:08 AM
Changing height of text box control as row height changes Brett Microsoft Access Form Coding 1 18th Jan 2006 07:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:16 AM.