Excel 2007 : grid lines disappeared!

**luckybugger** · 06-21-2009, 10:51 AM

Please help, the grid lines have disappeared from my work sheets in excel 2007. I have no idea how this has happened or how to rectify the problem. Hope somebody can help?

**shg** · 06-21-2009, 11:20 AM

Page Layout > Sheet Options

**daddylonglegs** · 06-21-2009, 11:25 AM

Don't know why it's in 2 places but there's also a "Gridlines" option on the "View" tab, under "Show/Hide"

**luckybugger** · 06-21-2009, 01:07 PM

Thanks for the reply from both you guys, but unfortunatley both answers haven't helped. The boxes marked "GRIDLINES" are ticked in both places! If anybody else has any other suggestions I would appreciate the help.

**shg** · 06-21-2009, 01:15 PM

Gridlines will only appear if the cells have no fill. Clear the fill.

**luckybugger** · 06-22-2009, 02:12 AM

Thanks again, but still no joy! I tried a repair installation as well but the work sheets still appear blank. Anymore idea's would be appreciated....

**Andy Pope** · 06-22-2009, 04:25 AM

Check the colour being used for gridlines

Office button > Excel Options > Advanced > Display setting for workbook > Gridline colour.

If that's not it you may want to post a workbook.

**luckybugger** · 06-23-2009, 07:44 AM

Thanks guys for all your help. Problem has been resolved. The problem was with a 22" lcd monitor that the computor is connected to. The monitor has 4 modes, Game, Text, Movie and Standard mode. The kids used the computor to play high graphic games and must have changed the settings on the monitor. If the monitor is not set on standard mode the Gridlines in excel for some reason dissapear.