Turning Off Gridlines

by Allen Wyatt
(last updated February 27, 2014)

When you first create a spreadsheet, Sheets displays the familiar grid-shaped format that most spreadsheet users know and love. There may be times, however, when the gridlines don't fit your purposes. For instance, if you are creating a spreadsheet that has quite a bit of text in it, you may find the gridlines distracting. To turn off gridlines for a spreadsheet, follow these steps:

  1. Display the spreadsheet you want to affect.
  2. Click View | Gridlines.

That's it; only two steps. The Gridlines option on the View menu is actually a toggle setting, meaning that each time you click it you alternately turn the gridlines on and off. Even though it is easy to tell if the gridlines are on or off (judging by whether they are visible or not), the Gridlines option on the View menu also displays a check mark to provide the same indication.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Setting Line Spacing in the Equation Editor

The Equation Editor can be a great boon when you need to include complex mathematical equations in your document. The editor ...

Discover More

Setting Print Ranges for Multiple Worksheets

Need the same print range set for different worksheets in the same workbook? It can't be done in one step manually, but you ...

Discover More

Determining the Hour of the Day

Need to figure out the hour represented by a particular time value? It's easy to do in a macro; just use the Hour function, ...

Discover More
More DriveTips

Adjusting Cell Alignment

To present your spreadsheet data in just the manner you want, Sheets provides tools that enable you to adjust both horizontal ...

Discover More

Filling Cells

If you need to fill information into a range of cells, one of the fastest ways of doing it is to use the fill handle. This ...

Discover More

Transposing Information in a Sheet

If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 8Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 5 + 0?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)