IT News & Technology update

Provide comprehensive update related to Computer, technology, software, anti virus and another electric device

Turn off gridlines in your Excel applications

Written by IT News on 6:29 PM

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.

Related Posts by Categories



Widget by Hoctro | Jack Book
  1. 0 comments: Responses to “ Turn off gridlines in your Excel applications ”

Search This Blog

Ads and Sponsored by:



Want to subscribe?

Subscribe in a reader.