Remove Gridlines in Excel 2007 and Later

Add to Favorites
Author:

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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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...
Tutorial Details
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course