Missing Excel Cell Gridlines
 

I tried the reset-the-Cell-Styles-to-Normal technique but that resulted in the loss of the EXTENSIVE custom formatting on a 20 page document that I've developed over the years. So I looked for an alternative approach.

I noticed that Print Preview showed the global gridlines but they were not printing so the prime candidates were the printer driver or some printer setting.

On my Brother MFC-8840DN printer using the Brother Native driver on Win7 64-bit, the solution was to set Printer Optimizations = Disabled. (print Properties (printer) Paper/Quality Advanced Document Options Print Optimizations = Disabled).

The Page Setup Sheet Gridlines = enabled (checked) now print correctly in Excel 2007.

The document had always printed correctly on the MFC-8840DN under XP but something must have changed in the printer driver required for Win7 64-bit.

On Monday, September 21, 2009 10:52 PM tdp wrote:

I have Excel 2007 and all of the sudden am missing gridlines in Excel (and
also in Access query design view!!) In Excel, I have gridlines checked under
both Page LayoutSheet Options and ViewGridlines, I have no borders, and the
cells have no fill.

Where did my gridlines go??? Please help.

Thank you,
tdp


On Monday, September 21, 2009 11:07 PM Alan wrote:

Might not work mate, but try selecting the whole worksheet and removing all
borders. You might have inadvertantly bordered the whole sheet with white
borders. Unlikely, but you never know.

"tdp" wrote:


On Tuesday, September 22, 2009 10:36 AM Bob I wrote:

Did you perhaps inadvertently update your video card drivers? If that is
the case, navigate to the Display, Settings, Advanced, Adapter, Drivers
and then Rollback.

tdp wrote:


On Tuesday, September 22, 2009 12:53 PM Gord Dibben wrote:

Select all cells and format the background color to "no color" or
"Automatic"

You may have set them to "White"


Gord Dibben MS Excel MVP

wrote:


On Thursday, July 22, 2010 9:16 PM Ed Wanalista wrote:

Okay, well I had the same problem and here is the fix:



I selected the entire sheet (top left corner) and then right clicked a tab to "select all sheets". Then on the Home Tab (top), go to Styles, Cell Styles and under the "good, bad and neutral" header select "Normal"



Wow, who would have guessed!

Ed


On Thursday, July 22, 2010 9:22 PM Ed Wanalista wrote:

Had the same problem and figured it out...here is the fix:



I selected the entire sheet (from top left corner) and the selected a sheet tab (bottom) by using the right click to "select all sheets". The under the HOME tab, STYLES option, CELL STYLES button, I slected the header of "NORMAL" under the title "Normal, Bad, Neutral"!



Wow, who would have guessed it!

Ed


On Thursday, July 22, 2010 9:22 PM Ed Wanalista wrote:

Had the same problem and figured it out...here is the fix:



I selected the entire sheet (from top left corner) and the selected a sheet tab (bottom) by using the right click to "select all sheets". The under the HOME tab, STYLES option, CELL STYLES button, I slected the header of "NORMAL" under the title "Normal, Bad, Neutral"!



Wow, who would have guessed it!

Ed