Remove Gridlines in Excel 2007 and Later

Add to Favorites

In Excel 2007 and later you can quickly remove the gridlines that appear within the Excel worksheet. This allows you to view the worksheet without any lines in it. You won't see the outline of any cells and this may not seem like a good idea. However, this allows you to make really clean looking spreadsheets in Excel and allows you to put focus on certain elements within the spreadsheet. This is especially helpful when creating forms in Excel; when doing this you don't need or want extra gridlines within the spreadsheet.


Remove or Add Gridlines in Excel 2007:

View tab > Show/Hide box > Un-check the Gridlines check box


Remove Gridlines in Excel 2007


Sales Report with Gridlines:


Sales Report with Gridlines


Sales Report without Gridlines:


Sales Report without Gridlines

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Sort Data Alphabetically or Numerically in Excel 2007 and Later
Tutorial: This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007. T...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel. This includes Ex...
Make Users Enable Macros in Order to View a Workbook in Excel
Tutorial: Tutorial showing you how to make a user enable macros in a workbook in order to view the w...
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...