How can I aded gridlines when I print in Excel?

  • Thread starter Thread starter Rita Kelly
  • Start date Start date
Rita.

Excel 2007. Page layout tab and check 'Print gridlines.
Excel 2003. File - page setup - sheet tab and select gridlines.

Mike
 
Hi Rita

From menu File>PageSetup>Sheet tab>check 'Gridlines'. This will apply grid
lines on the used range

If this post helps click Yes
 
Just to add...

If you've added fill colors to the worksheet, then the gridlines won't show up
in that area--on screen or on the paper.

You could either remove the fill color (don't just change the fill to white) or
add borders.
 

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

Similar Threads

Blank Sheet with Gridlines 11
Gridlines in Office 2007 1
Gridlines won't show up in excel 2007 6
Resume gridlines 6
gridlines in pivot table 1
Gridlines not printing?! 7
How to print (not) grid lines? 1
How do I print selected gridline color in Excel? 6

Back
Top