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

Assigning a Shortcut Key to Styles

Shortcut keys are a great way to apply styles to text in a document. You can easily create a shortcut key assignment for ...

Discover More

No More Custom Formats Can Be Added

If you make too many formatting changes to your workbook, you could end up with a situation where you cannot make any ...

Discover More

Forcing Dates Forward

Want to push a date to some pre-defined day of the month? Here are some ways to force the issue.

Discover More
More DriveTips

Copying a Spreadsheet

There are times when you don't want to mess up a spreadsheet, but you want to try out some changes. This is when making a ...

Discover More

Changing where a Spreadsheet is Stored

Get lots of files into Drive, and sooner or later you'll want to organize them in some way. Sheets includes a great ...

Discover More

Searching for a Term in Sheets

Got a need to search the web for more information on something within a spreadsheet? Believe it or not, Sheets provides a ...

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 seven more than 3?

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