Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to get rid of lines in Google Sheets.
How To Get Rid Of Lines In Google Sheets
By default, Google Sheets displays narrow grey lines between rows and columns to help differentiate between cells and make the spreadsheet easier to read.
However this isn’t always desirable.
For example, if you’re creating an invoice or other document for print or PDF distribution, gridlines make it hard to tell what your document will look like when exported.
Fortunately, it only takes a few clicks to hide those lines and get a clearer view of your document. Here’s how:
If your spreadsheet has multiple tabs, be sure you’re on the tab you want to hide the lines of
Open the View menu and click on the Gridlines option
The gridlines will disappear from the current tab
Repeat as needed for any additional tabs
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to get rid of lines in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to design in Google Sheets:
- Add Borders
- Add A Line
- Add A Tab
- Change Default Font
- Change Cell Color
- Alternate Colors
- Color Code
- Make Cells Bigger
- Make A Button
- Remove Borders
- Bold Lines
- Make Paragraph
- Set Margins
- Make A Header
- Make Categories
- Make A Template
- Shift Cells Down
- How Many Sheets Can You Have?
- Create A Header
- Content Calendar
- Make All Cells The Same Size
- Outline Cells
- Remove Cell Lines
- X Out A Cell
- Group Cells
- Format Cells
- Add Serial Number