Forum Discussion
How do you automatically remove filters from an online excel doc on sharepoint?
Apologies but this is all new to me and I am a teacher thrown in at the deep end with the current situation. I currently have a whole school excel online spreadsheet on sharepoint so that multipl...
MMCCarte34 Hi there. First you should tell your students to apply the filters ONLY to them (individual).
To clean all the filters applied go to
Spoiler
DATA tab
click
Spoiler
CLEAR
in the SORT & FILTERS box.
LG
Luis_Guicho Your screenshots are not from Excel Online (the browser version) which I believe the OP was asking about. I have a similar issue. I see in Excel Online that filters are active in some columns, but no matter what I do - highlight the cells or the entire row with the columns - the Clear button in Data tab remains grayed out. In the Excel app this works fine.
Thank you for this however the issue is that staff are not clearing filters. This then affects the next user and so on.
I need it to be done for them. Some staff are not coping well with this transition and are not IT literate no matter how many times they are supported.
Is there anyway to set it up that the document automatically removes all filters when the exit the document?
- You should tell your fellow teachers and students when they choose filters choose the option "apply only to me". This will not affect other users.
OK. Will they still need to clear their filters when they have finished adding data?
Thank you so much. Its a total headache for a large school staff.
