Location: http://www.mvps.org/dmcritchie/excel/gridline.htm [View without Frames]

Gridlines and Borders

Location: http://www.mvps.org/dmcritchie/excel/gridline.htm A very frequent complaint is loss of gridlines in display or in printing.

Printing of gridlines:

Printing of gridlines: Tools, Options, View,
Gridlines (checked), color: automatic
(if you had white for color -- no gridlines)

Display of gridlines:

Display of gridlines: File, Page Setup, Sheet
Gridlines (checked)

Supress gridlines with VBA

Activewindow.displaygridlines=false

Formatting of interior or background color:

Formatting of interior or background color:
Select all cells, format, cells, patterns, Cell shading: no color
(white interior color will wipe out gridlines, but not borders)
When using Interior color in Conditional Formatting consider also including borders.

Formatting of borders:

Formatting of borders:
Select all cell, format, Cells, borders, automatic=black
(white borders -- no gridlines)

Color Palette -- the 56 Excel Colors

This page was introduced on June 17, 2000.

[My Excel Pages -- home] [INDEX to my site and the off-site pages I reference]
[Site Search -- Excel] [Go Back] [Return to TOP]