How to print gridlines?

[OldManDon]

I have read the "help" instructions, the Page Setup box for gridlines is
checked; the Tools/Options box for gridlines is checked. Gridlines appear
on the worksheet, but not in Print Preview; no solid outline appears on the
worksheet. I think I've done this OK before. What am I missing?

 

[George Gee]

Maybe add some text to the worksheet!
I don't think you can print a blank sheet showing gridlines.

George Gee

 

[Gord Dibben]

Maybe your page setup>sheet is set for "draft quality"?

Disable that setting.

Or your gridlines are colored and you have "Black and White" set?


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Technically there is nothing wrong with what you are describing.

Try printing the worksheet even if the grid lines don't appear in page
setup, sometimes monitor resolution or printer driver issues cause gridlines
not to display in pp.