Excel Tip - Printing Gridlines

When printing a spreadsheet, Excel will not by default print the gridlines that you see on the Excel screen. Rather than having to apply numerous borders to the sheet, try this much simpler way of viewing and printing gridlines...

  • Within Print Preview, click Page Setup or alternatively, choose Page Setup from the Page Layout tab on the Ribbon
  • From the Page Setup dialog box, click the Sheet tab and select the check box next to Gridlines
  • Click OK

Pin it