Windows News and info 15th Anniversary 2009-2024

Office 2019 / Office 2016 / Office 365 / Office 2011 for MAC => Office 365/ Dev. => Office 2013 => Topic started by: javajolt on December 07, 2013, 05:35:25 PM

Title: 3 Methods to Hide Gridlines in Excel
Post by: javajolt on December 07, 2013, 05:35:25 PM

The horizontal and vertical faint lines that represent the boundaries are used to distinguish cells on the worksheet are called ‘Gridlines’. By default, gridlines are displayed in worksheets using a color that is assigned by Excel.

(http://i40.tinypic.com/bikuo2.jpg)

Hide Gridlines in Excel

If you do not like the default color, you can change it to a color of your choice or even remove them. What are the benefits that Gridlines offer in a worksheet?

First, they make your data-tables readable when they are without a border and second, gridlines make it easier for you to align text or objects. That said, removing gridlines make your worksheet look a lot more presentable. Should you wish to remove the gridlines, here are the steps you can follow.

Here are 3 methods to hide gridlines in Excel Worksheet.

Hide Gridlines in Excel using Traditional Method

Navigate to the “View” tab on the Excel ribbon. Under it search for the Gridlines option in ‘Show’ section.

(http://i39.tinypic.com/b9dfd4.jpg)

Uncheck the “Gridlines” option and the gridlines will be hidden, instantly.

Alternatively, you can choose to hide the grid lines from “Page layout” and uncheck the Gridlines “View” option.

(http://i40.tinypic.com/313glkp.jpg)

Remove Excel gridlines by using the shortcut key

If you use Windows shortcuts frequently to perform various tasks, here’s another for you. To hide gridlines in Excel worksheet using a Windows shortcut key. Press “Alt + WVG” key in combination and see the magic work.

Hide Gridlines in Excel by changing background colour:

A very simple way of hiding the grid lines in Excel is by changing their background colour so that it matches the worksheet background.

To begin, press Ctrl key + A in combination to select all the rows and columns of the spreadsheet. Then, click the “Fill Color” option and select the white colour.

(http://i44.tinypic.com/33aumb4.jpg)

If you find for some reason your Excel Worksheet grid lines are invisible and do not appear by default. You can show them by pressing keys “Alt + WVG” or checking the ‘Gridlines’ option again (highlighted in the first method to make the gridlines clearly visible.

Enjoy a grid-less Excell worksheet!