I do not get the love for Excel. I get that it can do anything and is very flexible, but the UI is terrible.
Click a filter, get an unintuitive filter list. Filters appear over the cell awkwardly, pivot table interactions are insane, with nested menus to manage formatting and such.
Filter out a load of stuff, select copy, paste everything in between all the stuff that was filtered out.
Sheets had a great version of this where filtered was gone until filtered back in whereas foltering in excel essentially reduces the height of the row to nil
I do not get the love for Excel. I get that it can do anything and is very flexible, but the UI is terrible.
Click a filter, get an unintuitive filter list. Filters appear over the cell awkwardly, pivot table interactions are insane, with nested menus to manage formatting and such.
Filter out a load of stuff, select copy, paste everything in between all the stuff that was filtered out.
Sheets had a great version of this where filtered was gone until filtered back in whereas foltering in excel essentially reduces the height of the row to nil