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
Word sucks. It just is not good at letting people know what they are interacting with, clicking into a template is not obvious and can cause issues.
So does excel, I realised yesterday I cant click and drag to increase a number if I have any filter at all on.
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