Can't sort in Google Sheets

attv

New Member
Joined
Mar 10, 2021
Messages
35
Office Version
  1. 2019
Platform
  1. Windows
Hi - I have a dumb question as I did something in Google Sheets and cannot sort stuff right...

As you see in the attached screen, "SOMETHING" after cell 48 prevents sorting any other cells from 49, 50, and next. Even numbers of cells on the sides up to 48 are highlighted in green, whereas everything from 49 and up is in grey.

Does anyone have any idea what is messed up? Why can't I sort stuff beyond cell 48?

chrome_ViwHhA56z7TURNOVER_-_KALIBRATE_-_Google_Sheets_-_Google_Chrochrome.jpg
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You have applied a filter to the rows up to row 48. You need to clear that and then reapply including your additional rows.
 
Upvote 0
Dang, you're right. This is weird because I had dozens of od sheets and no problem like this before. Didn't even struck me it can be this easy, usually filters just apply to other new rows as well
 
Upvote 0

Forum statistics

Threads
1,224,945
Messages
6,181,934
Members
453,074
Latest member
JefersonKollet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top