Here’s how to add gridlines to your page directly from Print mode: If your page is already set to print and you see from the preview on the right-hand side that the page does not show any gridlines, then you can directly reach the Page Setup dialog box from there. With this second method (of using the Page Setup dialog box), you also get access to many other options that you may want to use while printing your work (such as repeating the headers or changing the print layout or print row numbers) Method 3: Printing Guidelines from Print Preview Mode
If all you want to do is enable printing of the gridlines, use the first method (it’s faster). Now, you must be wondering why you should use this Page Setup dialog box method instead of the first method, where you can simply check the box in the ribbon itself and then print with gridlines. If you like how it looks, you can directly print from here.
Here are the steps to add gridlines to your page using this method: The easiest and quickest way to add gridlines to your printouts is using the ‘ Sheet Options’ group. Method 1: Printing Gridlines using Sheet Options So, let us see three ways to make sure the gridlines get printed along with the data. It gets even harder when you have larger datasets with multiple rows of data. The printout does not have any grid lines separating the cells, so it is hard to tell the rows apart.