In Excel, the Gridlines are the faint lines of gray that you can see around the worksheet’s cells. These grid lines allow the differentiation of the cells, and reading the data become more effortless.
Avoid being confused about borders and gridlines.
On the whole worksheet, you can see the gridlines as you can apply borders on a selected part of the worksheet or the entire worksheet.
It can be possible for you to have the border settings changed, like the style, color, and width. However, when it comes to gridlines, you may only have limited options if you want to change the gridlines’ appearance.
Our Tutorial Will Be Covering the Following:
- How You Can Have Gridlines Removed in Excel Worksheets
- Ways You Can Use Excel When Working with Gridlines
- Changing the Excel File’s Gridline Colors
- Ways You Can Have Gridlines Shown on a Certain Area of the Worksheet
- Having Excel Gridlines Printed Out
- How to Work with Excel’s Gridlines
With our tutorial, you will learn about the following:
- Ways you can remove the gridlines from the whole worksheet.
- How you can show a specific worksheet area’s gridlines.
- How you can have the gridlines’ color changed.
- How to have the gridlines printed out.
Ways you can remove the gridlines from the whole worksheet.
By default, you can always see the gridlines in the Excel worksheet. With these steps, you can have the gridlines removed from your worksheet:
- Go to the tab on Page Layout.
- In the group Sheet Options, check within Gridlines, and have the View checkbox unchecked.
How to Remove Gridlines in Excel – View Gridlines
Allow the gridlines to get removed with this. Here is a list of the things that you have to remember whenever you tinker with the gridlines:
- Whenever you remove the gridlines, they will get removed from the whole worksheet. That setting can be specific to every worksheet. As you have the gridlines removed from a worksheet, it can still become visible on every other worksheet.
- Use the ALT + WVG keyboard shortcut. Hold the ALT key and have the letters W, V, and G entered. That shortcut will have the gridlines removed if they are visible, or else they will become visible.
- Whenever you want to have the gridlines removed from all of the worksheets in just one go, choose the worksheets by pressing the Control Key and selecting the tabs so you can have the sheets grouped. You will see the workbook in Group Mode at the top part of the workbook, where the name gets displayed. You can then have the gridlines view setting changed and have it applied to every worksheet. Make sure to have the sheets ungrouped by right-clicking on the tab and choosing to ungroup. If you don’t do this, the changes that you do in the existing sheet will also get reflected in every worksheet.
- It can be possible for the gridlines to be removed when you apply a background fill to the worksheet’s cells. Whenever you can see the gridlines and use a specific area with fill color, you will see the gridlines disappear as it gets taken over by the fill color. Because of that, whenever you apply the fill color to the whole worksheet, you won’t see the gridlines. If you want the gridlines to become visible, note that you need to have the fill color removed.
- Gridlines don’t get printed as default.
How you can show a specific worksheet area’s gridlines
When it comes to Excel, it can be possible to have the gridline hidden completely or seen in the whole worksheet. However, there is no specific area where you can show this.
Yet, it can be possible to have borders used to provide a specific area in the worksheet with a gridline effect. Many options can come with it that can make it appear exactly similar to gridlines by choosing a color in light gray.
Borders can always get printed, unlike gridlines.
How you can have the gridlines’ color changed
In your Excel worksheets, you may select a different color for your gridline.
These are the things that you need to do to set the default color:
- Go to File and choose Options.
- In the dialogue box of Excel Options, choose the left pane’s Advanced option.
- Scroll down until you get to the section ‘Display options for this worksheet.’
- The section’s bottom part has the drop-down use the Gridline Color so you can choose the gridline’s color.
- Choose OK.
- Make sure that the sheets are ungrouped by right-clicking on the tab and choosing to ungroup. Failure to do this will make all of the sheets reflect the changes you do on the existing worksheet.
- It cannot change the color by default. When you have a new workbook opened or a new worksheet inserted, it can still show the gridlines with a light gray hue.
- It will allow the change of the gridline color of your actively chosen worksheets only. Whenever you want the whole worksheet’s gridline color to change, select the worksheets by pressing on the Control Key and selecting the tabs. You will notice that the workbook is in Group Mode. You can see this at the top of the workbook, where the name gets displayed. Have the gridlines’ color changed so it can apply to every worksheet.
How to have the gridlines printed out
By default, Excel’s gridlines cannot get printed. Whenever you want to include the gridlines in the printouts, you need to make these changes:
- Go to the tab Page LayoutGo to the Page Layout tab.
- Inside Gridlines, put a check on the Print checkbox. Sheet Options group, within Gridlines, check the Print checkbox.
Even if the gridlines don’t get printed as default, the borders always get printed out.