How do I adjust row height to set cell margins to zero?
 

Hi,
I am trying to adjust row height to a minimum but when printing, the
top of the text is cut off to protect cell margins. Is there a way to
override the default?
ex. a "b" should touch a "g" above it.
It worked in excel97 but not in excel2003.
TIA

How do I adjust row height to set cell margins to zero?
 

marina

If font used is 10 point set row heights to 10.5 or 10 or whatever until you get
the look you want.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:33:02 -0700, marina
wrote:

Hi,
I am trying to adjust row height to a minimum but when printing, the
top of the text is cut off to protect cell margins. Is there a way to
override the default?
ex. a "b" should touch a "g" above it.
It worked in excel97 but not in excel2003.
TIA

How do I adjust row height to set cell margins to zero?
 

The problem is that if the font is 10 point and the row height is also 10,
there is still space between the lines of text but the tops or bottoms of the
letters are cut on the consecutive lines. Is there a way around it in
excel2003?

"Gord Dibben" wrote:

marina

If font used is 10 point set row heights to 10.5 or 10 or whatever until you get
the look you want.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:33:02 -0700, marina
wrote:

Hi,
I am trying to adjust row height to a minimum but when printing, the
top of the text is cut off to protect cell margins. Is there a way to
override the default?
ex. a "b" should touch a "g" above it.
It worked in excel97 but not in excel2003.
TIA

How do I adjust row height to set cell margins to zero?
 

Have you tried a height of 10 and a vertical alignment of "distributed"?

Other than that, I don't know how to achieve the results you need.


Gord

On Sat, 12 Aug 2006 07:03:01 -0700, marina
wrote:

The problem is that if the font is 10 point and the row height is also 10,
there is still space between the lines of text but the tops or bottoms of the
letters are cut on the consecutive lines. Is there a way around it in
excel2003?

"Gord Dibben" wrote:

marina

If font used is 10 point set row heights to 10.5 or 10 or whatever until you get
the look you want.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:33:02 -0700, marina
wrote:

Hi,
I am trying to adjust row height to a minimum but when printing, the
top of the text is cut off to protect cell margins. Is there a way to
override the default?
ex. a "b" should touch a "g" above it.
It worked in excel97 but not in excel2003.
TIA

How do I adjust row height to set cell margins to zero?
 

Thank you for your replies, but this does not work either.
Maybe there is a way to replace white cell margins with transparent?
I am still trying to print 10 pont font in a 10 pixel row height, so that
there would be no blank space between the lines and the letters would not be
chopped off on top and bottom.

"Gord Dibben" wrote:

Have you tried a height of 10 and a vertical alignment of "distributed"?

Other than that, I don't know how to achieve the results you need.


Gord

On Sat, 12 Aug 2006 07:03:01 -0700, marina
wrote:

The problem is that if the font is 10 point and the row height is also 10,
there is still space between the lines of text but the tops or bottoms of the
letters are cut on the consecutive lines. Is there a way around it in
excel2003?

"Gord Dibben" wrote:

marina

If font used is 10 point set row heights to 10.5 or 10 or whatever until you get
the look you want.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:33:02 -0700, marina
wrote:

Hi,
I am trying to adjust row height to a minimum but when printing, the
top of the text is cut off to protect cell margins. Is there a way to
override the default?
ex. a "b" should touch a "g" above it.
It worked in excel97 but not in excel2003.
TIA