Almost everyone uses Microsoft Excel for various document purposes in the modern work world. But many of us might not use it efficiently and quickly. Therefore, to help you work faster with this software, we have collected 78 of the best excel shortcut keys that you must know.
Keyboard shortcuts or Excel shortcut keys can definitely increase your speed when doing work. But often, it’s hard to remember this hotkey – especially if you regularly switch between the latest versions of Office. For example from office 2010 to office 2019. Of course there are a number of key shortcuts that have changed. But in truth, the button is still the same.
Shortcut Keyboard Microsoft Excel
All of the following Excel keyboard shortcuts have been tested on the latest version of Microsoft Office 2019 . So if there is a slight difference in the previous version, please correct the comments below.
Also make sure you use a standard QWERTY keyboard that has all the universal keys.
Shortcut Key Excel : DOKUMEN dan WORKSHEET
| SHORTCUT | FUNCTION |
|---|---|
| Ctrl + N | Create a new file (New File) |
| Ctrl + O | Membuka file XLS (Open File) |
| Ctrl + S | Saving a Document (Save) |
| Ctrl + Shift + S | Save Document with a New Name (Save As) |
| Ctrl + P | Printing a Document (Print) |
| Ctrl + F2 | Preview Before Print (Print Preview) |
| Ctrl + W | Menutup Workbook Excel (Close Workbook) |
| Shift + F11 | Create a new worksheet |
| Ctrl + Page Down | Previous worksheet |
| Ctrl + Page Up | Next worksheet |
| Ctrl + Tab | Next workbook |
| Ctrl + Shift + Tab | Previous workbook |
DATA SETTINGS
| SHORTCUT | FUNCTION |
|---|---|
| Ctrl + C | Duplicate Data (Copy) |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + Alt + V | Paste Special |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + F | Find |
| Ctrl + Shift + F4 | Find Previous |
| Shift + F4 | Find Next |
| Ctrl + H | Find dan Replace |
WORKBOOK NAVIGATION
| SHORTCUT | FUNCTION |
|---|---|
| Arrow | Slide One Cell (Left, Right, Up, Down) |
| Page Up | Scroll up one screen |
| Page Down | Scroll down one screen |
| Alt + Page Up | Scroll to the right of one screen |
| Alt + Page Down | Scroll to the left of one screen |
| Ctrl + End | Move to the last cell |
| Ctrl + Home | Move to the starting cell |
| Ctrl + F1 | Showing / Hiding the Ribbon |
| Alt | Showing shortcut for the Ribbon |
| Ctrl + Backspace | Return to Active Cell |
SELECTING CELLS
| SHORTCUT | FUNCTION |
|---|---|
| Ctrl + G | Go To |
| Ctrl + A | Select all |
| Ctrl + Space | Select column |
| Shift + Space | Select row |
| Shift + Arrow | Expand select cells |
| Ctrl + Shift + Arrow | Expand selection full cells |
| F8 | Toggle selection extend mode |
| Shift + F8 | Toggle selection add mode |
| Ctrl + Shift + O | Only select cells have comments |
| Shift + Page Up | Expand selection full screen keatas |
| Shift + Page Down | Expand selection full screen kebawah |
EDITING DATA CELLS
| SHORTCUT | FUNCTION |
|---|---|
| Enter | Change data and move cells down |
| Shift + Enter | Change the data and move the cell up |
| Tab | Change the data and move the cell to the right |
| Shift + Tab | Change the data to move cell to the left |
| Shift + F2 | Provides comments in the cell |
| Ctrl + K | Provides hyperlinks to cells |
| Ctrl + ; | Insert today’s date |
| Ctrl + Shift + ; | Insert the current hour |
| Ctrl + D | Duplicate data from the cell above |
| Ctrl + R | Duplicate data from the left cell |
| Ctrl + ` | Display Formulas in all cells |
| Alt + = | Auto Sum selected cell |
| Alt + Enter | New paragraph line in cell |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
FORMATTING CELLS
| SHORTCUT | FUNCTION |
|---|---|
| Ctrl + Shift + ~ | Change cell format to general |
| Ctrl + Shift + $ | Change cell format to currency |
| Ctrl + Shift + % | Change cell format to percentage |
| Ctrl + Shift + ^ | Change cell format to scientific |
| Ctrl + Shift + # | Set the cell format as date |
| Ctrl + Shift + @ | Set the cell format as time |
| Ctrl + Shift + ! | Set the cell format as a number |
| Ctrl + Shift + & | Border selected region |
| Ctrl + Shift + _ | Remove the border |
LINE FORMATTING AND COLUMN
| SHORTCUT | FUNCTION |
|---|---|
| Ctrl + Shift + (+) | Insert rows, collumns, shift cell down, shift cell right |
| Ctrl + Delete | Menghapus rows, collumns, shift cell down, shift cell right |
| Alt + Shift + Right Arrow | Select and create groups |
| Alt + Shift + Left Arrow | Do an ungroup |
Shortcut Key Excel : CHARTS, FILTERS, PIVOTS
| SHORTCUT | FUNCTION |
|---|---|
| Alt + F1 | Make a chart |
| F11 | Make a chart on the new sheet |
| Ctrl + Shift + L | Autofilter |
| Alt + Down Arrow | Show filter options (Insert filter) |
| Ctrl + T | Inserta table |
| Alt > D > P | Enter the Pivot table wizard |
Are there other Excel key shortcuts that we haven’t mentioned above? Write it in the comments column and we will add it. May be useful!