How To Add, Remove, And Print Gridlines In Excel

4.9 min read|Last Updated: March 29th, 2021|Categories: Excel|
table of content

Excel can help you read the data more clearly by organizing them in different cells. This is done by Excel gridlines, the horizontal and vertical gray lines that help you distinguish the spaces assigned to each cell on the Excel worksheet. Generally, when you open the Excel files, you see the grids, and you have control over these lines. In this post, we are going to teach you how to add, remove, and print gridlines in Excel.

How To Add Gridlines In Excel?

Method 1- Adding gridlines in Excel via Page Layout 

As mentioned earlier, the gridlines are visible in any Excel worksheet, by default. However, you may open a file and wouldn’t be able to see the grids because someone has hidden it before. In this case, you can easily add gridlines in Excel as follow: 

  1. Go to the Page Layout tab.
  2. Find Gridlines in the Sheet Options group. There are two options dedicated to gridlines and two for Headings, which are the numeric and alphabetic titles on the top and side of the worksheet.
  3. To add gridlines in Excel, easily select View by