Forum Discussion

Copper Contributor

Jun 19, 2019

Solved

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.

akcity

Copper Contributor

Oct 21, 2020

Mattwlkrhi there, when I filter Excel using the shared version on Teams or Sharepoint, the filter takes the curor to the bottom of the spreadsheet that takes a few minutes to scroll up to the results. Surely that shouldnt be the case?

Also I cant filter by cell colour. I can 'sort' by cell colour but that isnt the same thing.

Also the sheet doesnt auto populate when putting the same data as the cell above.

Any help please..?

Mattwlkr
Copper 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
    Copper Contributor
    Oct 21, 2020
    A few spreadsheets I have online are formatted as a table and will auto fill. Perhaps that works for you?