Reset Excel to default borders

Ryan picture Ryan · Feb 10, 2011 · Viewed 101.9k times · Source

Ok, so you know what a spreadsheet looks like when you open a new on in Excel; the borders are a light blue. These are only on the screen though, if you print the sheet it will not have borders. Say you've applied some various formatting to the sheet (background color, etc.) and those "default" borders are gone. My question is how to you get them back? Simply doing a Clear Formats will not always work.

Specifically I am talking about Excel 2007 but I believe all versions do this.

Any ideas?

Thanks, Ryan

Answer

Robert Weatherall picture Robert Weatherall · Dec 30, 2015

I had this issue, grid lines appeared to be missing on some cells.

Took me awhile to figure out that the color of those cells were white. I clicked format cell, pattern and then selected "no color" (instead of white) The the grid lines were visible again.

I hope this helps others as it took me a while to figure out why.