In this shortcut keys in excel tutorial, we will learn popular keyboard shortcuts used with the excel. Using a keyboard shortcut helps the user to work in excel more efficiently.
Keyboard shortcut keys speed up our work. Microsoft Excel has a rich library of shortcut keys, Here, we will discuss some popular shortcut keys used on a daily basis.
Shortcut Keys for Excel Workbook
Microsoft Excel has some specific shortcut keys to work with the workbook.
| Shortcut Key | Description |
|---|---|
| CTRL+N | Create a new workbook |
| CTRL+O | Open an existing workbook |
| CTRL+S | Save a workbook |
| CTRL+W | Close a workbook |
| CTRL+F9 | Minimise the workbook |
Shortcut Keys for Excel Worksheet
The Excel has some useful shortcut keys related to worksheets, you must know.
| Shortcut Key | Description |
|---|---|
| SHIFT+F11 | New worksheet |
| CTRL+PageUp | Move to the previous(left) worksheet. |
| CTRL+PageDn | Move to the next(right) worksheet. |
| ALT+W+Q | Zoom, open zoom window |
Excel Shortcut Keys for Cell
Excel has many shortcut keys to use with excel cells.
| Shortcut Key | Description |
|---|---|
| CTRL+Up Arrow | Move to the top cell |
| CTRL+Down Arrow | Move to the bottom cell |
| CTRL+Home | Move to the first cell(A1). |
| SHIFT+Space | Select entire row. |
| CTRL+Space | Select entire column. |
| ALT+H+O+I | Auto width column |
General Shortcut Keys
Here are some general shortcut keys, we can use in excel and as well as in any computer applications.
| Shortcut Key | Description |
|---|---|
| CTRL+N | Create a new workbook |
| CTRL+O | Open an existing workbook |
| CTRL+S | Save a workbook |
| CTRL+A | Select All |
| CTRL+C | Copy selected data |
| CTRL+X | Cut selected data |
| CTRL+V | Paste copied data |
| CTRL+Z | Undo, cancel or reverse the work |
| CTRL+R | Redo, do again |
Using shortcut keys you can work fast rather than using a mouse. By doing regular practice of these keyboards shortcuts, you will be an expert user of the Microsoft Excel. You can visit the pages of our social site for a regular update on the shortcut and popular excel functions.