Hi!

I have text in cells that are situated above each other, and I let the text
fill the cells completely from top to bottom. I'm trying to create text with
no horizontal lines in between when I print, but that doesn't happen. The
grid lines still leave very thin white lines between the cells.

I've also tried to have several lines in one cell, but couldn't find any way
to affect the distance between two text lines.

Is there any help you could offer?

Petter Ilander, Finland

Petter,

Have you turned off the gridlines by going to 'Tools' 'Options'
'View' tab and unchecking the gridlines?

Not sure what you mean re the second part - The line spaces can't be
altered in Excel as far as I'm aware, like they can in Word. I'm not
sure from your message if you have text wrapping...if not go to
'Format' 'Cells' and the 'Alignment' tab and check the box.

You can then add your own borders via 'Format' 'Cells' 'Border'
tab.

....and you can of course wrap text where you want by holding down the
'Alt' key and hitting enter whilst typing in a cell.

Hope this helps


--
Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!
------------------------------------------------------------------------
Big Chris's Profile: http://www.excelforum.com/member.php...fo&userid=1350
View this thread: http://www.excelforum.com/showthread...hreadid=505662

Just as an experiment try the following three things:

1. Tools Options View and clear the gridlines checkbox
2. File Page Setup Sheet and clear the gridlines checkbox
3. select the cells you are going to print and:
Format Cellls... Patterns and for color choose White (lower right)

--
Gary's Student


"opilander" wrote:

Hi!

I have text in cells that are situated above each other, and I let the text
fill the cells completely from top to bottom. I'm trying to create text with
no horizontal lines in between when I print, but that doesn't happen. The
grid lines still leave very thin white lines between the cells.

I've also tried to have several lines in one cell, but couldn't find any way
to affect the distance between two text lines.

Is there any help you could offer?

Petter Ilander, Finland

Have you turned off Gridlines in PageSetup, FilePagesetupSheet?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"opilander" wrote in message
...
Hi!

I have text in cells that are situated above each other, and I let the
text
fill the cells completely from top to bottom. I'm trying to create text
with
no horizontal lines in between when I print, but that doesn't happen. The
grid lines still leave very thin white lines between the cells.

I've also tried to have several lines in one cell, but couldn't find any
way
to affect the distance between two text lines.

Is there any help you could offer?

Petter Ilander, Finland

Thanks for the tip.

Tried it, but it didn't really do anything. The thin white lines are still
present when you print.

Any more ideas are welcome...


"Gary''s Student" wrote:

Just as an experiment try the following three things:

1. Tools Options View and clear the gridlines checkbox
2. File Page Setup Sheet and clear the gridlines checkbox
3. select the cells you are going to print and:
Format Cellls... Patterns and for color choose White (lower right)

--
Gary's Student


"opilander" wrote:

Hi!

I have text in cells that are situated above each other, and I let the text
fill the cells completely from top to bottom. I'm trying to create text with
no horizontal lines in between when I print, but that doesn't happen. The
grid lines still leave very thin white lines between the cells.

I've also tried to have several lines in one cell, but couldn't find any way
to affect the distance between two text lines.

Is there any help you could offer?

Petter Ilander, Finland