How to quickly show & hide gridlines in Excel 2007/2010?
Sometimes, gridlines may disappear from Microsoft Excel after some operations, which makes our work in spreadsheet inconveniently. The gridlines may be hidden in some situations. And this article will talk about how to quickly show & hide gridlines in Excel 2007/2010 when you want to show or hide gridlines.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. Read more...
Classic Menu for Office: Bring Classic Menus and Toolbars of Office 2003/XP/2000 Back to Office 2007, 2010 and 2013. Read more...
The gridlines will disappear if we uncheck the Gridlines in Microsoft Excel 2007/2010. In this situation there are two methods to show gridlines.
Method A: check gridlines option under View tab
Normally we can view the Gridline option in the Show group under View tab. After checking the Gridlines option, it will show the gridlines in spreadsheets.
Fig. 1 : Gridlines in Ribbon
Method B: show gridlines with Kutools for Excel
Kutools for Excel is a powerful tool collection for Microsoft Excel, which provides various tools to help us work easier in Microsoft Excel. Its Toggle Settings tool can help us turn on or off all kinds of setting from spreadsheets, including gridlines.
After clicking the "Kutools" >> "Toggle Settings" >> "Gridlines", it displays the Toggle Settings dialog box. See screenshot (Fig. 2).
Check the Grid Lines option, and click the Close button to save the settings, and then the gridlines will come out in spreadsheets.
Fig. 2 : Gridlines in Kutools for Excel
The Toggle Settings makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … etc. It will save your time in looking for these setting when you need to show or hide them.
Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.
The gridline does not show sometimes even we have checked the Gridlines option under View Tab. That is because you fill the cell range with white color, which hides the gridlines. Please correct it with following steps:
- Step 1: Go to the Font group under Home tab;
- Step 2: Click the Fill Color button;
- Step 3: Check the No Fill command item. See screenshot:
Fig. 3 : Remove Fill Color