restoring gridlines

**Sebastian1942** · 12-31-2009, 08:02 AM

Years ago I created this worksheet and made the note that I could effectively make gridlines disappear by using a 'fill of clear'. Try as I might, I can't find a way to reverse that. Can anybody else ?

**ncmay** · 12-31-2009, 08:14 AM

Select all cells by right clicking the upper left hand corner.
Above the row numbers and to the left of the column letters.

Format Cells/Patterns/No Color

Make your zoom number larger

**martindwilson** · 12-31-2009, 08:25 AM

your zoom is 35% so you cant see them! just change it back to 100%

**scaffdog845** · 12-31-2009, 09:11 AM

Sebastian1942

If you are still using Excel 2003, a more effective way of not showing the gridlines would be to clikc Tools --> options then uncheck Gridlines at the bottom of the View tab.

In Excel 2007 click on the View Ribbon then uncheck Gridlines in the Show/Hide section.

Happy New Year!