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.

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?


"Omnivorous" wrote:

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.

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

Still no gridlines?


--JP

On Nov 5, 8:09 pm, Omnivorous
wrote:
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.

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

On Mon, 5 Nov 2007 17:09:00 -0800, Omnivorous
wrote:

Gridline option is checked.

Where is this checked? Must be checked In FilePage SetupSheet for printing.

Color set to automatic.

Where is this set? There is no "automatic" setting for color in Print
SetupSheet.

Maybe you have Draft Quality checked in Page SetupSheet?

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

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