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



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 ...
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 Exce...
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...