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

Hyperlink Formatting

Word, as you type, normally formats hyperlinks automatically. If you don't like the way that hyperlinks look in a ...

Discover More

Printing All or Nothing

Want to make sure that when you worksheet is printed that everything in the workbook is really printed? You can ...

Discover More

Positioning the Footnote Separator

The Footnote Separator, as its name implies, separates the footnotes on each page from the text on that page. If the ...

Discover More
More DriveTips

Keeping Row and Column Headings in Sight

When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...

Discover More

Inserting Rows

As you are developing a spreadsheet, you'll often have the need to insert additional rows into your data. Sheets makes ...

Discover More

Adding a Drawing to Your Spreadsheet

Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be ...

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 6Mpixels. 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 four less than 5?

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