Software

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.

15 comments
satiutni
satiutni

Great feature - together with hiding row numbers and column letters - been there since before Office 97! Although (as pointed out elsewhere) is a cosmetic feature can give a professionally finished impresssion for situations where end users dont need the understanding just the functionality of the application developed. Of course in many situations ignoring such cosmetic features is legitimate too - just demonstartes the diversity in both the product and users. Thanks.

mathew.patrick
mathew.patrick

This infomation was usefull, thank you. Have a question thought - How do I add the gridlines (turn on/off) icon on the quick access Toolbar- Excel 2007 ?

rhyde
rhyde

Excellent. Thanks

awsompower
awsompower

Thanks for the tip. Being a student it helps to practice these things.

toxic psychotic avenger
toxic psychotic avenger

So trivial, yet a pain in the butt to correct if you didn't know the term "gridlines".

igtddave
igtddave

Not a big deal if you've already moved on to another version of Office.

grahamrice
grahamrice

As stated by another member this is a very "trivial" feature and not worthy of mention on this forum. It simply changes the cosmetic appearance. It does NOT have the claimed effect of preventing data entry. Just because gridlines are not visible does not stop a user moving to a cell and entering data. To prevent data entry a combination of "locking" cells and worksheet "protection" is needed - at least in all versions of Excel up to 2000.

ky_ramirez
ky_ramirez

No such thing as too much info. Thanks for sharing. Please don't let a few negative folks dissuade you from sharing in the future. There are many of us out here appreciating ALL that's offered. Thanks again :-)

Runo
Runo

Prevent, in this usage, means to ensure that the user is not confused. By turning off gridlines and ensuring that only the cells you wish to have filled have borders you are preventing your user from becoming confused and possibly upset.

satiutni
satiutni

Hi, I personally dont think this is too trivial for the forum since looking at some of the replies to this and other tips it seems there are members learning about Excel at all levels. However, I have to technically agree with Graham on the meaning of prevent. Maybe discourage would have been a better choice of word in the original context. Regards Paul IT Trainer in Hobart, Tasmania, Australia

kevin_cshank
kevin_cshank

this section is called tips if u knw, good for u,, if knw more tell us, but dont do like many "knw it all" guys and brag.......... thats shallow!!!!!!!!!!