On this submit, we’ll see how to hide the Gridlines in Microsoft Excel. The horizontal and vertical faint traces that characterize the boundaries and are used to distinguish cells on the worksheet are known as ‘Gridlines’. By default, gridlines are displayed in worksheets utilizing a colour that’s assigned by Excel.
How to hide Gridlines in Excel
If you don’t just like the default colour, you may change it to a colour of your alternative and even take away them. What are the advantages that Gridlines provide in a worksheet?
Firstly, they make your knowledge tables readable when they’re and not using a border and second, gridlines make it simpler for you to align textual content or objects. That stated, eradicating gridlines makes your worksheet look much more presentable. Do you have to want to take away the gridlines, listed below are the steps you may comply with.
We cowl right here 3 strategies to hide gridlines in Excel Worksheet.
1] Hide Gridlines in Excel utilizing Conventional Methodology
- Open Excel sheet
- Navigate to the “View” tab on the Excel ribbon
- Underneath it, seek for the Gridlines possibility in ‘Show’ part.
- When discovered, uncheck the “Gridlines” possibility and the gridlines can be hidden, immediately.
- Alternatively, you may select to hide the grid traces from “Page layout” and uncheck the Gridlines “View” possibility.
2] Take away Excel gridlines through the use of the shortcut key
For those who use Home windows shortcuts ceaselessly to carry out varied duties, right here’s one other for you. To hide gridlines in Excel worksheet utilizing a Home windows shortcut key. Press “Alt + W+V+G” key in mixture and see the magic work.
3] Hide Gridlines in Excel by altering background colour:
A quite simple method of hiding the gridlines in Excel is by altering their background colour in order that it matches the worksheet background.
To start, press Ctrl key + A in mixture to choose all of the rows and columns of the spreadsheet. Then, click on the “Fill Color” possibility and choose the white colour.
In case your discover for some motive your Excel Worksheet grid traces are invisible and don’t seem by default. You possibly can present them by urgent keys “Alt + WVG” or checking the ‘Gridlines’ possibility once more (highlighted in the primary methodology to make the gridlines clearly seen.
Take pleasure in a gridless Excel worksheet!
Learn subsequent: How to make Excel cells broaden to match Textual content mechanically.
