Collaborate better using Sheet View in Excel

Any idea how you can do this same thing on older sharepoint versions? Specifically Sharepoint Server 2019?

Thanks Andy. Very helpful indeed.
How do I prevent multiple collaborators editing each other's entries. In other words, I want my students to provide certain information in the same sheet, but I don't want to allow anyone edit another's text. Is there a way to do this?

It was Helpful, Thanks bro

Hi Andy, related question, is there any tip for "Custom View" to work on sheets with Tables? I'd like to hide/show few columns

I noticed if filtering is disabled it disables it for everyone.

Thanks Andy!

Hi, can we disable the option see everyone's by just keeping just see mine option, while multiple users are accessing the excel for filtering.

Thank you

I shared my excel on one drive. however, can't open it .Excel Online it exceeds the 25 MB file size limit. any solution?

But this doesn't work for hidden columns/cells. Do you know a way where only myself can see hidden columns/row? Everytime i do it at work, it affect everybody's work? Thank you in advance

This is huge! Fabulous feature hidden in plain sight. Thanks for the tip,

Nice feature and explanation, Andy. Now I just need to get my colleagues to use O365!!! ;)