We have been posting about Microsoft Office Excel tips, we also posted about several Excel Shortcuts, and some of these shortcuts were quite uncommon as well.
Here is another list of Shortcuts; most of them are basic shortcuts which could be quite helpful to you, if you work with Excel pretty often.
Print and Preview Documents using shortcut keys –
| Display the Print command | CTRL+P |
Work in print preview –
| Move around the page when zoomed in | Arrow keys |
| Move by one page when zoomed out | PAGE UP or PAGE DOWN |
| Move to the first page when zoomed out | CTRL+UP ARROW or CTRL+LEFT ARROW |
| Move to the last page when zoomed out | CTRL+DOWN ARROW or CTRL+RIGHT ARROW |
Outline data by using shortcut key –
| Ungroup rows or columns | ALT+SHIFT+LEFT ARROW |
| Group rows or columns | ALT+SHIFT+RIGHT ARROW |
| Display or hide outline symbols | CTRL+8 |
| Hide selected rows | CTRL+9 |
| Unhide selected rows | CTRL+SHIFT+ ( |
| Hide selected columns | CTRL+0 (ZERO) |
| Unhide selected columns | CTRL+SHIFT+) |
Keys for menus –
| Show a shortcut menu | SHIFT+F10 |
| Make the menu bar active | F10 or ALT |
| Show the program icon menu (on the program title bar) | ALT+SPACEBAR |
| Select the next or previous command on the menu or submenu | DOWN ARROW or UP ARROW |
| Select the menu to the left or right, or, with a submenu visible, switch between the main menu and the submenu | LEFT ARROW or RIGHT ARROW |
| Select the first or last command on the menu or submenu | HOME or END |
| Close the visible menu and submenu at the same time | ALT |
| Close the visible menu, or, with a submenu visible, close the submenu only | ESC |
Keys for using the Office Assistant –
| Make the Office Assistant the active balloon | ALT+F6 (repeat until the balloon is active) |
| Select a Help topic from the topics displayed by the Office Assistant | ALT+topic number (where 1 is the first topic, 2 is the second, and so on) |
| See more help topics | ALT+DOWN ARROW |
| See previous help topics | ALT+UP ARROW |
| Close an Office Assistant message | ESC |
| Get Help from the Office Assistant | F1 |
| Display the next tip | ALT+N |
| Display the previous tip | ALT+B |
| Close tips | ESC |
| Show or hide the Office Assistant in a wizard | TAB to select the Office Assistant button; SPACEBAR to show or hide the Assistant |
Keys for toolbars –
| Make the menu bar active | F10 or ALT |
| Select the next or previous toolbar | CTRL+TAB or CTRL+SHIFT+TAB |
| Select the next or previous button or menu on the toolbar | TAB or SHIFT+TAB (when a toolbar is active) |
| Open the selected menu | ENTER |
| Perform the action assigned to the selected button | ENTER |
| Enter text in the selected text box | ENTER |
Hope you find them useful, go ahead and get them printed to keep handy.
