How to Remove Grid lines in Excel

When you open the Excel sheet, you see a cross-section of rows and columns with grey-coloured lines that separate cells. Those gray-colored lines are known as gridlines in MS Excel. The grey color is the default color offered by Microsoft and one can change the color of the gridlines. These Guidelines can be helpful in reading data, but they might become distracting or undesirable when presenting or printing the final document.

Borders and Gridlines are two things that create confusion among users, Borders are customizable and one can change their color, type, and width but the same is not true for gridlines.  

Note: Gridlines are always applied on the whole worksheet or workbook, you can’t apply it on one cell or a set of cells. In this case, borders are applicable. 

In Excel, gridlines are the lines that separate the cells. They help you see where one cell starts and another one ends. Gridlines are like guides that make it easier to work with your data.

These lines are handy for things like calculations that involve lots of cells at once. They help you see which cells are part of the calculation. Gridlines also come in handy when you’re using macros, which are like shortcuts for doing tasks in Excel. Plus, when you want to make neat charts with numbers and labels, gridlines help you keep things organized and easy to read.

Removing gridlines will make your Excel worksheet look like a blank document as shown below:

• Using the view and page layout options
• Changing the background color
• Using Visual Basic for Applications (VBA)
• Removing gridlines for specific cells in Excel

Step 1: Go to the Page Layout tab in the ribbon

Step 2: In Sheet Options, uncheck the View option under Gridlines

Tip:  When multiple worksheets are selected, (Group) appears in the title bar of the worksheet. If you don’t want to remove gridlines from multiple sheets, click any unselected worksheet. If there is no unselected sheet then right-click the tab of a selected sheet, and then click Ungroup Sheets.

Gridlines can be easily shown if removed from the Excel worksheet. You can either have the gridline visible in the worksheet or hide it completely. There is no way to show this is in a specific area.

You can rather use borders to give a gridline effect in a specific area in the worksheet. Borders come with many options, one of them is it can make it look exactly like gridlines( by selecting a light grey color).

You can also change the color of the Gridlines in Excel, you have the feature to customize it to your preference. Follow the below steps to change the color of the Gridlines:

Step 1: Click on File in the Ribbon, and select Options

Step 2: Choose the Advanced Option from the left pane

Step 3: Scroll Down to the section Display options for this Worksheet

Find the “Gridline Color ” at the bottom of the section and select the desired color of the Gridlines.

Step 4: Click Ok

To get rid of gridlines for specific cells in Excel, you can make them look like they don’t have any lines by doing this:

Step 1: Pick the cells where you want to Remove the lines

Hold down the SHIFT key and click on the last cell in the group you want to affect. Or, you can just press CTRL+A to select everything in the whole sheet.

Step 2: Right-click on the Selected Cells

Step 3: Choose Format Cells from the menu that pops up

You can also press CTRL+1 to open the Format Cells box.

Step 4: Click on the Border Option

Now, pick the color white from the color choices.

Step 5: Make sure to check both the Outline and Inside boxes

Step 6: Click OK

Step 7: Preview the Result

By doing this, you’ll make those cells appear as if they have no gridlines.

Things to Remember

• These changes will affect only the gridline color of the particular (Active) Worksheet. You can also select multiple sheets by holding the Control key and clicking on their tabs. This will put the workbook in Group Mode, as indicated at the top of the workbook where the name is displayed. After making these changes, the gridlines will be applied to all the worksheets.
• Don’t forget to Ungroup the sheets(right-click on the tab and select “Ungroup”) if you don’t want to work with individual sheets separately and not on multiple sheets.
• Changing the Gridline color doesn’t alter the default color. When you insert the new worksheet it should show the original grey color gridlines.

To disable gridlines in Excel automatically using Visual Basic for Applications (VBA), you can follow these steps:

Step 1: Enable the Developer Tab

Go to the “File” menu and choose “Excel Options.”

Select “Customize Ribbons.”

Check the “Developer” box.

Click “OK” to add the Developer tab to your Excel ribbon.

Step 2: Insert a VBA Module

Click the “Developer” tab.

On the far left side, click “Visual Basic.”

In the Project Explorer, right-click the “VBAProject” with your workbook’s filename.

Choose “Insert” from the dropdown menu and then select “Module.”

Step 3: Insert or Paste Your VBA Code

Type or paste your VBA code into the module. You can copy code from external sources as Excel allows pasting code from the internet.

Add a Command Button

Step 4: Return to the Excel document

Click the “Developer” tab again.

Select “Insert,” and under ActiveX Controls, choose “Command Button.”

Double-click the command button to create it.

In the dialog box that appears, type or paste your VBA code, then close it.

Step 5: Run the Macro

Click the “Macros” button in the Developer tab.

Select your macro (in this case, the one that hides gridlines).

Click “Run” to execute the code. This code will hide the gridlines throughout the workbook.

Step 6: Preview the Result

By default, the gridlines in Excel are not printed when you print a worksheet. But if you want the gridlines to be printed, follow the below steps :

Step 1: Go to the Page Layout tab in Exel

Step 2: Find the Gridlines section and check the Print Checkbox

In the Sheet Options group, find the Gridlines section and check the Print Checkbox

Step 3: Now the Gridlines will be Printed on Printing the Worksheet

Note: Gridlines are not printed by default, borders around cells are always printed, and cell borders can be used as an alternative if you want the visible lines in your printed documents.

How do I get rid of the Grid in Excel?

To remove the gridlines in Excel:

Step 1: Open your Excel file.

Step 2: Go to the “View” tab at the top.

Step 3: In the “Show” group, you’ll see a “Gridlines” checkbox. Click it to toggle the gridlines on or off.

Step 4: If the checkbox is checked, it means gridlines are showing, and clicking it will hide them. If it’s unchecked, clicking it will show the gridlines.

That’s all you need to do to control the gridlines in Excel.

What is the Shortcut to Remove Grid lines in Excel?

To hide gridlines in Excel using a keyboard shortcut, you can press “Alt + W,” then press “G.” This combination will turn off the display of gridlines. If you want to show them again, you can repeat the same steps.

How do I remove gridlines from a table?

To get rid of the gridlines in a table in Excel:

Step 1: Click anywhere inside the table to select it.

Step 2: Now, look at the top of Excel. You should see a tab called “Table Design.” If you don’t see it, make sure you’re inside the table.

Step 3: Inside the “Table Design” tab, there’s a group called “Table Styles.”

Step 4: Click on the dropdown arrow next to “Borders” in the “Table Styles” group.

Step 5: From the options that appear, choose “No Border.”

This will remove the gridlines from your table while keeping your data intact. If you ever want to bring back the gridlines, you can repeat these steps and select a different border style or the default border style for your table.

How do I get rid of the grid on my screen?

To remove gridlines from your screen, you may be referring to gridlines on your desktop background or within certain applications. Here’s how to do it:

For Windows

Step 1: Right-click on your desktop (any empty area).

Step 2: Choose “Personalize” from the menu.

Step 3: In the Personalization settings, click “Background” on the left.

Step 4: Select a different background image without gridlines, or turn off the “Show desktop background” option for a plain color background.

For macOS

Step 1: Click the Apple menu in the top-left corner.

Step 2: Go to “System Preferences.”

Step 3: Select “Desktop & Screen Saver.”

Step 4: Choose a new desktop picture without gridlines.

For Applications (e.g., Excel, Word)

If you mean gridlines within specific applications:

In Microsoft Excel, follow the steps mentioned earlier to hide gridlines within Excel sheets.

In Microsoft Word, you can hide gridlines in a table by selecting the table, going to the “Table Design” tab, and choosing “Borders” then “No Border.”

If you’re dealing with gridlines in a specific application or situation not covered here, please provide more details for further assistance

How to remove gridlines from my entire Excel Workbook?

To remove Gridlines from the entire workbook Follow the below steps:

Step 1: To select the entire sheet click on the box at the top-left corner of the workbook.

Step 2: Go to the view tab in the Ribbon

Step 3: Find the “Show” group and uncheck the “Gridlines” option. This will remove gridlines for the entire workbook.

How to remove gridlines from only specific worksheets in my Excel File?

You can remove Gridlines from specific worksheets in an Excel file by selecting those worksheets individually and turning off the gridlines for each one.

How to set a custom gridline color for future worksheets?

Follow the below steps to custom gridlines color for your Excel worksheets:

Step 1: Go to the “File” and select “Options”.

Step 2: Choose “Advanced” from the left pane.

Step 3: Scroll down to the “Display options for those worksheets” section.

Step 4: Now select the gridline color as per your need.

Step 5: Click “Ok” to apply changes.

Will removing gridlines affect cell borders in my Excel Worksheet?

No, Removing gridlines in Excel won’t affect cell borders. Cell borders and gridlines are separate formatting options in Excel. After adding the cell borders to your worksheet, they will remain unaffected when you remove the gridlines.