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:
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?
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
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
:
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?
:
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.
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
Re: Excel 2007 Gridlines Disappeared
:
what is your e-mail address? I'd liek to send you a copy of a workbook to
look at it?
Tx
adel
Re: Excel 2007 Gridlines Disappeared
:
Thanks alot for your help
adel
Re: Excel 2007 Gridlines Disappeared
See
http://www.rondebruin.nl/
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
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.
:
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/tutorial...0-c7354940d878/a-framework-to-animate-wp.aspx