Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Print a Worksheet in Excel With Gridlines

Date:2019-9-2 Author:Cordelia

When you print a worksheet in Excel, the gridlines will not be printed out together by default. Even if you manually add borders to the spreadsheet, the area outside of it will still be pure blank. So if you want to print a worksheet with gridlines in the selected area, you need to make some changes in advance.

First, select the range of cells you want to print out.

How to Print a Worksheet in Excel With Gridlines

Switch to Page Layout tab, click Print Area and choose Set Print Area in the menu.

How to Print a Worksheet in Excel With Gridlines

Then click Print Titles to change further settings.

How to Print a Worksheet in Excel With Gridlines

Check Gridlines in the Print section and hit OK.

How to Print a Worksheet in Excel With Gridlines

Switch to File tab – Print panel, you can check the preview here before printing it out. Now the gridlines are obviously included in the printed paper. If you don’t want it, just uncheck Gridlines in Print Titles.

How to Print a Worksheet in Excel With Gridlines

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *