Back
Excel

4 More Shortcut Keys

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.