Collaborate better using Sheet View in Excel
HTML-код
- Опубликовано: 29 авг 2024
- Collaborating and co-authoring in Excel can be frustrating. If one person changes the worksheet view - applying filters and sorting - it applies for all users. This can be really disruptive.
Fortunately, Excel offers a feature called "Sheet View" which lets you create a temporary view just for you. In this view, your custom changes won't impact others and their custom views won't impact yours.
This is a great feature to use whenever you're working in a shared Excel file.
I swear I went to a microsoft forum ten times and they wouldn't answer this question at all. Thank you so much for actually answering! You the man!
Happens a lot to lots of people 😀
This is huge! Fabulous feature hidden in plain sight. Thanks for the tip,
Thank you Jim!
Thanks a lot dude !!! I've been looking for this topic for a long time and I finally found it.
Wonderful! Thanks a lot, Andy!
I've subscribed 😉
I noticed if filtering is disabled it disables it for everyone.
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
Nice feature and explanation, Andy. Now I just need to get my colleagues to use O365!!! ;)
Thanks for the feedback. Yep it definitely helps with collaboration when your colleagues are using the platform. 😀
Thanks Andy!
Sorry why i'' cannot edit sheet view(Sheet view) not active
It was Helpful, Thanks bro
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?
I shared my excel on one drive. however, can't open it .Excel Online it exceeds the 25 MB file size limit. any solution?
What if i add more columns or rows in view sheet and when exited i want them to show in defaulted sheet ?
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
Any idea how you can do this same thing on older sharepoint versions? Specifically Sharepoint Server 2019?
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
Thank you for watching!