How you can Change, Remove, Print, and Add Gridlines in Excel

In Excel, there are faint lines of gray called the Gridlines.

You can see them around your worksheet’s cells.

These gridlines can allow you to easily differentiate among the cells so you can read the information.

However, we highly recommend that you avoid becoming confused with borders and gridlines.

You can apply borders to a whole worksheet or certain parts of the worksheet while you can only see gridlines over the entire worksheet.

It can be possible to have border settings changed like the style, width, color, etc.

However, when it comes to grid lines, there are limited options if you want their appearance to change.

Our Tutorial Will Cover the Following:

  • Working with Excel’s Gridlines
  • Ways You can Remove the Excel Worksheets’ Gridlines
  • How You can Show the Specific Area’s Gridlines in the worksheet
  • Ways You Can Change Excel File’s Gridline Colors
  • Excel’s Guidelines in Printing

Working with Excel’s Gridlines

Excel’s Gridlines

Our tutorial will allow you to learn about the following:

  • How to have the color of the gridlines changed.
  • How to have the gridlines printed out.
  • How to show the specific area of the worksheet’s gridlines.
  • How to have the gridlines removed from the whole worksheet

How to have the color of the gridlines changed

Change Excel Gridline Colors

In the worksheets of your Excel file, you may select another gridline color by doing this:

If you want to have the default color set, this is what you need to do:

  • Go to File and choose Options.
  • In the Options dialogue box of Excel, choose the Advanced option found in the left pane.
  • Scroll down until you get to this section: ‘Display options for this worksheet.’
  • Use the Gridline Color drop-down found at the bottom of the section and choose the color you want for the gridline.
  • Click on OK afterward.

Note:

  • Doing this can only change the selected or active worksheets’ gridline color. Whenever you want to have all of the worksheets’ gridline color changed, choose the worksheets by holding on to the Control Key and selecting the tabs. You will see that the workbook is in Group Mode. You can see this at the top of the workbook, as this is where they display the name. Have the color of the grid lines changed and apply it to all of the worksheets.
    • Make it a point to have the sheets ungrouped by right-clicking on the tab and choosing to ungroup. If you don’t do this, it will reflect all of the changes you do in your existing sheet in every worksheet.
  • It will not make changes to the default color. When you open another workbook or insert a new sheet again, it will still show the gridlines in a light gray hue.

Ways you can print out the gridlines

Print Gridlines

By default, Excel’s gridlines are not printed.

In case you also want to have those gridlines printed as well, you need to make the following changes:

  • Check out the Page Layout tab.
  • In the group Sheet Options, review Gridlines and put a check on the Print checkbox.

Since the gridlines don’t get printed by default, the borders always get printed

Ways You Can Remove the Excel Worksheets’ Gridlines

Excel Gridlines

By default, you can always see the Excel worksheet’s gridlines.

Here are the ways you can have these gridlines removed from your worksheet:

  • Check out the tab Page Layout.
  • In the group Sheet Options, go to Gridlines and have the View checkbox unchecked.

Doing this can have the gridlines removed from the Excel worksheet.

These are the things that you need to remember whenever you tinker with the gridlines:

  • Gridlines don’t get printed by default.
  • Having the gridlines removed would take it away from the whole worksheet. That setting may be specific to every worksheet. Whenever you have the gridlines removed from a worksheet, you can still see them on every other worksheet.
  • It can be possible for you to have the keyboard shortcut ALT + WVG used (Here, you hold the ALT key and enter the letters W, V, and G). With this shortcut, you can have the gridlines removed when it’s visible, or else it will do something so it will become visible.
  • Whenever you want to have the gridlines removed from every worksheet at a single go, choose the worksheets by pressing the Control Key and selecting the tabs (doing this can have the sheets grouped. At the top of the workbook, where you can see the name, you will see that the workbook is in a Group Mode. Have the view setting of the gridlines changed and apply it to every other worksheet. Make sure to have the sheets ungrouped by right-clicking on the tab and choosing to ungroup. Failure to do this will allow the changes you apply on the existing sheet to reflect on every worksheet.
  • It can also be possible to have the gridlines removed using the background fill to the worksheet’s cells. Whenever you can see the gridlines, have a fill color applied to a specific area, and you will notice the disappearance of the gridlines once the fill color takes over. Because of that, whenever you have the whole worksheet applied with the fill color, the gridlines will not become visible. Take note that you have to take away the fill color if you want the gridlines to become visible.

How to Show the specific area of the worksheet’s gridlines

Show Areas in Excel Gridlines

In Excel, it can be possible for you to hide the gridline or make it visible in the whole worksheet.

It may not be possible to have this shown in a particular area.

Yet, you can provide a gridline effect on a specific area by using the worksheet’s borders.

Many options can come with it that will allow you to make it appear similar to gridlines by choosing a light gray hue.

Take note that borders can always get printed, unlike gridlines.

Leave a Comment