Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel 2007 Gridlines Disappeared

46 views
Skip to first unread message

Adel

unread,
May 25, 2008, 2:38:00 PM5/25/08
to
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?


Ron de Bruin

unread,
May 25, 2008, 2:43:19 PM5/25/08
to
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


"Adel" <Ad...@discussions.microsoft.com> wrote in message news:037E9B91-9258-4EE5...@microsoft.com...

ShaneDevenshire

unread,
May 25, 2008, 4:31:01 PM5/25/08
to
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

tombing

unread,
May 25, 2008, 4:31:02 PM5/25/08
to
just to recheck you have gone in options, selected gridlines and colour
automatic. Do you use macros and/or vba?

G McPherson

unread,
May 25, 2008, 4:34:00 PM5/25/08
to
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.

Bill Sharpe

unread,
May 26, 2008, 4:53:00 PM5/26/08
to
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

Adel

unread,
Jun 9, 2008, 1:47:00 AM6/9/08
to

"Ron de Bruin" wrote:

> Also in new worksheets/workbooks ?
>
> If you want send me a workbook private and I look at it for you

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

Tx
adel

Adel

unread,
Jun 9, 2008, 1:51:00 AM6/9/08
to

"Ron de Bruin" wrote:

> Also in new worksheets/workbooks ?
>
> If you want send me a workbook private and I look at it for you
>

> Yes. Every time I open a new book, I have no gridlines, although I have it checked as black under excel options, advanced, ...ect. Also checked under view, and still no gridlines. Simply frustrating!

Thanks alot for your help
adel

Ron de Bruin

unread,
Jun 9, 2008, 10:47:04 AM6/9/08
to
See
http://www.rondebruin.nl/


--

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


"Adel" <Ad...@discussions.microsoft.com> wrote in message news:B6DEA009-6491-4222...@microsoft.com...

W. Hamburg@discussions.microsoft.com Justin W. Hamburg

unread,
Aug 9, 2008, 10:52:00 PM8/9/08
to
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.

derekhawthorne

unread,
Jan 5, 2010, 6:20:03 AM1/5/10
to
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:

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

Re: 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:

Re: 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:

Re: 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:

Re: 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/aspnet/6b462a79-92ab-46e0-95a3-c383a737d43f/c-multipart-mime-encodin.aspx

jeanniebogner

unread,
Apr 19, 2010, 4:24:53 PM4/19/10
to
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

Previous Posts In This Thread:

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

Excel 2007 Gridlines Disappeared

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

--

"Adel" wrote:

"Adel" wrote:

Bill

Tx
adel


--

"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/aspnet/7390a840-dd39-4c35-9940-c7354940d878/a-framework-to-animate-wp.aspx

Rich C

unread,
Aug 25, 2010, 2:08:48 PM8/25/10
to
The only thing that I have found that works is:
Highlight the involved cells, then right-click and hit delete. Choose shift cells up or shift cells left

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

> 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 ?
>>

>> 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. 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

>>>> 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

>>>>>>>>>> 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:

>>>>>>>>>>> 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


>>>>>>>>>>>> On Monday, April 19, 2010 4:24 PM Jeannie Bogner wrote:

>>>>>>>>>>>> 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!


>>>>>>>>>>>>> On Tuesday, July 13, 2010 12:34 AM Melanie Cherry wrote:

>>>>>>>>>>>>> You don't know how many things I have tried in order to get the gridlines to reappear, and you made it look easy! Thank you so much again, not even microsoft had an answer for this one.


>>>>>>>>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice

>>>>>>>>>>>>> A Comparison of Managed Compression Algorithms
>>>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/71485ecc-2d2d-435a-9c35-3d12b279f9ae/a-comparison-of-managed-compression-algorithms.aspx

0 new messages