Top Shortcuts for Microsoft Excel
The Microsoft Excel program can be very useful for many different things. Whether you use the program at work or at home, there are several shortcut keys that can make the program easier to use and can speed up your productivity. Which of these top shortcuts you will use mostly depends on what you use Excel for; some of them you may end up using very often, while not ever using the others.
Basic Shortcuts - Many of these shortcuts are the same for other Microsoft programs.
- Ctrl+C - Copy
- Ctrl+X - Cut
- Enter - Paste
- Ctrl+V - Multiple paste
- Ctrl+Z - Undo
- Ctrl+H - Find and replace
- Ctrl+F - Find
- Ctrl+S - Save
- Ctrl+P - Print
- Ctrl+F4 - Close
- Alt+F4 - Close Excel
- Ctrl+Page Down - Moves to the next sheet
- Ctrl+Page Up - Moves to previous sheet
Shortcut Specifically for Excel - These shortcuts are specific to Microsoft Excel.
- Ctrl+Spacebar - Selects columns
- Shift+Spacebar - Select rows
- Ctrl+1 - Formats cells
- Ctrl+B - Bold
- Ctrl+U - Underlines
- Ctrl+arrow - Moves to the end of the region
- Ctrl+* - Selects current region
- Ctrl+A - Select all cells
- Ctrl+Home - Select A1
- Ctrl+End - Selects last cell in range
- Ctrl+Shift+End - Selects from active cell to the last used cell in range
- Ctrl+Shift+Home - Selects from active cell to A1
- Ctrl+Tab - Moves to the next open workbook
- Ctrl+N - Opens a new workbook
- Shift+F11 - Inserts new worksheet
- Shift+F3 - Opens paste function window
- =+Function Name+Ctrl+A - Inserts new function
- Alt+F3 - Defines name
- F3 - Paste name
- Ctrl+; - Current date
- Ctrl+Shift+: - Current time