Photo Courtesy of PC World
"There are tons of shortcuts for Excel out there—here’s a list of 200 for Excel 2013 alone. But trying to learn such a large number can be overwhelming, confusing, and ultimately inefficient.
Instead, we’ve put together a list of 15 shortcuts that will be immediately useful for most users. This keyboard shortcut lists includes quick ways to format cells, navigate the program, and carry out a few operations.
The list is based on Excel 2016, but most will also work on Excel 2013. When that’s not the case we’ve noted it."
Keyboard access to the ribbon: Similar to the Vim-inspired add-ons for Chrome and Firefox, Excel 2013 and 2016 have a feature called Key Tips. When Key Tips appears by pressing Alt the Ribbon menu is overlaid with letters. Pressing a letter launches the corresponding menu item.
- Ctrl + PgDn: Switch between worksheet tabs, moving left to right.
- Ctrl + PgUp: Switch between worksheet tabs, moving right to left.
- F12: Display the “Save As” dialog.
- Ctrl + Shift + $: (Excel 2016) Current cell formatted as currency, with two decimal places and negative numbers in parentheses.
- Ctrl + Shift + %: (Excel 2016) Current cell formatted as percentage with no decimal places.
Read more at PC Mag