Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2015, 06:55 PM
ottiliegirl ottiliegirl is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Novice
grid lines disappeared
 
Join Date: Oct 2013
Posts: 29
ottiliegirl is on a distinguished road
Default grid lines disappeared

Even though grid lines is checked I cannot see any lines. Also the numbers down the left edge are no longer colored blue nor are the letters across the top. How do I get the color and lines back?
Reply With Quote
  #2  
Old 03-24-2015, 04:12 PM
Chancy Chancy is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by ottiliegirl View Post
Even though grid lines is checked I cannot see any lines. Also the numbers down the left edge are no longer colored blue nor are the letters across the top. How do I get the color and lines back?
Try highlighting the entire worksheet, and then go to background fill, and click "none". You may have the fill color set as white.
The lines may then appear also. If not, post back.
Reply With Quote
  #3  
Old 03-24-2015, 04:19 PM
ottiliegirl ottiliegirl is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Novice
grid lines disappeared
 
Join Date: Oct 2013
Posts: 29
ottiliegirl is on a distinguished road
Default

Thanks, but that didn't help.
Reply With Quote
  #4  
Old 03-24-2015, 04:31 PM
Chancy Chancy is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

In Options/Advanced, scroll down to display options, where the check box is to "show gridlines", is the color of the gridlines set to Black?

For the blue - I'm on Office 2007. In Options, General Tab, I have the option for Silver or Blue or Black. Blue gives me blue row numbers and column labels. I'm not sure if that's the same "blue" to which you refer.
Reply With Quote
  #5  
Old 03-24-2015, 04:46 PM
ottiliegirl ottiliegirl is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Novice
grid lines disappeared
 
Join Date: Oct 2013
Posts: 29
ottiliegirl is on a distinguished road
Default

I now have a very light blue down the numbers on the left and the letters across the top but no gridlines. So - half a resolution is better than none. thanks again.
Reply With Quote
  #6  
Old 03-24-2015, 04:55 PM
Chancy Chancy is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by ottiliegirl View Post
I now have a very light blue down the numbers on the left and the letters across the top but no gridlines. So - half a resolution is better than none. thanks again.
Are you sure you have tried this:
Highlight all of the worksheet
Format Cells
Fill
For Backgroundcolor: click "No Color".
Apply
Reply With Quote
  #7  
Old 03-24-2015, 04:59 PM
ottiliegirl ottiliegirl is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Novice
grid lines disappeared
 
Join Date: Oct 2013
Posts: 29
ottiliegirl is on a distinguished road
Default

I definitely did that but I just did it again to be sure. Interestingly, when the entire sheet is selected it turns blue and I see white grid lines. Even that would be better than none.
Reply With Quote
  #8  
Old 03-24-2015, 05:25 PM
Chancy Chancy is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by ottiliegirl View Post
I definitely did that but I just did it again to be sure. Interestingly, when the entire sheet is selected it turns blue and I see white grid lines. Even that would be better than none.
In Options/Advanced, scroll down to display options, where the check box is to "show gridlines", is the color of the gridlines set to Black?
Reply With Quote
  #9  
Old 03-24-2015, 05:37 PM
ottiliegirl ottiliegirl is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Novice
grid lines disappeared
 
Join Date: Oct 2013
Posts: 29
ottiliegirl is on a distinguished road
Default

That has been checked many times. The only place "show grid lines" shows up is under "display options for this worksheet". Since I have opened up so many worksheets today, those that I opened have grid lines because I went to advanced and changed that to blue. But every time it is a new worksheet and I go to advanced it is back to black and needs to be changed.
Reply With Quote
  #10  
Old 03-25-2015, 12:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

And Home ribbon - Editing - Clear - Clear Formats?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #11  
Old 03-25-2015, 02:48 PM
Chancy Chancy is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by ottiliegirl View Post
That has been checked many times. The only place "show grid lines" shows up is under "display options for this worksheet". Since I have opened up so many worksheets today, those that I opened have grid lines because I went to advanced and changed that to blue. But every time it is a new worksheet and I go to advanced it is back to black and needs to be changed.
Is it fixed yet? The only other thing I can think is that you need to save your new option choices for the default in Excel. Not sure how you do that: close all files, open a new worksheet with one tab, change the options to what you want, close Excel? Then when you open it new, does the default sheet look right?
Reply With Quote
  #12  
Old 05-01-2015, 06:20 PM
ottiliegirl ottiliegirl is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Novice
grid lines disappeared
 
Join Date: Oct 2013
Posts: 29
ottiliegirl is on a distinguished road
Default Missing Grid Lines

It has been one month and I still can't get any grid lines on my spreadsheets. I have tried everything anybody has suggested to no avail. I am hoping this message could once again get to the top of the message board in hopes that someone new might have a suggestion for me. It is almost impossible to use a spreadsheet without grid lines. Thank you
Reply With Quote
  #13  
Old 05-02-2015, 01:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps post a sample sheet ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #14  
Old 05-04-2015, 09:04 AM
Chancy Chancy is offline grid lines disappeared Windows 7 64bit grid lines disappeared Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

http://www.mcstech.net/blog/index.cf...xcel-Gridlines

http://www.guidingtech.com/29241/fix...idlines-excel/

http://www.postseek.com/meta/9b9d67b...fc49a54bf288e8

http://www.postseek.com/meta/9375d93...6c78c5edb0ba3f

http://www.bleepingcomputer.com/foru...e-disappeared/

Could these ideas give you the solution?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting grid lines but keeping the axis lines CoffeeNut Excel 0 04-01-2013 01:50 PM
grid lines disappeared grid lines habiba usman Word 1 02-12-2013 12:46 PM
grid lines disappeared MS Word 2010 / Grid Lines Word4Dick Word 2 10-24-2012 12:23 PM
Change Default Excel Grid to Solid Black Lines SQLUSA Word 1 07-15-2012 10:04 PM
grid lines disappeared How do I get rid of a grid in Word? CJJames Word 1 04-04-2012 10:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft