TIPS & TRICKS: Disappearing Gridlines On Some Cells in Excel

There's an Excel file that is shared in my office. I know people cut and paste cells/rows of information to move elsewhere. I often find that this type of modification makes some cells look like they have lost their gridlines. There's several reasons why this might occur:

• The gridlines are turned off. (Fix: View > Recheck box for gridlines).

• The gridlines are colored over, usually with white. (Fix: right-click on cell > Format Cells > Fill tab > Select No Color, or select white and then reselect no color)

• The borders are colored white. (Fix: right-click on cell > Format Cells > Border tab > change color to Automatic)

• The gridlines have been colored white. (Fix: click on File > Options > Advanced > Display options for this worksheet > change Gridline color to black)

Found these reasons from this handy page: 

http://mcstech.net/blog/index.cfm/2011/12/29/Disappearing-Excel-Gridlines

My particular fix came from the second reason. I've tried it on Excel 2010 and Excel 2013.