Hide Gridlines In Excel
The gridlines in an Excel spreadsheet are only shown when looking at the worksheet electronically, and are not displayed when you send a worksheet to a printer.
However, sometimes you might want to hide gridlines in Excel worksheets when they are viewed electronically. Two different ways of doing this are described below.
De-Select the Gridlines Option
The display of the gridlines of an Excel worksheet are controlled by the Gridlines option, which is switched on by default.
Therefore, if you want to hide the gridlines in Excel, you simply need to deselect the option, which can be found as follows:
|
In Excel 2007 or Excel 2010:
|
|
|
In Excel 2003:
|
|
Fill Cells With a Background Color
A second way to hide gridlines in Excel is to color the cell backgrounds in white. This method can be used to hide the gridlines in specified cells, or for an entire worksheet.
To color the cell background, select the cells that you want to hide the gridlines on, and click the arrow at
the side of the Fill Color button
,
which is located on the formatting toolbar in Excel 2003, and on the 'Home' tab in Excel 2007 or Excel 2010.
This gives you a selection of colors that you can use to fill the background of the selected cells (see right). If you select white as the fill color, this will give the appearance of simply removing the gridlines on your worksheet.
