What are the Gridlines in Excel?

Gridlines are little lines made of dots to divide cells from each other in a worksheet. The gridlines are a little faint in invisibility. However, they are available in the “Page Layout” tab. We must check a checkbox to activate gridlines and uncheck it to deactivate them.

Explained

It helps you define the boundary on each cell, which helps separate the data accordingly. Gridline enables you to categorize the data and organize it to split the data accordingly clearly.

#1 How to Add Gridlines in Excel Worksheet?

#2 How to Remove Gridlines from Entire Worksheet?

  • Step 1: We must first select the required data or the whole workbook. Then, we can use the shortcut in excelShortcut In ExcelAn Excel shortcut is a technique of performing a manual task in a quicker way.read more “Ctrl+A” to select the entire worksheet. Then, we must go to the “View” tab in the Excel toolbar. And then, uncheck the box “Gridlines” to remove the grid lines from the sheet.

  • Step 2: Once we uncheck the box, it will automatically hide all the gridlines from the spreadsheet.

#3 How to Hide Gridlines from the Specific or Particular Cell?

  • Step 1: We must first select the range of cells from which we want to remove the Excel gridlines.

  • Step 2: Right-click on the range we have selected and choose the “Format Cells” from the context menu, which shows in the dialog box.

  • Step 3: Go to the “Border” tab under the “Format Cells” tab.

  • Step 4: Select the white color and press the “Outline” and “Inside” buttons under the “Presets” option shown under the “Border” tab. Press “OK.”

  • Step 5: After clicking “OK,” it will hide the gridline from that particular range that we have selected.

#4 How to Print Excel Sheet with Gridlines?

  • Step 1: First, go to the “Page Layout” tab in the Excel toolbar to see the “Gridlines” option.

  • Step 2: In the “Sheet Options” group on the right-hand side, within the “Gridlines” option, check the Print excelPrint ExcelThe print feature in excel is used to print a sheet or any data. While we can print the entire worksheet at once, we also have the option of printing only a portion of it or a specific table.read more checkbox.

  • Step 3: Once we enable this option while printing the worksheet, we can see the gridlines. Take a look at the below-given screenshot.

Benefits

  • Gridlines can be customized according to the color, thickness, and pattern. We can hide or enable the option of a grid line in the toolbar.This option does not require additional settings.We can hide/unhide the Excel grid lines with one click.It is very convenient to show the gridlines because it helps us organize the data.

Drawbacks

  • While taking the printout of the Excel spreadsheet, we cannot print gridlines.The gridlines are too light in color.People who are color blind would not be able to see the color and identify.The gridlines cannot be customized.

Things to Remember

  • Suppose we want to make Excel show/hide gridlines in two or more sheets. Press and hold the “Ctrl” key and click on the “Sheet” tab (which is required) at the end of the Excel window. Now, we can apply certain changes to all the selected spreadsheets.If we want to hide or show the gridlines from the entire spreadsheet, uncheck the “Gridlines” option for hiding the lines and check the box to show the lines.We must remove the gridlines once our work is over because we sometimes get confused while hiding the gridlines.When we want to print the Excel workbook, ensure to use borders so that we can print it.We can also use a shortcut key on the keyboard and press “ALT+W+VG” to show or hide the gridlines.We can also remove/hide the gridlines by applying a background color “No fill” to the cells/selected range in the worksheet.

This article is a guide to Gridlines in Excel. Here, we discuss inserting and adding gridlines in Excel and practical examples. Also, we discuss how to remove and hide gridlines. You may learn more about Excel from the following articles: –

  • We must go to the “View” tab in the Excel toolbar. Check the box “Gridlines” to show the gridlines in the Excel sheet. On checking the box, we can see the gridlines on the workbook, as shown below.

  • Strikethrough Text in ExcelPrint Gridlines in ExcelHow to use Merge & Center in Excel?Excel Table Formats