If scroll lock is on then move whole screen up by one row If scroll lock is on: moves to the top-left cell of the visible excel workspace If not in edit mode: Deletes cell content without entering edit mode If in edit mode: toggles overtype mode on and off If not in edit mode: toggle ribbon shortcuts (key tips) and quick access toolbar shortcuts ON The keys mentioned in orange-like colour are my personal favourite. You can access the interactive list of keyboard shortcuts by clicking the green button and it will let you sort, filter and many other things to let you find the keyboard shortcut you want. I used Excel 2010 as a base version to collect all the shortcuts of Excel in one place. In coming days I will update the list with shortcuts in version 20 with details if they are compatible across versions etc. However, collecting all the shortcuts across different versions is a big feat but it must be done. As I have found that many users are still using Excel 20 version so a keyboard shortcuts only Excel 2013 version won’t suffice. The following collection of shortcuts is still a work in progress.
These are pure productivity enhancement toppings that everyone craves to learn and know as many as they can as they not only speeds up things but also gives you freedom of multiple input devices at one time. Microsoft Excel’s best side is its shortcuts.
0 kommentar(er)
