Help!

Grid lines in Excel not showing.Have tools,options,view/gr..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Can't Wrap text in the Merge Cells  
Author Message
bajlearning
External


Since: Aug 30, 2006
Posts: 1



PostPosted: Thu Aug 31, 2006 3:25 am    Post subject: Grid lines in Excel not showing.Have tools,options,view/grid cked
Archived from groups: microsoft>public>excel>misc (more info?)

help! I still can't get the grid lines in Excel to show up. Under
tools/options/view the gridlines is checked....now what?
Back to top
Carim
External


Since: Mar 17, 2006
Posts: 151



PostPosted: Thu Aug 31, 2006 3:32 am    Post subject: Re: Grid lines in Excel not showing.Have tools,options,view/grid cked [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

Did you check the colors ...??? white on white ...

HTH
Carim
Back to top
Muhammed Rafeek M
External


Since: Jul 19, 2006
Posts: 65



PostPosted: Thu Aug 31, 2006 3:33 am    Post subject: RE: Grid lines in Excel not showing.Have tools,options,view/grid cked [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

change grid line color from Tools/Options/View

pls do rate

"bajlearning" wrote:

> help! I still can't get the grid lines in Excel to show up. Under
> tools/options/view the gridlines is checked....now what?
>
Back to top
Cheryl
External


Since: Dec 15, 2004
Posts: 144



PostPosted: Thu Aug 31, 2006 3:37 am    Post subject: RE: Grid lines in Excel not showing.Have tools,options,view/grid cked [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

look under Tools>Options>View>Gridlines Color:
It should be set to "Automatic"
--
Cheryl


"bajlearning" wrote:

> help! I still can't get the grid lines in Excel to show up. Under
> tools/options/view the gridlines is checked....now what?
>
Back to top
MartinW
External


Since: Apr 24, 2006
Posts: 500



PostPosted: Fri Sep 01, 2006 1:58 am    Post subject: Re: Grid lines in Excel not showing.Have tools,options,view/grid cked [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi bajlearning,

Also look at the fill colors. If they're set to white nothing
you do with gridlines will have any effect.

HTH
Martin
Back to top
fukbin
External


Since: Jan 27, 2007
Posts: 1



PostPosted: Sat Jan 27, 2007 2:30 pm    Post subject: Re: Gridlines in Excel missing.Have tools/opts/view/grid chekd. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I have tried everything listed here (Excel 2003) AND completly removed OFFice
and reinstalled it and no luck.

The work around is to save a single sheet with the gridline color set to
GRAY 50%, and and inserted sheets will be blank until you repete this
process. The templates are in XLStart (not the default template folder). It
needs to be named BOOK and saved as a TEMPLATE not an excel document. This
works, but I do not like not knowing how to really fix the problem.

Let me know any suggestions, please...
Back to top
Jim Cone
External


Since: Dec 11, 2003
Posts: 834



PostPosted: Sat Jan 27, 2007 11:00 pm    Post subject: Re: Gridlines in Excel missing.Have tools/opts/view/grid chekd. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Maybe the color of the gridlines has been changed to white or
some other color that does not have sufficient contrast.
Look just below where gridlines are checked in Tools | Options.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




"fukbin" w
rote in message
I have tried everything listed here (Excel 2003) AND completly removed OFFice
and reinstalled it and no luck.

The work around is to save a single sheet with the gridline color set to
GRAY 50%, and and inserted sheets will be blank until you repete this
process. The templates are in XLStart (not the default template folder). It
needs to be named BOOK and saved as a TEMPLATE not an excel document. This
works, but I do not like not knowing how to really fix the problem.

Let me know any suggestions, please...
Back to top
bugmenot



Joined: Mar 12, 2007
Posts: 109



PostPosted: Mon Aug 04, 2008 7:09 pm    Post subject: [Login to view extended thread Info.]

Excel cells have no fill colour by default. When you make a block of cells' fill colour anything other than "No fill", the grid lines disappear.

Highlight the block where you want the grid lines back and set the fill colour to "No fill". Your grid lines will reappear without having to border things.

If you want the fill colour to be something other that "No fill", then you have to put the borders in explicitly.

Steve B. in Yahoo Answers
Back to top
yohahn



Joined: Oct 02, 2008
Posts: 1



PostPosted: Thu Oct 02, 2008 1:58 pm    Post subject: spaces extending beyond cells cover Excel gridlines [Login to view extended thread Info.]

I've seen users open spreadsheets and complain that only some of the gridlines appear. After looking at the sheets, I discovered the data in the cells to the right had trailing spaces. These spaces covered the vertical gridlines on the cells to the left. Truncating the spaces solved the issue.
Back to top
ProblemSolver



Joined: Apr 07, 2009
Posts: 1



PostPosted: Tue Apr 07, 2009 5:54 pm    Post subject: [Login to view extended thread Info.]

Try changing the brightness/contrast settings on your monitor. I had the same problem, and this solved it for me.
Back to top
MaceJSC



Joined: Jan 06, 2010
Posts: 1



PostPosted: Wed Jan 06, 2010 6:45 pm    Post subject: arrggh Gridlines not working right. [Login to view extended thread Info.]

Ok, I've looked at every option I can find in excel, and I have read many posts about the gridlines and not one, except this one, has mentioned my same problem.

I have no vertical gridlines. I have gone to Tools--> Options--> View and Gridlines is checked, the gridline color is set to automatic, the cell fill is set to automatic, and it is not on a sheet I've been working in, this is happening in a brand new workbook. It's coming up as the default like that.

I can see my horizontal gridlines but no vertical. If I highlight the cells like I'm about to copy them or something, then I can see the gridlines, and if I change the gridline color to Gray 50% or black I can see them. I know it's not the brightness of my monitor because it's been fine up until today and no setting have changed. The closest thing that I've done is opened a 07 Excel document in Excel 03, and it was from a trusted source, it was a workbook from MS that I copied from my laptop to my desktop.

Here's what I want to try but I don't know where the default template is. I want to delete the default workbook and have Excel recreate it. Is the default file in XLStart?
Back to top
vtbarbour



Joined: Jun 03, 2010
Posts: 1



PostPosted: Thu Jun 03, 2010 3:15 pm    Post subject: Re: Grid lines in Excel not showing.Have tools,options,view/ [Login to view extended thread Info.]

I'm not sure if you ever found a solution. I just now came across this while trying to figure it out myself. Finally, I realized that it was only doing gridlines for the rows that had at least something in them such as a period or maybe give each row a number in which you want to have lines. This is what worked for me after trying a number of the things below.

Donald


bajlearning wrote:
help! I still can't get the grid lines in Excel to show up. Under
tools/options/view the gridlines is checked....now what?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum