How to Remove Gridlines for Specific Cells in Excel
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.
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.
Contact Us