Gridlines

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

I am on an XP machine...

I am coloring all of the borders on a worksheet white so
that it looks like a white page when you look at it...for
some reason when I print it prints the gridlines black in
the print area.

Here is the kicker...it looks like I want on the print
preview screen and the gridlines checkbox is unchecked in
the print setup and tools options. But wait, there is
more...if I send this file to someone else to print it
will not do that for them...AND it does not do this for
every page in the workbook...only cirtain ones...

I'm stumped...my co-workers are snowed...so I am coming
to you (the people that created the software).

Please help.

Thanks
Carrie
 
I am on an XP machine...

I am coloring all of the borders on a worksheet white so
that it looks like a white page when you look at it...for
some reason when I print it prints the gridlines black in
the print area.

Here is the kicker...it looks like I want on the print
preview screen and the gridlines checkbox is unchecked in
the print setup and tools options. But wait, there is
more...if I send this file to someone else to print it
will not do that for them...AND it does not do this for
every page in the workbook...only cirtain ones...

I'm stumped...my co-workers are snowed...so I am coming
to you (the people that created the software).
Click to expand...

This is a user-to-user forum. The people responsible for this software know
better than to pay their employees to provide free support.

The best way to eliminate gridlines is to use the Tools > Options... menu
command, select the View tab in the Options dialog, uncheck the Gridlines check
box, click OK, and save the file. To disable gridlines on several worksheets,
select these worksheets before running this menu command. For example, if you're
in worksheet X and you want to disable gridlines in it and worksheets Y and Z as
well, hold down a [Ctrl] key and click on the worksheet tabs for worksheets Y
and Z. All three worksheet tabs should be highlighted. Now run the menu command.
 
-----Original Message-----
...

This is a user-to-user forum. The people responsible for this software know
better than to pay their employees to provide free support.

The best way to eliminate gridlines is to use the Tools
Options... menu
command, select the View tab in the Options dialog, uncheck the Gridlines check
box, click OK, and save the file. To disable gridlines on several worksheets,
select these worksheets before running this menu
Click to expand...
command. For example, if you're
in worksheet X and you want to disable gridlines in it and worksheets Y and Z as
well, hold down a [Ctrl] key and click on the worksheet tabs for worksheets Y
and Z. All three worksheet tabs should be highlighted. Now run the menu command.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
.
Click to expand...

I have checked this already...this box is unchecked...as
is the box in the page setup.

Any other ideas???

thanks,
carrie
 
...
......

Should have noticed that. What happens when you eliminate rather than color all
borders?
 
-----Original Message-----
...
...
...

Should have noticed that. What happens when you
Click to expand...
eliminate rather than color all
borders?

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
.
Click to expand...

I don't quite know what you mean by this...

if you mean take all borders away so that they are greyed
out...then yes...it prints fine.

But that also eliminates the point of coloring the
borders white...I do this so that it looks like a printed
page.

Plus, if I am coloring the borders white and it prints
the borders...shouldn't it print white?

This gets frustrating doesn't it.

Thanks,
Carrie
 
...
eliminate rather than color all borders?

I don't quite know what you mean by this...
Click to expand...

What I mean is that borders are optional. You don't need to have any.
if you mean take all borders away so that they are greyed
out...then yes...it prints fine.
Click to expand...

Grayed out?

There's a Border tab in the Format Cells dialog. The bulk of that tab is a
graphic entry box with multiple corner marks and one or more instances of the
word Text indicating one or several cells, respectively. If you have any
borders, then there are lines between some of the corner marks. The button in
the top-left corner of the dialog should be labeled None, and will remove all
borders. This is what I mean by eliminate all borders.

If there's anything resembling either borders or gridlines once you've done
this, then it would appear you have not turned off gridlines. Tools >
Options..., View tab, uncheck Gridlines to do so.
But that also eliminates the point of coloring the
borders white...I do this so that it looks like a printed
page.

Plus, if I am coloring the borders white and it prints
the borders...shouldn't it print white?
Click to expand...

Setting borders eats lots of memory. Excel doesn't store formatting information
efficiently. I'm trying to suggest a way of accomplishing what you seem to want
without using unnecessary amounts of memory.

Another thing I hadn't considered: is the Black and White setting checked in the
Sheet tab of the Page Setup dialog? Even if your borders are white on screen,
Excel will happily print your borders in black.

If you want to print without gridlines, don't try to use white cell borders to
do this - it obviously doesn't always work. Instead, uncheck both Gridlines and
Blank and White in the Sheet tab of the Page Setup dialog. Also check that
you're using the correct printer driver (on your PC) for the printer to which
you're sending your print jobs.
 
Ok...yes, I did all of these things. When I eliminate
borders it prints fine. But that also, eliminates the
point of the screen looking like a page because now you
see "gray" indicating where the borders would be.

I don't understand why it prints...I have white borders
and they are printing black.

Sorry, but this is getting a bit frustrating.

Carrie
-----Original Message-----
...


What I mean is that borders are optional. You don't need to have any.


Grayed out?

There's a Border tab in the Format Cells dialog. The bulk of that tab is a
graphic entry box with multiple corner marks and one or more instances of the
word Text indicating one or several cells, respectively. If you have any
borders, then there are lines between some of the corner marks. The button in
the top-left corner of the dialog should be labeled None, and will remove all
borders. This is what I mean by eliminate all borders.

If there's anything resembling either borders or gridlines once you've done
this, then it would appear you have not turned off gridlines. Tools >
Options..., View tab, uncheck Gridlines to do so.


Setting borders eats lots of memory. Excel doesn't store formatting information
efficiently. I'm trying to suggest a way of
Click to expand...
accomplishing what you seem to want
 
Why don't you turn off gridlines altogether instead under tools>options>view
or change the gridlines to white, then use fill colour all around the
"page"?
 
AHH! Thank you. I see now...thank you.
-----Original Message-----
Why don't you turn off gridlines altogether instead under tools>options>view
or change the gridlines to white, then use fill colour all around the
"page"?

--

Regards,

Peo Sjoblom





.
Click to expand...
 
Back
Top