Print gridlines in a worksheet

When you print a worksheet or table without gridlines, it can sometimes be difficult to distinguish cell boundaries like in the print preview in this picture:

print view does not include gridlines

Printing gridlines is not supported in Excel Online but, you can mimic gridlines by applying borders, like in this picture:

Printing with broder

  1. To add a border around each cell, click and drag to select cells that you want included.

  2. On the Home tab, click Borders > All Borders.

    Tip    You can tell the areas without borders from areas that have borders by the darker lines.

    add a border to a table or data range

  3. For a print preview, click File > Print.

  4. Pick the print option you want to preview and click Print.

Print Options after clicking File > Print

  1. In the preview, check If the gridlines look the way you want it to, and then click Print.

Printing with broder

  1. Click the x to close preview and return to the worksheet.

Print gridlines from the Excel desktop application

If you have the Excel desktop application, click Open in Excel, and print gridlines in a worksheet.

Open in Excel button

For news about the latest Excel Online updates, visit the Microsoft Excel blog.

For the full suite of Office applications and services, try or buy it at Office.com.

Applies To: Excel Online



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language