Show / Hide Gridlines in Google Sheets (in less than 5 seconds)

Just like most of the spreadsheet tools, Google Sheets also have gridlines around the cells in it.

These gridlines make it easy for you to clearly see the data and read it.

But sometimes you may not want the gridlines.

Maybe you only want the gridlines in the data that you’re working on and you want to hide the gridlines everywhere else.

Hide Gridlines in Google Sheets

In this tutorial, I would show you how to hide the gridlines in Google sheets when you are working with the worksheet in the tools as well as when you want to print the data.

So let’s get started!

Hide Gridlines in the Worksheet in Google Sheets

Below are the steps to hide the gridlines in Google sheets worksheet:

  1. Select the worksheet in which you want to hide the gridlines
  2. Click the View button in the menuClick the View button in the menu
  3. In the drop-down that opens, click the Gridlines options. This will uncheck the Gridlines optionsUncheck the Gridline Option in Google Sheets

The above steps will remove the gridlines from the entire worksheet.

Gridlines option in Google Sheets works as a toggle. If you follow the above steps and click on the Gridline option again, it will bring back the gridlines in the worksheet.

In case you only want to show gridlines to a specific area in the worksheet and remove it from everywhere else, follow the above steps to remove the gridlines from the entire worksheet and then select and apply the border to the cells/range where you want the gridlines.

Apply border to cells or range in Google Sheets

Hide Gridlines in Google Sheets when Printed

When you remove the gridlines from the worksheet (using the above steps), these would not be printed.

However, if you want to keep the gridlines in the worksheet but not have these printed, you can do that too. Google Sheets has a setting that you can change when you’re printing the worksheet.

Below are the steps to do this:

  1. Select the range that you want to print (you can also select the entire worksheet in case you want to print the entire used range).
  2. Click the File button in the menu Click the file button in the menu
  3. Click the Print option (you can also use the keyboard shortcut – Control + P)Click the Print Option
  4. In the Print Settings page, click on the Formatting option (in the right-pane)
  5. Uncheck the Show Gridlines option.Uncheck Show Gridlines option to not print these

The above steps ensure that although you have gridlines in the worksheet, these are not printed.

You May Also Like the following Google Sheets Tutorials:

FREE EBOOK - GOOGLE SHEETS TIPS

10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.

>