If you want to hide the gridlines by using a macro then you can use the below code. 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.
![how to restore gridlines in excel worksheet how to restore gridlines in excel worksheet](https://www.lifewire.com/thmb/dNiJp1_7vCQKRq_i6HZP4XbMy6U=/1067x711/filters:no_upscale():max_bytes(150000):strip_icc()/exceloptions2-5cf58b1b2b8f43a18ac97c0bfe91352a.jpg)
Method 3: Hiding Gridlines by Using Excel Shortcut
#HOW TO RESTORE GRIDLINES IN EXCEL WORKSHEET HOW TO#
How to Bring the Gridlines Back if they are Already HiddenĪ spreadsheet contains cells and gridlines or grid bars represent the borders of these cells.
![how to restore gridlines in excel worksheet how to restore gridlines in excel worksheet](https://cdn.extendoffice.com/images/stories/doc-excel/show-gridlines/doc-show-gridlines-4.png)
Hide Gridlines While Printing the Sheet.Method 4: Hide Spreadsheet Gridlines using a VBA Script.Method 3: Hiding Gridlines by Using Excel Shortcut.To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon.
![how to restore gridlines in excel worksheet how to restore gridlines in excel worksheet](https://spreadsheeto.com/wp-content/uploads/2017/10/show-gridlines.png)
The drop-down contains the commands: Freeze Panes, Freeze Top Row and Freeze First. To set a single print area, select the cells. Gridlines - Toggles the display of gridlines on the active worksheet.