In Excel, when you open a workbook, you can see there are gridlines (light grey color lines) that make the cells visible. In this tutorial, we are going to learn to deal with these gridlines.
Remove Gridlines in Excel
- You need to go to the “View Tab” in the ribbon.
- From there, go to the “Show” group on it.
- Next, there’s a gridline checkbox there.
- Untick the check box to remove the gridlines from the workbook.
If you want to show the gridlines back again you just need to tick the check box again, but you want to also hide and unhide gridlines from the “Page Layout” tab, under the gridlines group of options.
And there’s one more way that you can find in the Excel options. Go to the File Tab → Excel Options → Advanced → Display Options for the Worksheets → Untick the “Show Gridlines’.
Note: When you use any of the above options to remove the gridlines that will only apply to the active worksheet, not on the entire workbook. But if you want to remove or add gridlines from multiple worksheets you can select a group of a worksheet and then untick the gridline option.
Keyboard Shortcut for Gridlines in Excel
In the same way, you can hide and show gridlines to get using the following shortcut key. The following shortcut key uses the option from the “View” tab.
Alt → W → V → G
Print Gridlines in Excel
When you take a printout of the worksheet you won’t find the gridlines there on the print. But you activate the printing of the gridlines.
- Go to the “Page Layout” tab and navigate to the “Sheets Options” group.
- Next, you’ll find the options gridlines there.
- From there’s tick mark the second check box “Print”.
Note: Once you activate the printing of the gridlines, Excel will only print the gridlines for the used range (cells where you have content). Just like the following:
Change Gridline Color
By default, gridlines have a lite grey color, but you can change the color of gridlines from the Excel options. Go to the File Tab → Excel Options → Advanced → Display Options for the Worksheets → Select the Gridline Color.
When you change the color of the gridlines, it also changes the color of the gridlines for the printout, if you are using a color printout.
- Formulas in Conditional Formatting
- AUTO FORMAT Option in Excel
- Apply Accounting Number Format in Excel
- Apply Background Color to a Cell or the Entire Sheet in Excel
- Add Page Number in Excel
- Apply Comma Style in Excel
- Apply Strikethrough in Excel
- Highlight Blank Cells in Excel
- Make Negative Numbers Red in Excel
- Cell Style (Title, Calculation, Total, Headings…) in Excel
- Change Date Format in Excel
- Highlight Alternate Rows in Excel with Color Shade
- Use Icon Sets in Excel (Conditional Formatting)
- Add Border in Excel
- Change Border Color in Excel
- Clear Formatting in Excel
- Copy Formatting in Excel
⇠ Back to Microsoft Excel Basics (Components, Parts, and Knowledge Notes)