Forum Discussion

Mattwlkr's avatar
Mattwlkr
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's avatar
    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's avatar
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's avatar
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's avatar
    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's avatar
      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?

Resources