Excel 2007 Gridlines Disappeared

Clicking on an unused cell and copying it. Then highlighting the cell/cells then right click and select 'paste special' then select the radio button 'Formats' OK then ENTER solved the problem for me.
Thanks to G.McPherson and the rest



GMcPherso wrote:

When something like this happens to me and I can't pinpoint the cause, I'll
25-May-08

When something like this happens to me and I can't pinpoint the cause, I'll
find a nearby cell with similar formatting and paste its format to the
offending cells to restore the gridlines. Hope this is helpful.

Previous Posts In This Thread:

On Sunday, May 25, 2008 2:38 PM
Ade wrote:

Excel 2007 Gridlines Disappeared
The gridlines disappeared. I have confirmed background has "no color" and
all "show gridlines" are checked. I am out of options and think I may have
to uninstall the entire program and start over. Does anyone have any other
ideas?

On Sunday, May 25, 2008 2:43 PM
Ron de Bruin wrote:

Also in new worksheets/workbooks ?
Also in new worksheets/workbooks ?

If you want send me a workbook private and I look at it for you



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

On Sunday, May 25, 2008 4:31 PM
ShaneDevenshir wrote:

Hi Adel,1. Try choosing View, Show/Hide group, and check Gridlines.2.
Hi Adel,

1. Try choosing View, Show/Hide group, and check Gridlines.

2. There is another far less likely possibility - the gridline color has
been set to White under Office Button, Excel Options, Advanced, Gridline
Color.
--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Adel" wrote:

On Sunday, May 25, 2008 4:31 PM
tombin wrote:

just to recheck you have gone in options, selected gridlines and colour
just to recheck you have gone in options, selected gridlines and colour
automatic. Do you use macros and/or vba?

"Adel" wrote:

On Sunday, May 25, 2008 4:34 PM
GMcPherso wrote:

When something like this happens to me and I can't pinpoint the cause, I'll
When something like this happens to me and I can't pinpoint the cause, I'll
find a nearby cell with similar formatting and paste its format to the
offending cells to restore the gridlines. Hope this is helpful.

On Monday, May 26, 2008 4:53 PM
Bill Sharpe wrote:

Excel 2007 Gridlines Disappeared
Adel wrote:
Default gridline option "automatic" on my Excel 2007 results in faint
grid lines. I changed the option described by Shane to "black" and the
grid lines are more noticeable now.

Bill

On Monday, June 09, 2008 1:47 AM
Ade wrote:

Excel 2007 Gridlines Disappeared
"Ron de Bruin" wrote:

what is your e-mail address? I'd liek to send you a copy of a workbook to
look at it?

Tx
adel

On Monday, June 09, 2008 1:51 AM
Ade wrote:

Excel 2007 Gridlines Disappeared
"Ron de Bruin" wrote:


Thanks alot for your help
adel

On Monday, June 09, 2008 10:47 AM
Ron de Bruin wrote:

Excel 2007 Gridlines Disappeared
See
http://www.rondebruin.nl/


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

On Saturday, August 09, 2008 10:52 PM
Justin W. Hambur wrote:

In my experience some of the aspects of Office 2007 seem to disappear on some
In my experience some of the aspects of Office 2007 seem to disappear on some
monitors. The cause is the contrast and brightness settings of the monitor.

I have seen this on several machines. The gridlines may disappear in Excel,
or the watermarks may disappear in Word. When the user adjusts the
brightness and contrast of their machine, these aspects reappear.

This appears to be a new issue unique to Office 2007. I believe it is due
to the lightness of some items in the display. Office 2007 seems to have a
much lighter quality to several of the screen elements.

"Adel" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Multipart MIME Encoding Library using CDO
http://www.eggheadcafe.com/tutorials...e-encodin.aspx

This has been confounding me ever since we started using Excel 2007. I finally discovered, entirely by accident and frustration how to make them reappear!
Highlight the cell or group of cells whose grid lines have disappeared...

Go to HOME tab
Then to FONT GROUP
Click the FILL COLOR TAB
Then, go down to the box that says NO FILL, and click it.

Your missing grid lines will magically reappear! To make sure I have found all the grid-less cell areas, I print out a copy of the spreadsheet...and your printed copy will reveal ALL the areas where you are missing your grid lines.
This discovery made me happy as heck!



Ade wrote:

Excel 2007 Gridlines Disappeared
25-May-08

The gridlines disappeared. I have confirmed background has "no color" and
all "show gridlines" are checked. I am out of options and think I may have
to uninstall the entire program and start over. Does anyone have any other
ideas?

Previous Posts In This Thread:

On Sunday, May 25, 2008 2:38 PM
Ade wrote:

Excel 2007 Gridlines Disappeared
The gridlines disappeared. I have confirmed background has "no color" and
all "show gridlines" are checked. I am out of options and think I may have
to uninstall the entire program and start over. Does anyone have any other
ideas?

On Sunday, May 25, 2008 2:43 PM
Ron de Bruin wrote:

Also in new worksheets/workbooks ?
Also in new worksheets/workbooks ?

If you want send me a workbook private and I look at it for you



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

On Sunday, May 25, 2008 4:31 PM
ShaneDevenshir wrote:

Hi Adel,1. Try choosing View, Show/Hide group, and check Gridlines.2.
Hi Adel,

1. Try choosing View, Show/Hide group, and check Gridlines.

2. There is another far less likely possibility - the gridline color has
been set to White under Office Button, Excel Options, Advanced, Gridline
Color.
--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Adel" wrote:

On Sunday, May 25, 2008 4:31 PM
tombin wrote:

just to recheck you have gone in options, selected gridlines and colour
just to recheck you have gone in options, selected gridlines and colour
automatic. Do you use macros and/or vba?

"Adel" wrote:

On Sunday, May 25, 2008 4:34 PM
GMcPherso wrote:

When something like this happens to me and I can't pinpoint the cause, I'll
When something like this happens to me and I can't pinpoint the cause, I'll
find a nearby cell with similar formatting and paste its format to the
offending cells to restore the gridlines. Hope this is helpful.

On Monday, May 26, 2008 4:53 PM
Bill Sharpe wrote:

Excel 2007 Gridlines Disappeared
Adel wrote:
Default gridline option "automatic" on my Excel 2007 results in faint
grid lines. I changed the option described by Shane to "black" and the
grid lines are more noticeable now.

Bill

On Monday, June 09, 2008 1:47 AM
Ade wrote:

Excel 2007 Gridlines Disappeared
"Ron de Bruin" wrote:

what is your e-mail address? I'd liek to send you a copy of a workbook to
look at it?

Tx
adel

On Monday, June 09, 2008 1:51 AM
Ade wrote:

Excel 2007 Gridlines Disappeared
"Ron de Bruin" wrote:


Thanks alot for your help
adel

On Monday, June 09, 2008 10:47 AM
Ron de Bruin wrote:

Excel 2007 Gridlines Disappeared
See
http://www.rondebruin.nl/


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

On Saturday, August 09, 2008 10:52 PM
Justin W. Hambur wrote:

In my experience some of the aspects of Office 2007 seem to disappear on some
In my experience some of the aspects of Office 2007 seem to disappear on some
monitors. The cause is the contrast and brightness settings of the monitor.

I have seen this on several machines. The gridlines may disappear in Excel,
or the watermarks may disappear in Word. When the user adjusts the
brightness and contrast of their machine, these aspects reappear.

This appears to be a new issue unique to Office 2007. I believe it is due
to the lightness of some items in the display. Office 2007 seems to have a
much lighter quality to several of the screen elements.

"Adel" wrote:

On Tuesday, January 05, 2010 6:19 AM
Derek Hawthorne wrote:

Restoring Default Gridlines on Excel Workshop
Clicking on an unused cell and copying it. Then highlighting the cell/cells then right click and select 'paste special' then select the radio button 'Formats' OK then ENTER solved the problem for me.
Thanks to G.McPherson and the rest


Submitted via EggHeadCafe - Software Developer Portal of Choice
A Framework to Animate WPF and Silverlight Pages Similar to the PowerPoint Slides
http://www.eggheadcafe.com/tutorials...nimate-wp.aspx