Basic MS Excel Shortcuts every user should know

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.


Please enter your comment!
Please enter your name here