How to stop gridlines printing?

A

AliceInWonderland

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I just got Office for Mac, in the settings for Excel I do not have gridlines selected. In a new document, the gridlines are off and they are invisible.

However when I open an old file I created in Numbers (and saved as an excel file) the gridlines don't turn off, whether they're "on" or not!

I even tried copying and pasting the data from the old file to a new one with gridlines turned off... they still come up.

This is such a huge file I can't recreate it from scratch. But the gridlines are ugly and look unprofessional in the document I'm creating.

Any thoughts?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I just got Office for Mac, in the settings for Excel I do not have gridlines
selected. In a new document, the gridlines are off and they are invisible.

However when I open an old file I created in Numbers (and saved as an excel
file) the gridlines don't turn off, whether they're "on" or not!

I even tried copying and pasting the data from the old file to a new one with
gridlines turned off... they still come up.

This is such a huge file I can't recreate it from scratch. But the gridlines
are ugly and look unprofessional in the document I'm creating.

Any thoughts?

Sounds more like they're borders than gridlines. Have you tried clearing
borders (Format/Cells/Border/None)?

If they really are gridlines, what are you doing to turn them off?

Did you mean to stop gridlines "printing" as in your subject, or
"displaying" on the screen? The former are controlled using Page Setup,
the latter using Preferences/View/Show gridlines checkbox.
 
A

AliceInWonderland

Hi,
Yes I do mean the gridlines, I have SOME tables on so I can definitely tell the difference and I do want tables to print.

When I say print I mean print, as in with ink out of my printer or as a .pdf.

When I print (either in paper format or printing to .pdf) I get a literal replica of what is in my screen, which is feint grey grids with black grids where I have got borders on.

When I turn them "off" I go Sheet>Gridlines>Off (which makes them invisible in a new document) and to turn them "off" for print I go Print>Page Setup>Sheet>Print>Gridlines>Off but they still print!

Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top