When working in MS Excel, things may get a lot faster when you know a few keyboard shortcuts. Here is a non-exhaustive list of shortcuts which replace the most common operations such as opening files, saving files, copying, pasting, cutting, formatting, accessing menus and so on.
The ALT shortcuts
When working on an Excel worksheet, pressing ALT will display letters and numbers over the different menus and options (see picture to the right). Simply press ALT and one of the displayed letters to access the function or menu located under that letter. For instance, ALT+F will open the File menu whereas ALT+1 will offer to save your work. Submenus (such as the File menu) also offer shortcuts when ALT is pressed. Pressing ALT+S from the File menu thus offers to save your work. Note that it is possible to access a function which lays deep in a submenu by pressing ALT and the right combination of keys. Example: ALT+F+S will first open the File menu and then offer to save your work in a file; ALT+F+N will open the File menu and then open a new Excel workbook…
The CTRL shortcuts
…
Many other shortcuts may be found here.
