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

Converting Between Buddhist and Gregorian Calendar Systems

Converting from one calendar system to another can be a challenge. The key is identifying the differences between the ...

Discover More

More than Three Conditional Formats

Conditional formatting is a great feature for making the data in your worksheets more understandable and usable. What if ...

Discover More

Getting Audible Feedback

You can add a bit of sound to your editing tasks by turning on Word's sound capabilities. This tip shows where this ...

Discover More
More DriveTips

Grading Assignments with Flubaroo

Flubaroo is a third-party extension for Sheets that can help make grading classroom papers fast and easy. Here's a quick ...

Discover More

Using Find and Replace in a Spreadsheet

As your spreadsheets get larger, it can be hard to find some information. You may also want to replace some existing ...

Discover More

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
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 one less than 9?

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