How to remove the green line in google sheet?

freelancer, How To, Work at Home Nanay

There are two options in removing the green lines in google sheets which hinders you to filter all the data in the sheet.

  1. Alt A+D then F or on the menu tab click on turn off filter by clicking on the filter Icon on the google sheet.

2. Delete spaces then click the filter icon again or highlight all the data you wanted to filter then click “On filter Icon”.

The green line in the google sheet comes out when you filter data without emphasizing or highlighting the boundaries of the data you wanted to filter. It automatically detects the data which are not separated with spaces then hinders you to filter all other data which are separated by spaces. So, after removing the green line you can filter it back by removing spaces between rows or columns of the data or highlight all the data you wanted to filter.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s