Show or Hide Gridlines in Excel Worksheets (+ Shortcuts)
by Avantix Learning Team | Updated October 15, 2023
Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows)
You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By default, gridlines are displayed but do not print. Gridlines are applied to entire worksheets or workbooks, not to specific cells. If you show or hide gridlines on one worksheet, it doesn't affect other sheets in the same workbook.
Borders and gridlines are two different things. Borders print by default and gridlines do not. You can't change the thickness or some other attributes of gridlines but you can change the thickness and style of borders and apply them to specific cells.
Gridlines may disappear for specific cells if you apply a fill color to cells. In this case, if you want to view or print gridlines, you need to remove the fill color from the selected cells. To remove fill color, select the cells with the fill color you want to remove, click the arrow next to Fill Color on the Home tab in the Ribbon (in the Font group) and select No Fill (not white).
In this article, we'll review how to:
- Hide or remove gridlines
- Show gridlines
- Show or hide gridlines using a keyboard shortcut
- Change the color of gridlines
Recommended article: How to Merge Cells in Excel (4 Ways)
Do you want to learn more about Excel? Check out our online (virtual classroom) or in-person Excel courses >
Hide or remove gridlines
To hide or remove gridlines:
- Select the worksheet with the gridlines you want to remove by clicking the sheet tab at the bottom of the Excel workbook. If you want to remove gridlines on multiple sheets, click the first sheet tab and Shift-click the last sheet tab. If you Ctrl-click sheet tabs, you can select non-contiguous sheets.
- Click the View tab in the Ribbon.
- Uncheck or deselect Gridlines in the Show group.
- If you have selected multiple sheets, click any unselected worksheet to exit the grouped state. If no unselected sheet is visible, right-click the tab of a selected sheet and then select Ungroup Sheets from the drop-down menu.
Show gridlines appears in the Show group in the View tab in the Ribbon:
Show gridlines
To show gridlines:
- Select the worksheet with the gridlines you want to show by clicking the sheet tab at the bottom of the Excel workbook. If you want to show gridlines on multiple sheets, click the first sheet tab and Shift-click the last sheet tab. If you Ctrl-click sheet tabs, you can select non-contiguous sheets.
- Click the View tab in the Ribbon.
- Check or select Gridlines in the Show group. A check mark should appear.
- If you have selected multiple sheets, click any unselected worksheet to exit the grouped state. If no unselected sheet is visible, right-click the tab of a selected sheet and then select Ungroup Sheets from the drop-down menu.
- Show or hide gridlines using a keyboard shortcut
Show or hide gridlines using a keyboard shortcut
To show or hide gridlines using a keyboard shortcut:
- Select one or more worksheets.
- Press Alt > W > V > G (press Alt then W then V then G). This will show gridlines if they are hidden or hide gridlines if they are showing. Don't forget to ungroup the sheets if you have selected multiple worksheets.
Change the color of gridlines
By default, gridlines are displayed in worksheets using a default color (automatic).
To change the color of gridlines:
- Click the File tab in the Ribbon.
- Click Options. A dialog box appears.
- Click Advanced in the categories on the left.
- In the Display options for the worksheet section, ensure Gridlines is checked.
- Click Gridline color. A drop-down menu appears.
- Select the color you want.
- Click OK. The color of gridlines will change for the selected worksheets.
The Excel Options dialog box appears as follows with gridline color options:
If a user has made gridlines white, other users will typically not recognize that gridline colors have been changed so white is not a good choice.
Subscribe to get more articles like this one
Did you find this article helpful? If you would like to receive new articles, JOIN our email list.
More resources
How to Remove Duplicates in Excel (3 Easy Ways)
How to Lock Cells in Excel (Protect Formulas and Data)
How to Combine First and Last Name in Excel (5 Ways)
How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)
How to Replace Blank Cells in Excel with Zeros (0), Dashes (-) or Other Values
Related courses
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Introduction to Power Query to Get and Transform Data
Microsoft Excel: New and Essential Features and Functions in Excel 365
Microsoft Excel: Introduction to Visual Basic for Applications (VBA)
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Copyright 2024 Avantix® Learning
You may also like
What is Power Query in Excel?
Power Query in Excel is a powerful data transformation tool that allows you to import data from many different sources and then extract, clean, and transform the data. You will then be able to load the data into Excel or Power BI and perform further data analysis. With Power Query (also known as Get & Transform), you can set up a query once and then refresh it when new data is added. Power Query can import and clean millions of rows of data.
How to Stop or Control Green Error Checking Markers in Excel
In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.
Excel Shortcuts to Zoom In and Out in Your Worksheets (4 Shortcuts)
There are several mouse and keyboard shortcuts you can use to zoom in and out in Excel worksheets. Some of these shortcuts are built-in and others can be created by customizing Excel Options.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca