Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Hide and Restore Gridlines in Microsoft Excel

Date:2019-8-13 Author:Olivia

When working with excel, sometimes you may want to hide the gridlines before printing the sheet, or the sheet you received have no gridlines which should be restored. Here I’d like to give a simple guide of these two cases.

First, click File in the upper left corner.

How to Hide and Restore Gridlines in Microsoft Excel

Next, click Options in the bottom left corner.

How to Hide and Restore Gridlines in Microsoft Excel

When the Excel Options pop-up window appears, select Advanced and find Display options for this worksheet, uncheck the box of Show gridlines.

How to Hide and Restore Gridlines in Microsoft Excel

Simply click OK and all gridlines have been hidden.

How to Hide and Restore Gridlines in Microsoft Excel

Note: if you want to restore the gridlines, just check the box of Show gridlines and click OK.

How to Hide and Restore Gridlines in Microsoft Excel

How to Hide and Restore Gridlines in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *