Once we click on it, it will take us to advance the page setup option, from where we can add or make changes in the existing page setup, as shown below. For improvising further in Print Gridlines, go to File menu > Print > Page Setup, as shown in the below screenshot. We can also check with short cut keys of Ctrl + P, which will directly take the use to the print option, which is given under the File menu. Instead of putting gridlines for each table, we can have Print Gridlines enables, which automatically gridlines in all sheets, which are ready to get printed. We will see the current sheet will be covered with the gridlines as shown in the below screenshot.

Then go to the File menu and click on Print. Once gridlines box in check with the tick. Go Page Layout menu and check the box of print under sheet option for gridlines. Now, for printing gridlines, follow the same path which is given above. As we can see in the below screenshot, we have not created any border or table.

Here we have a sample data of some part numbers which were sold in a month in the different region. To access the Gridlines option, go to the Page Layout menu and check the Print box under sheet options as shown in the below screenshot. Excel functions, formula, charts, formatting creating excel dashboard & others Examples to Print Gridlines in Excel

Hide print lines excel 2016