Excel grid appearance ?

Select the cells and clear all borders.

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

Kevin

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

Kevin

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

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

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.

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

Kevin

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

version: excel  2007

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

Kevin

in borders I selected None. that's it.

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

yeah, doing this. no results.

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

Correction: "No Fill" instead of "none"

That would certainly hide the default cell grid lines.

Kevin

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.