Gridlines in excel

[GRIDLINES IN EXCEL]

Excel will not print gridlines even though gridlines is checked in all spots.
When you print the worksheet it comes out with no gridlines at all even
though it is checked in page setup and view mode.

[Eddie O]

Make sure your spreadsheet does not have have fill color. If it's white
fill, for example, the gridlines won't come out in the print out.

"GRIDLINES IN EXCEL" wrote:

> Excel will not print gridlines even though gridlines is checked in all spots.
> When you print the worksheet it comes out with no gridlines at all even
> though it is checked in page setup and view mode.

[GRIDLINES IN EXCEL]

Yeah that didn't help. There was on fill color and it's still not working.
Yikes.

"Eddie O" wrote:

> Make sure your spreadsheet does not have have fill color. If it's white
> fill, for example, the gridlines won't come out in the print out.
>
> "GRIDLINES IN EXCEL" wrote:
>
> > Excel will not print gridlines even though gridlines is checked in all spots.
> > When you print the worksheet it comes out with no gridlines at all even
> > though it is checked in page setup and view mode.

[Therese]

Hi
You can higlight the whole spreadsheet, then go down to pagelayout and then
the fourth "page" or option.(Mine is not english-sorry!). There you have the
option to print the gridlines.
Hope it'll help
--
Therese


"GRIDLINES IN EXCEL" skrev:

> Yeah that didn't help. There was on fill color and it's still not working.
> Yikes.
>
> "Eddie O" wrote:
>
> > Make sure your spreadsheet does not have have fill color. If it's white
> > fill, for example, the gridlines won't come out in the print out.
> >
> > "GRIDLINES IN EXCEL" wrote:
> >
> > > Excel will not print gridlines even though gridlines is checked in all spots.
> > > When you print the worksheet it comes out with no gridlines at all even
> > > though it is checked in page setup and view mode.

[GRIDLINES IN EXCEL]

Yes I know, and we have tried everything to print gridlines but they will
not. Not in print preview not anywhere

"Therese" wrote:

> Hi
> You can higlight the whole spreadsheet, then go down to pagelayout and then
> the fourth "page" or option.(Mine is not english-sorry!). There you have the
> option to print the gridlines.
> Hope it'll help
> --
> Therese
>
>
> "GRIDLINES IN EXCEL" skrev:
>
> > Yeah that didn't help. There was on fill color and it's still not working.
> > Yikes.
> >
> > "Eddie O" wrote:
> >
> > > Make sure your spreadsheet does not have have fill color. If it's white
> > > fill, for example, the gridlines won't come out in the print out.
> > >
> > > "GRIDLINES IN EXCEL" wrote:
> > >
> > > > Excel will not print gridlines even though gridlines is checked in all spots.
> > > > When you print the worksheet it comes out with no gridlines at all even
> > > > though it is checked in page setup and view mode.

[Gord Dibben]

Did you look to see if you were set to "draft quality"?


Gord Dibben Excel MVP

On Mon, 5 Dec 2005 05:17:05 -0800, GRIDLINES IN EXCEL
<[email protected]> wrote:

>Yes I know, and we have tried everything to print gridlines but they will
>not. Not in print preview not anywhere
>
>"Therese" wrote:
>
>> Hi
>> You can higlight the whole spreadsheet, then go down to pagelayout and then
>> the fourth "page" or option.(Mine is not english-sorry!). There you have the
>> option to print the gridlines.
>> Hope it'll help
>> --
>> Therese
>>
>>
>> "GRIDLINES IN EXCEL" skrev:
>>
>> > Yeah that didn't help. There was on fill color and it's still not working.
>> > Yikes.
>> >
>> > "Eddie O" wrote:
>> >
>> > > Make sure your spreadsheet does not have have fill color. If it's white
>> > > fill, for example, the gridlines won't come out in the print out.
>> > >
>> > > "GRIDLINES IN EXCEL" wrote:
>> > >
>> > > > Excel will not print gridlines even though gridlines is checked in all spots.
>> > > > When you print the worksheet it comes out with no gridlines at all even
>> > > > though it is checked in page setup and view mode.

[David McRitchie]

There is two more places to look for interior cell color
- Format, Conditional Formatting
- Format, Style

The specific places (rather than all the places) for gridlines are, and
you did specifically mention view & setup in original question.
- print controlled by Tools, Options, View
- display controlled by File, Page Setup, Sheet, Gridlines (checked)
- gridlines are overriden by interior color pattern, borders, draft quality

Nothing here specifically about gridlines, but would check it anyway
Changes to the fill color and the fill pattern are not displayed in Office programs
http://support.microsoft.com/?kbid=320531

Please provide feedback when you do turn up the problem and solution.

Gridlines and Borders
: http://www.mvps.org/dmcritchie/excel/gridline.htm

Please use your name when posting to newsgroups.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

[famdamly]

Can't you just put borders on real quick.? It prints those no problem.

[GRIDLINES IN EXCEL]

Nope, it doesn't print any line any where no matter where you check it. No
borders, no gridlines. Nothing.

"famdamly" wrote:

>
> Can't you just put borders on real quick.? It prints those no problem.
>
>
> --
> famdamly
> ------------------------------------------------------------------------
> famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
> View this thread: http://www.excelforum.com/showthread...hreadid=489995
>
>