This will bring you to Print Preview mode. Make sure the checkbox next to ‘Print’ is checked. You’ll find this in the top portion of your Excel window. 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.
