Excel grid appearance ?

Jess31
Jess31 used Ask the Experts™
on
I selected an area in a worksheet and after playing with various Borders selected none. Now ever the default grid look is gone. How do I get it back?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008

Commented:
Select the cells and clear all borders.

You can also try setting the show grid lines option on.

Kevin
Top Expert 2008

Commented:
The gridlines option is on the View tab in the Show group.

Kevin

Author

Commented:
That checkbox will take it off everything or put it on all besides for those that are lacking them now.
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Top Expert 2008

Commented:
Then I presume the check box is set on?

What you have probably done is added white borders which will appear as no borders. Select the cells around which you want borders and clear the borders. Clearing borders means opening the borders tab of the cell format dialog and selecting none for each border you want to clear.

Kevin

Author

Commented:
there are no borders to clear. but i did open borders and selected none. of course it didn't fix the problem, this is what made the proble.
Top Expert 2008

Commented:
Are the borders missing from your entire worksheet or just a few cells? What version of Excel are you using?

Kevin

Author

Commented:
just on some cells that I have previous put some dark borders to and then removed them.

version: excel  2007
Top Expert 2008

Commented:
How did you remove the borders? If you used white borders then change them back to a visible color or remove them completely.

Kevin

Author

Commented:
in borders I selected None. that's it.
Top Expert 2008

Commented:
Did you apply the border setting (None) to the borders? It's a two step process: first select the color, size, etc. (in this case None) and then click on the borders to which you want to apply those settings. You have to apply the settings even if you select None.

Kevin

Author

Commented:
yeah, doing this. no results.
Top Expert 2008

Commented:
Can you post the workbook? if not, can you copy the affected cells to a new workbook, test if it's still a problem, and then post that workbook?

Kevin
My guess is that you set the cell fill color to white (vs. none).
Correction: "No Fill" instead of "none"
Top Expert 2008

Commented:
That would certainly hide the default cell grid lines.

Kevin

Author

Commented:
OK. Now I get it - I need to go to the Fill Tab and change it there (even though I never changed it here before). This works. thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial