A while ago, I wrote a post about 214 keyboard shortcuts. In the last few months, we have added 4 more for one reason or another, so I wanted to pass them on. (I have not updated the matrix I included as part of that post, because I accidently misplaced the file that I used to make it in the first place. At some point I will.)
In no particular order, here they are:
- Reapply Sort and Filter (to a Table or an AutoFiltered range) – CTRL+ALT+L
- Refresh (Query Table, PivotTable, etc.) = ALT+F5
- Refresh All (As above, but everything) = CTRL+ALT+F5
- Paste Special – Alt+CTRL+V
These are all things I do fairly frequently, so I think they are good additions. Your milage may vary, I guess.