In the menu, go to File > Print (or use the keyboard shortcut CTRL + P).ģ.
Select a range of cells for which you want to print gridlines (in this example, A1:E10).Ģ.
If you want to print the gridline on a blank sheet in Google Sheets, follow these steps:ġ. Print Gridlines on a Blank Sheet in Google Sheets To print without gridlines, you need to print the document and check the box that says No gridlines and apply it to all. If you populate some cells in the selected print area, again all cells (blank and populated) will be printed with gridlines. Finally, if you go again to File > Print, you’ll see in Print Preview that the selected area will be printed with gridlines. To do this, select a range of cells and in the Ribbon, go to Page Layout > Print Area > Set Print Area.Ĥ. In the Page Setup window, go to the Sheet tab, check Gridlines in the Print section, and click OK.ģ. This will open the page setup dialogue box. Click on Preview and then click on Page Setup. This is how your worksheet would look like in print preview. In the Ribbon, go to Page Layout > Page Setup (in the bottom right corner of the Page Setup section).Ģ. Open the spreadsheet or worksheet you want to print with gridlines or borders. To print gridlines on an empty sheet, follow these steps:ġ. Not sure why this one is and the others are not. In so far as to the good printing office version, yes the box is unchecked by default. However, when the next file is generated it automatically resets the box with a check. If you go to File > Print (or use the keyboard shortcut CTRL + P), you’ll see that there is no print preview, as Excel considers a sheet without any value a blank sheet. Lockout - Yes we can un-check the gridline box and when we print it does not print the gridlines.
In this tutorial, you will learn how to print gridlines on a blank sheet in Excel and Google Sheets.īy default, Excel won’t print anything if the sheet is completely blank.