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.
Instructions on how to delete gridlines in Excel Picture 1
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.
Instructions on how to delete gridlines in Excel Picture 2
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.
Instructions on how to delete gridlines in Excel Picture 3
Method 2:
One way to delete the grid lines is to open the File ribbon on the toolbar.
Instructions on how to delete gridlines in Excel Picture 4
Next you open the Options item in the File list just displayed.
Instructions on how to delete gridlines in Excel Picture 5
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.
Instructions on how to delete gridlines in Excel Picture 6
Finally click OK to confirm the changes have been installed. Then all redundant lines of Excel worksheet will be deleted.
Instructions on how to delete gridlines in Excel Picture 7
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).
Instructions on how to delete gridlines in Excel Picture 8
The resulting array you selected will be filled with white and no visible gridlines.
Instructions on how to delete gridlines in Excel Picture 9
To remove the color, restore the grid, highlight the location, click Shading, and select the No Fill line .
Instructions on how to delete gridlines in Excel Picture 10
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
May be interested
How to cut photos from PDF to Word
How to rotate a table in Word (Rotate a table 90 degrees in Word)
How to lock PDF files from editing
How to embed fonts in PowerPoint so that they don't have font errors when opening on other devices
How to create GIF animations with PowerPoint
How to insert Excel into CAD quickly and correctly