Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
948 views
in Technique[技术] by (71.8m points)

filter is not working fine in google sheet

I am working with google sheet and this worked fine, but today i wanted do a filter and this is not filter all the sheet... only first 444 rows... i see this has a square and this is filter only rows inside square, but how was it added and how can i remove it?

I add the images now.. i do the filter here

enter image description here

after you could see the filter is fine (in the square after it, this is not filtering)

enter image description here

and this is the table with not filter

enter image description here


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

From the images your filter is defined only for a specific range, which is up to row 444. This was done when Data -> Create Filter menu option was used when a range is already selected.

You can delete this filter by selecting Data -> Turn off Filter, then recreating another for the whole sheet by selecting the first cell in the whole sheet, then selecting Data -> Create Filter again.

Before creating filter, range selected:

enter image description here

After creating filter, range selected:

enter image description here

Before creating filter, single cell selected:

enter image description here

After creating filter, single cell selected:

enter image description here


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...