Anyone have any favorite shortcuts in Excel.
1. The Quick Access Toolbar: I can't believe how many people don't use this. There's so many shortcuts that can be added that are buried on the ribbon or even not on the ribbon.
2. Used the most: Navigation shortcuts like Home, End, CNTRL + Home, CNTRL + End, CNTRL + Arrow, CNTRL + PgUp/PgDown. (Drives me crazy when people slow scroll through data as I wait. LOL)CNTRL + ; or : for current date or time (or both)
F5 (GoTo) > "Special" to select Data Validation, blanks, etc.
3. One I use that I don't see a lot of other people using: CNTRL + . for maneuvering to the 4 corners of current range. Great for making sure you have the complete range selected or for moving to furthest reaches of your data when there are a lot of blanks so CNTRL + Arrow is not efficient.
4. One that a lot of people use but I don't: F10 and then letters to access specific commands on the ribbon (or numbers to access Quick Access Toolbar).
Thoughts?
Bookmarks