How to turn gridlines on and off in Excel

Are you building a gem of a spreadsheet, but feel that it would look much better if it didn’t have those lines in between all the cells?

Well those lines are called “Gridlines” and they are really easy to turn on and off

To hide gridlines in Excel 2007, Excel 2010 or Excel 2013:

  • Make sure you are on the “View” tab in the Ribbon
  • Look for the “Show/Hide” group
  • Click on “Gridlines” checkbox, which will make the tick (and the gridlines) disappear

To show gridlines in Excel 2007, Excel 2010 or Excel 2013:

  • Do the same as above, but just make sure that you check the checkbox!

Simple as that!

‘till next time!
TNP ;)

4 thoughts on “How to turn gridlines on and off in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>