Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-23-2015, 06:55 PM
ottiliegirl ottiliegirl is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
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 Windows 7 64bit 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 Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
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 Windows 7 64bit 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 Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
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 Windows 7 64bit 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 Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
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 Windows 7 64bit 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 Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
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 Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,223
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

And Home ribbon - Editing - Clear - Clear Formats?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #11  
Old 03-25-2015, 02:48 PM
Chancy Chancy is offline Windows 7 64bit 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 Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
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 Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,223
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Perhaps post a sample sheet ?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
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 habiba usman Word 1 02-12-2013 12:46 PM
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
How do I get rid of a grid in Word? CJJames Word 1 04-04-2012 10:11 AM


All times are GMT -7. The time now is 06:31 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft