How to Remove Lines in Excel – Excel line or Gridlines is a delimiter between cells provided by default by Excel.
You can clearly see the difference between one cell and another and the position of the row or column, through these lines.
However, there are also some users who are not comfortable with the line, so they want to remove or delete it.
By removing the row, the worksheet will look better than before.
Can a line be removed in Excel and how? Of course, this line can be removed in various ways.
Well, here we will share some ways to remove lines in Excel that can be applied.
How to Remove Lines in Excel
1. How to Remove Lines in Excel in Excel Options
 |
| How to Remove Lines in Excel in Excel Options |
As for how to remove lines in Excel in Excel Options as follows:
- Please click File on the top left of your Excel file or click on Excel text on the top left of the screen for Mac users.
- Then click Options on the displayed options. For Mac users, you can click Preferences.
- Then click Advanced in the dialog box that appears. While Mac users can click View.
- Look for the Show Gridlines checkbox on the screen and then uncheck it with one click.
- Click OK and done.
2. How to Remove Lines in Excel via Tab View or Pag Layout
 |
| How to Remove Lines in Excel via Tab View or Pag Layout |
Meanwhile, how to remove lines in Excel via Tab View or Pag Layout as follows:
- Click the View or Page Layout tab on your Excel file first.
- Then remove the check mark in the Gridlines checkbox by clicking just once.
- If you want to display the line again, you just have to check the box.
- Finished.
3. How to Remove Lines in Excel with Merge Cells
 |
| How to Remove Lines in Excel with Merge Cells |
Merge Cell is one of the options that can be used to remove lines in Excel guys.
However, the cells that you remove the outline will merge if you use this method.
Therefore, it is recommended to use this method if the cell union is the shape you want from the delimited cell range.
- Find the cell range that will be delimited.
- Then click the Merge & Center button on the Home tab.
- Finished.
4. How to Remove Lines in Excel by Changing the Background Color
 |
| How to Remove Lines in Excel by Changing the Background Color |
Here’s how to get rid of lines in Excel by changing the workable background color:
- Highlight the cell range that will be delimited.
- If you want to remove all the lines on the worksheet that you have, please press Ctrl + A (Command + A for Mac).
- Then click the Dropdown Fill button on the Home tab.
- Then choose the color you want to use as the background for the cell range that was highlighted earlier (if you want the color to look the same as usual, just choose white).
- Finished.
5. How to Remove Lines in Excel with Shortcut Keys
 |
| How to Remove Lines in Excel with Shortcut Keys |
Eliminating lines in Excel using the Shortcut key can only be applied if you are using Windows OS guys.
- Press Alt key > W > V > G or you can also press Alt key > P > V > G.
- This shortcut is basically used to access the Gridlines checkbox in your Excel View/Page Layout tab guys.
The final word
Those are some ways that can be applied if you want to remove lines in Excel guys.
Although using different features or buttons, all methods will produce the same result, namely eliminating the lines guys.
