Gridlines In Excel

Gridlines in Excel are the partition lines that divide and differentiate cells from each other in a worksheet. The gridlines are a little lighter in visibility compared to the border lines.

The Excel Gridlines are available in the “Page Layout” and the “View” tab. We must check the checkbox to activate gridlines and uncheck it to deactivate them.

For example, a worksheet with and without gridlines are shown in the images below.

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

• Gridlines are the light grey lines that separate the cells, lines, and columns on a spreadsheet, normally utilized in computational programming for tracking/keeping the records or information. For example, MS Excel and Google sheets widely use gridlines.
• MS Excel uses gridlines to separate the data in a cell because it contains data in rows and columns that help to organize and categorize them. By using gridlines, we can make the data table as required.

Let us now consider,

• How to Add Gridlines in Excel Worksheet?
• How to Remove Gridlines from Entire Worksheet?
• How to Hide Gridlines from the Specific or Particular Cell?
• How to Print Excel Sheet with Gridlines?

• Step 1: We must first select the required data or the whole workbook. Then, we can use the shortcut in excel, “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.

The steps to hide gridlines from the specific or particular cell are as follows:

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

• Step 2: Right-click 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, as shown below.

The steps to print Excel sheets with gridlines are as follows:

• 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 excel checkbox.

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

• Gridlines help us differentiate between cells.
• We can hide or enable the option of a grid line in the toolbar.
• It is very convenient to show the gridlines because it helps us organize the data.

• While taking the printout of the Excel spreadsheet, we cannot print gridlines.
• The gridlines are too light in color, so people who are color blind will not be able to see the color and identify.
• The gridlines cannot be customized unless we add borders to them.

• To make Excel show/hide gridlines in two or more sheets, press and hold the “Ctrl” key and click on the “Sheet” tabs. Now, we can apply certain changes to all the selected worksheets.
• We must remove the gridlines once our work is over because we might sometimes get confused while hiding the gridlines.
• 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.