Instructions on how to delete gridlines in Excel
The Excel interface is a spreadsheet with extended rows and columns. Normally in an Excel table presentation, you will want to remove the lines that are outside your worksheet array but don't know how to do it quickly. TipsMake.com will guide you how to delete Excel cell lines quickly.
1. Delete a series of gridlines in Excel
Let's take a look at the example below, we have a table occupies some area in the whole Excel worksheet, except the position with the table out, we will delete all open lines outside.
To do that, you can do in the following two ways:
Method 1:
Open the View ribbon on the toolbar, then select to uncheck the Gridlines line in the Show section .
As you can see, when you remove the check marks, the lines that are left out will immediately disappear.
Method 2:
One way to delete the grid lines is to open the File ribbon on the toolbar.
Next you open the Options item in the File list just displayed.
The Excel Options function window pane will open. You click open Advanced section of this function window pane.
Keep scrolling down to search for Display options for this worksheet .
You click to uncheck the box before Show gridlines in this section.
Finally click OK to confirm the changes have been installed. Then all redundant lines of Excel worksheet will be deleted.
2. Delete the grid lines in a certain area
To delete the grid line in a certain area, highlight the area you want to delete the grid line.
Next, open the Home ribbon on the toolbar, click the Shading icon located in the Font section of this ribbon.
Then you select white (or any other color can also create a rectangular array of colors without lines).
The resulting array you selected will be filled with white and no visible gridlines.
To remove the color, restore the grid, highlight the location, click Shading, and select the No Fill line .
Thank you for following the article TipsMake.com's Guide on how to delete gridlines, hope the article has given you all the necessary tips. Wish you can do it successfully.
You should read it
- Hide and show gridlines in Excel
- How to change gridlines color in Excel?
- How to add rows and delete rows in Excel
- Instructions to delete 0, hide 0 in Excel
- 8 How to delete blank rows in ExcelHow to delete blank rows in Excel
- How to delete, add columns in Excel
- How to delete photos in bulk in Excel
- This is a simple way to find and delete Hyperlink in Excel
- How to delete cells in Excel
- How to quickly delete multiple sheets in Excel
- How to delete quick recipe on Excel
- How to delete white pages in Excel
Maybe you are interested
6 Data Collecting Apps You Need to Delete for Better Privacy
How to Recover Deleted Contacts on iPhone - If you accidentally delete contacts....
Cannot Delete Volume drive D, what is the reason?
How to delete white space in a table in Word - Appears right below the data
How to delete Comment and Section Break in Word 2013, 2010, 2007, 2003
How to recover deleted photos on iPhone X, iPhone 11