Search TeachExcel.com
TeachExcel.com
TE
Teach Excel MS Office Tutorials Excel Consulting Services Excel Forum
Excel Video Tutorials Excel Tips Free Excel Macros Excel Help Resources Contact TeachExcel
Video Tutorials
  • Free Macros
  • Excel Help Directory
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Excel Forum
  • Contact/About

Excel Tips and Tutorials: Formatting in Excel

Remove Gridlines in Excel 2007

Bookmark and Share

In Excel 2007 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




Bookmark and Share
Random Tutorials
Goal Seek Feature in Excel
(Intermediate)
Remove #N/A Error Result from Empty VLOOKUP() Formulas
(Intermediate)
Lookups With MATCH() and INDEX() Functions
(Intermediate)
HLOOKUP() Function - Introduction
(Intermediate)
Consolidate & Combine Data from Separate Worksheets or Workbooks(Excel Files)
(Intermediate)
How to record a Macro - And what One is
(Easy)
Contact | Privacy Policy | Disclaimer
Copyright© 2012 TeachExcel.com