Excel – Disappearing Grid Lines
(See our updated post with 4 reasons your Excel gridlines have disappeared.) There are 2 possible reasons your gridlines have disappeared. First, gridlines might be turned off in Excel Options. Simply click on Page Layout, and put a check in View under the Gridlines box. You can even print your grid lines here by checking Print in the same box. But what if View is checked in Page Layout? There is another possibility. |
|
|
 |
Excel Formatting is covered in these Excel classes:
See our other Excel topics.
Tags: excel, formatting, Just Tips, Microsoft Excel
January 26th, 2010 at 2:29 pm
Many thanks – like all things excel easy peasy when u know how.
August 24th, 2011 at 3:18 pm
Do you know how to change the default gridliines or fill in excel 2010. Have an situation when excel 2010 is opened there are no gridlines displayed. All checks for gridlines have been verified so that is not the problem. Default gridlines are set to white. How can you permanently change the default so it will open displaying gridlines.
November 29th, 2011 at 11:36 am
Just what I was looking for. Good job
January 6th, 2012 at 10:45 pm
I have this problem as well. I have checked the options and fill box, but its almost like my screen is too bright or something. I can almost see the gridlines, but not good enough. This is driving me crazy!!!
January 10th, 2012 at 12:40 pm
We have a post on our new blog with more reasons for Disappearing Excel Gridlines. I hope that helps.
July 2nd, 2012 at 7:23 am
still no gridlines
August 23rd, 2012 at 8:42 am
If you by chance have adjusted you settings on your monitor, ie brightness and contrast. If the contrast is up near 100% it will cause them to go away. I went through all the online settings only to find out it was the contrast setting on my monitor.
September 5th, 2012 at 4:19 pm
All the solutions on the net failed me but unplugging my laptop and plugging it back in allowed me to see the lines again. No idea why it worked just putting this up in the hopes it saves someone the time I lost figuring that out.
October 24th, 2012 at 7:51 pm
Thank you very much!
November 1st, 2012 at 1:50 pm
For users of the older, non-fancy-pretty-coloured, less bulky, less newbie-oriented Excel versions,
1. Mark everything by clicking the empty cell at top left of your spreadsheet.
2. Click on Format.. then on the Cells option,
3. Click on the dotted line type at top left (or whichever you want), of the window on the right then..
4. in the window on the left, click the three horizontal lines and the three vertical lines. OK and you’re done.
November 29th, 2012 at 6:19 am
The ‘no fill’ solved the problem, many thanks for the help.
December 3rd, 2012 at 7:06 pm
Problem solved! Thank you. Very helpful to be able to find hints like this online.
January 2nd, 2013 at 9:00 am
Never would have thought to look at the “fill” color. Worked like a charm. Thanks!
January 5th, 2013 at 2:24 am
This is so helpful. Thank you
February 16th, 2013 at 11:20 am
The contrast setting on my monitor was at 100. Lowering it will bring the lines back.