Turn off gridlines in your Excel applications

Gridlines in your Excel worksheets can be quite distracting. Mary Ann Richardson explains how to make gridlines invisible in Excel 2002, 2003, and 2007.

Your users may find it easier to work with your worksheet applications if they can't see the gridlines. For example, let's say you developed a worksheet that displays a new chart that compares monthly sales figures for the department each time a salesperson enters his/her monthly sales figures. Your worksheet includes instructions for using the spreadsheet, a bordered cell where they are to enter their data, and the changing chart.

To prevent the salespeople from working with the other cells in the worksheet, you can turn off the gridlines in Excel 2003 or Excel 2002, by following these steps:

  1. Go to Tools | Options.
  2. On the View tab in the Windows section, clear the Gridlines check box.
  3. Click OK.

To turn off the gridlines in Excel 2007, follow these steps:

  1. Click the View tab.
  2. Clear the Gridlines check box in the Show/Hide section of the ribbon.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox