Excel does not display gridlines, change gridline colors, print gridlines

When you use an Excel form to make a report, extra gridlines appear redundant, and in order to look good, we need to manually "delete" these gridlines. There are two ways to choose from your different needs:

"Scope of Application"

Method One: You want the gridlines for the entire worksheet to be displayed (apply to the current worksheet and change multiple worksheets multiple times)

Method Two: You only want to select some of the cells do not display gridlines, do not apply to the background color is not white

Method One: Implement with view options

"2003" click menu "Tools" → "Options" → "view" tab → "window options" → Cancel "grid line" before "√" can be;

"2007" Click the top left Corner "office Button" → "Excel Options" → "Advanced" → "show" big class → Cancel "show grid line" before "√" can be.

Method Two: Through the fill color implementation

Select the cells that you want to hide gridlines from, and fill the cells with white.

How do I change the gridline color with extension tip 1?

If you don't like to use traditional gray-black gridlines, you can change the gridline color by options as follows:

"2003" click menu "Tools" → "Options" → "View" tab at the bottom, there is a "grid line color," next to select the color you want;

"2007" Click the Office Button in the upper-left corner → excel options → advanced → show Big class → Select the gridline color you want under Show gridlines. Make sure that the "Show gridlines" is in front of the tick.

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

"Extended Tip 2" How do I print a network cable?

By default, Excel does not print gridlines on the worksheet. If you want gridlines to appear on the printed page, select the worksheet that you want to print. On the Page Layout tab, in the Sheet Options group, select the Print check box under gridlines. To print, press ctrl+p.