Solved

Excel 2013 - Where are my gridlines, NOT borders, gridlines

Posted on 2014-09-23
3
135 Views
Last Modified: 2014-09-23
I turned on the Gridlines checkbox but I still don't have any gridlines on my screen.
(see graphic).
What do I need to do to turn on the gridlines.
err
0
Comment
Question by:brothertruffle880
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 40339444
In the Options > Advanced window, scroll down to halfway down the pane and there is an option for Gridline colour. Check that this is not set to white.

Alternatively, if the cells have been formatted with a white fill, the gridlines will disappear.

Alternative number 2, the cells have had white borders enabled.

Thanks
Rob H
0
 

Expert Comment

by:karunamoorthy p
ID: 40339662
Pl, give the excel sheet here and to see why grid is not appearing and give further help.
0
 

Author Comment

by:brothertruffle880
ID: 40339820
Thanks Rob:
The last person who worked on it did a WHITE FILL.  Ugggh..
Once I got rid of the white fill, the grid lines came back!
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question