How to Remove Grid Lines

Grid lines are lines that cross in a document. Microsoft Excel uses grid lines in its spreadsheet software, but sometimes you want to see the information without the vertical and horizontal boxes. Microsoft makes it easy to remove the grid lines and create a customizable spreadsheet document. By following a few simple steps, you can remove the lines in your spreadsheet.

Instructions

For Excel 2003

1. Select the cells in the spreadsheet from which you want to remove the grid lines. Do this by left-clicking on the mouse and holding it down as you move the cursor over the cells you want to select.

2. Click on the "Format" menu at top of page.

3. Click "Cells."

4. Click on the "Patterns" tab.

5. Click on the background color of the spreadsheet. In most cases, the color is white.

6. Click on the "Border" tab.

7. Click on the arrow in the "Colors" box. Click on the color of the gridlines. In most cases, the color is 25% gray.

8. Click "Outline."

9. Click on "OK." The grid lines are now gone.

For Excel 2007

1. Open your spreadsheet.

2. Click "View" on the taskbar.

3. Look for the "Show/Hide" group.

4. Clear the checkbox near "Gridlines" to uncheck the box. The gridlines disappear.

For Excel 2010

1. Select your spreadsheet.

2. Click "File" in the taskbar. Click "Options." A dialog box will appear.

3. Click "Advanced" in the right pane. Scroll to find "Display Options for this Worksheet," and click on it.

4. Disable "Show Gridlines" by clicking on the check box to remove the check. The gridlines disappear.

References

• Microsoft: How to Remove Gridlines from a Section of a Worksheet
• Microsoft: Show or Hide Gridlines on a worksheet
• Addictive Tips: Excel 2010: Change, Remove, Print Gridlines