Technology

Delete horizontal lines in Google Sheets: Simplify your spreadsheet quickly

Deleting rows in Google Sheets on your computer and phone is an easy way to optimize the spreadsheet interface and make your data more streamlined and easier to observe. Check out the following articles to learn how to do it!

Administrator

26 December, 2023

169

During working on Google Sheets on computers and phones, there are times when we want to remove gridlines to make the spreadsheet look clean and easy to read. Gridlines usually appear by default in spreadsheets, but there are various ways to effectively remove them. By following the simple steps below, you can optimize the appearance of your spreadsheet and manage your data by quickly removing gridlines in Google Sheets.

1. Notes when removing gridlines in Google Sheets

When you remove gridlines in Google Sheets, keep in mind the following important points:

Data is not deleted: Hiding gridlines does not delete data. Data in hidden rows still exists in the spreadsheet and can be displayed again anytime.
Comments or instructions: If you share the spreadsheet with others, provide instructions or comments about hiding gridlines if necessary for others to understand how the spreadsheet works.

Remember that hiding gridlines can help optimize the appearance of the spreadsheet, but it should be done carefully to preserve the integrity of the data.

2. Removing gridlines in Google Sheets on computers

To remove gridlines in Google Sheets on computers, you can follow these steps:

Step 1: Start by opening the Google Sheets document you want to work on.

Step 2: Click the View tab → Select Show.

Step 3: Uncheck the Gridlines option to hide all the gridlines in the spreadsheet.

Now all the gridlines in your spreadsheet have been successfully removed, and the spreadsheet will be displayed as shown in the instructional screen.

3. Removing gridlines in Google Sheets on phones

Step 1: Access Google Sheets on your phone. If it is not available, you can install it on your device using the following links:

On Android phones.
On iPhones.

Step 2: Choose the Spreadsheet you want to remove gridlines → Tap the triangle icon next to your Spreadsheet Name.

Step 3: In the Gridlines section, switch the toggle button ON to the left to turn off this feature, and your spreadsheet will no longer display the gridlines.

4. Removing gridlines in Google Sheets for printing

To remove gridlines in Google Sheets when preparing for printing, you can follow these steps:

Step 1: Click the File tab → Select Print.

Step 2: In the print settings, expand the Formatting section → Uncheck the Show gridlines option and you’re done.

This article has just guided you on how to remove gridlines in Google Sheets on phones and computers easily. If you find it helpful, you can share this article with your friends and family to let them know! Wish you success in implementing these steps!