After years of use, Excel now will not print gridlines. Ideas?

[Guest]

Gridline option is checked.
Color set to automatic.
But suddenly nothing seems to work to force the printer to display the
gridlines (after years of use).
Product = Office Professional 2003, Windows XP.

 

[Guest]

gridlines ? Prnter is for printing while excel can display..maybe some
conflict on the printer and excel option ticks..!!! You dont mention if the
printer is new. Is this based on *after years of use * of same excel And
printer?

 

[JP]

1. Ctrl-A
2. Click the 'paint bucket' icon and select 'no fill'

Still no gridlines?


--JP

 

[Gord Dibben]

See inline...........

Gridline option is checked.

Where is this checked? Must be checked In File>Page Setup>Sheet for printing.

Color set to automatic.

Where is this set? There is no "automatic" setting for color in Print
Setup>Sheet.

Maybe you have Draft Quality checked in Page Setup>Sheet?

But suddenly nothing seems to work to force the printer to display the
gridlines (after years of use).
Product = Office Professional 2003, Windows XP.

Gord Dibben MS Excel MVP

 

[Guest]

First, a thanks to all here.

More detail:
1. old printer (H-P Deskjet 820Cse) that's been in use 15+ years
2. can't recall when gridlines stopped printing but it is annoying.
3. CTRL-A doesn't work JP -- paint bucket already had "no fill" selected
4. The "automatic" color setting is what is recommended for gridlines. It
is under Tools/Options/View. "Gridlines" are checked in that window and
"Automatic" selected.
5. Tried going to "black" under the color setting -- that massively
confused the printer.
6. Tried a new color cartridge (knowing that some of the inks were low) --
still no joy.
7. For years I've also used a baseball box score sheet called Masscore.xls.
It prints fine -- it is just a new spreadsheet that isn't printing correctly.

HERE'S WHAT WORKED: deselect "Draft Quality" under Page Setup/Sheet.
NOTE: this is not the same as Print/Properties/Paper-Quality. Gord -- I'd
seen your note but confused the two control panels.

Best regards,

Omnivorous