Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cells with different height on a row and hiding certain cells

I have a problem with cells with different height of eachother and.. I don't
know how to hide certain cells content from printing it.. and the
formatting..

Here's a screenshot to clear things:
http://www.vahetus.com/up/screeny.jpg
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Cells with different height on a row and hiding certain cells

To hide printed data, set font colour to white.

Your row 12 height is set by the headings in the green area so you would
have to adjust this somehow.

I don't see why row 18 is the wider: try just reducing the height.

"MadHenry" wrote:

I have a problem with cells with different height of eachother and.. I don't
know how to hide certain cells content from printing it.. and the
formatting..

Here's a screenshot to clear things:
http://www.vahetus.com/up/screeny.jpg

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cells with different height on a row and hiding certain cells

Okay if i can only hide it by changing the colour then I need to record some
kind of macro and then learn from it. (Maybe there's some other way)
BUT actually the cell height problem isn't resolved.. isn't there any
possibility to change that right-most table to some kind of layer, so it's
cells' heights don't be affected by the left-most tablecells' heights?
...and the row 18 height is bigger because there has to be space after the
printing to be able to write some things there..
"Toppers" wrote:

To hide printed data, set font colour to white.

Your row 12 height is set by the headings in the green area so you would
have to adjust this somehow.

I don't see why row 18 is the wider: try just reducing the height.

"MadHenry" wrote:

I have a problem with cells with different height of eachother and.. I don't
know how to hide certain cells content from printing it.. and the
formatting..

Here's a screenshot to clear things:
http://www.vahetus.com/up/screeny.jpg

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Cells with different height on a row and hiding certain cells

You can't adjust row height for a selection of cells ... it's all or nothing.
You could - but is generally NOT advised - merge cells to incorporate your
headings and the text in row 18 : e.g merge rows 11 & 12 for columns A to F
(merge individual columns).

"MadHenry" wrote:

Okay if i can only hide it by changing the colour then I need to record some
kind of macro and then learn from it. (Maybe there's some other way)
BUT actually the cell height problem isn't resolved.. isn't there any
possibility to change that right-most table to some kind of layer, so it's
cells' heights don't be affected by the left-most tablecells' heights?
..and the row 18 height is bigger because there has to be space after the
printing to be able to write some things there..
"Toppers" wrote:

To hide printed data, set font colour to white.

Your row 12 height is set by the headings in the green area so you would
have to adjust this somehow.

I don't see why row 18 is the wider: try just reducing the height.

"MadHenry" wrote:

I have a problem with cells with different height of eachother and.. I don't
know how to hide certain cells content from printing it.. and the
formatting..

Here's a screenshot to clear things:
http://www.vahetus.com/up/screeny.jpg

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
Merged cells won't Autofit row height Hpyifur Excel Discussion (Misc queries) 27 May 20th 23 07:45 PM
Row height using autofit, with no merged cells D.Smith Excel Discussion (Misc queries) 1 July 2nd 06 11:51 AM
set height of individual cells donbowyer Excel Worksheet Functions 3 May 27th 06 03:11 PM
Autofit Row Height of Merged Cells Jon Excel Discussion (Misc queries) 3 August 5th 05 08:15 PM
Autofit row height in merged cells BobT Excel Discussion (Misc queries) 1 February 25th 05 04:44 PM


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

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"