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.
 
Back
Top