Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
donbowyer
 
Posts: n/a
Default set height of individual cells

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default set height of individual cells

The easiest way is to merge cells vertically. Say select cells A1 and A2 and
pull-down:

Format Cells... Alignment and check Merge
--
Gary's Student


"donbowyer" wrote:

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie
 
Posts: n/a
Default set height of individual cells

Why do you need this? You can only set a row height, not have various cell
heights in one row, it would be horrendously confusing at least.If it is
because you want all cells to display at the same first line level, then set
you vertical text alignment to Top.
Normal Display = asdf
qwerty asdf

If set to top = asdf asdf
qwerty

"donbowyer" wrote:

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
donbowyer
 
Posts: n/a
Default set height of individual cells

True - but putting all the vertical alignment at the top achieves what I need.
Thanks to all who responded
--
donwb


"kassie" wrote:

Why do you need this? You can only set a row height, not have various cell
heights in one row, it would be horrendously confusing at least.If it is
because you want all cells to display at the same first line level, then set
you vertical text alignment to Top.
Normal Display = asdf
qwerty asdf

If set to top = asdf asdf
qwerty

"donbowyer" wrote:

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to deselect individual cells after selecting them with CTL-Cli JarrodP Excel Discussion (Misc queries) 2 August 10th 07 11:24 PM
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
adding individual cells in a column Sheila Excel Worksheet Functions 4 January 31st 06 12:36 AM
Autofit Row Height of Merged Cells Jon Excel Discussion (Misc queries) 3 August 5th 05 08:15 PM
Can u lock individual cells (those containing formulas) in an Exc. [email protected] Excel Discussion (Misc queries) 1 March 2nd 05 09:02 AM


All times are GMT +1. The time now is 04:39 PM.

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

About Us

"It's about Microsoft Excel"