<div>
Do Some SomeRange.ClearFormats for all affected cells.
</div>


<div>
Sorry, lost you with Some....
</div>


<div>
The cells may be merged. If they are you can right click on the range, choose Format Cells, then Alignment and uncheck Merge Cells
</div>


<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


<div>
<div class="content wysiwyg-content">
I inherited a worksheet where the gridlines are only suppressed in certain cells. &nbsp;How do I restore them?
</div>
</div>


I inherited a worksheet where the gridlines are only suppressed in certain cells.  How do I restore them?

Do Some SomeRange.ClearFormats for all affected cells.

The cells may be merged. If they are you can right click on the range, choose Format Cells, then Alignment and uncheck Merge Cells

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Restoring Grid Lines in Certain Cells in Excel 2013 (Microsoft should learn to quit changing things just because you can!)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.