Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-09-23
3
Medium Priority
?
147 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
3 Comments
 
LVL 34

Accepted Solution

by:
Rob Henson earned 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

886 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