Switch tabs, Move Between Open Workbooks, and Jumping to the Last Row.
How to switch between workbooks?
[Alt + Tab] This is the same shortcut to tab through all of your open workbooks. Pressing tab once brings up the selection screen. Pressing tab additional times selects the next window.
[Windows + D] Is a handy shortcut as well. ‘D’ stands for desktop. This short cut minimizes all windows. Pressing it again brings them back. To audit my open windows I like to show my desktop (Windows D) and then bring each window up at a time using (alt + Tab).
How to switch tabs?
[ctrl + page up] To move right across the tabs in your workbook to the end of the list.
[ctrl + page down] To move left across the tabs in your workbook towards the beginning of the list.
How to jump to the last row of data, across, and back?
[ ctrl + arrow keys ]You can use the arrow keys, while holding ‘ctrl’ to navigate across your table in all different directions.
Did you know there are only a handful of tools that differentiate an excel expert from an intermediate user?
Yesterday my good friend said, “Anytime someone says they are an excel expert I know they don’t know anything.” I know where he is coming from. I have the same bias. As I learn a new tool in Excel I realize how much more there is to learn. But you don’t have to know how to use every tool to be an expert. When it comes to Excel, it really is possible to become an expert in a short amount of time because there are only about a half dozen areas where people get stuck, bottlenecks. Manipulating data is one area where cut, copy, and paste is just a portion. If you would like to access my (Rho Lall’s) full mind-map, Become An Excel Expert, it covers all five areas. Just follow this link to my become an excel expert mind-map.