Related Posts
Every client, ever.

What is ETB department in bosch.
Additional Posts in Consulting
Top 10 books to read about consulting life ?
Top consulting firms right there!!

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.



Rising Star
Shift + Space to select a row
Alt+A+T to filter
Alt Down to open the filter menu
E to go to search
Alt ; to select only visible cells (the result of your filter)
Alt+A+C to clear all filters
I find it super annoying to see people go click click click to manipulate filters while sharing their screen 😬
M1 BCG’s cybersecurity BS has the same effect
Pro
Alt+F4.
Chief
Ctrl C + Ctrl V and Ctrl F/H are pretty much tied in my book
Pro
Ctrl+shift+plus to insert a row or column. Spam the plus button to insert a lot of them
Pro
Auto save, on
Cmd Q
Alt + H + V + V
To paste as values
Pro
Save Paste As Values to your quick access toolbar and you can do Alt+5 or whatever number it corresponds with. Alt+1 thru 9 is a shortcut for your quick access toolbar
Excellent question OP - nothing to contribute only here to learn 👀
Alt+H+C+P+P then Enter —- this will paste as a picture as it would print (great for when you are showing the blue outlines or print areas)
Not excel related, but Windows key + L is my favorite
Follow
Ctrl + Shift + L to filter
I use alt A T but this is a great one with alt down to scroll thru filter. And spacebar checks and un checks anything in the filter.
Alt + HVE
The one I use most often
Alt DFS to clear filters