In the print options section on the right side, choose Selected cells (A1:E10) under Print, expand Formatting and check Show gridlines, and click Next.Īs a result, you can see in the print preview, that gridlines will be printed, although the selected cells are blank. 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 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.ģ. In the Ribbon, go to Page Layout > Page Setup (in the bottom right corner of the Page Setup section).Ģ. To print gridlines on an empty sheet, follow these steps:ġ. 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.
Gridlines not printing in excel 2016 how to#
If you want to hide the gridlines by using a macro then you can use the below code.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. Method 4: Hide Spreadsheet Gridlines using a VBA Script You can use the “Alt + WVG” key combination to hide the excel grid bars. If you are someone who loves to see a keyboard as compared to a mouse then here is the shortcut key for you. Method 3: Hiding Gridlines by Using Excel Shortcut
![gridlines not printing in excel 2016 gridlines not printing in excel 2016](https://i.ytimg.com/vi/MZoh5CPx52U/maxresdefault.jpg)
Alternatively you can also click the little triangle icon under the “Name box”.
![gridlines not printing in excel 2016 gridlines not printing in excel 2016](https://i.ytimg.com/vi/LT40FQeT0XY/maxresdefault.jpg)
They help you to distinguish between cell boundaries.ģ. They make it easier for you to align text or objects by giving you a visual cue.Ģ. Gridlines are the faint lines on your spreadsheet that help you to distinguish the cell boundaries.ġ.
![gridlines not printing in excel 2016 gridlines not printing in excel 2016](http://damerqc.weebly.com/uploads/1/2/7/4/127439285/842704611_orig.jpg)