Excel Filter stumbling block - Teams / SharePoint / Excel Online

We are trying to rollout SharePoint and Teams but have hit a real stumbling block with Excel filters. A lot of our people work on shared spreadsheets and apply multiple filters. When we come to d...

migration

User Adoption

Mattwlkr
Jun 24, 2019
HustleGPTEnd users don't care for the complexities under the hood, If google can sort this out surely MS can.

Imagine being sat in a car and only one person at a time can use a window, I wouldn't buy this, and users aren't going to buy into excel online if they can't individually filter.

Mattwlkr

Tin Contributor

Oct 21, 2020

akcity Probably depends on the size of the sheet, CTRL+Home should see you to the top.

the online version is missing a few features, you may need to use the desktop version, which of course would effect the view.

akcity

Copper Contributor

Oct 21, 2020

Thanks that works Mattwlkr I suppose one of the features missing seems to be auto population of cells of identical data...

Mattwlkr
Tin Contributor
Oct 21, 2020
A few spreadsheets I have online are formatted as a table and will auto fill. Perhaps that works for you?

Forum Discussion

Excel Filter stumbling block - Teams / SharePoint / Excel Online