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.

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