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

Changing a Heading to Body Text

When working on an outline of your document, you may want to demote a heading so that it is treated just like your body ...

Discover More

Counting Unique Values

Need to know a count of unique values in a range of cells? There are a couple of ways you can tackle the problem.

Discover More

Restoring the Analysis ToolPak

Add-ins for Excel, such as the Analysis ToolPak, are stored in files on your hard drive that can be deleted. If you ...

Discover More
More DriveTips

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

Deleting a Comment from a Cell

If you no longer have a need for a particular comment in a cell, you'll want to get rid of it. Here are a couple of ways ...

Discover More

Splitting Cells

Need to separate the contents of one cell into multiple cells? It's easy to do when you use the SPLIT function, as ...

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 8 + 6?

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