Shortcut Excel
Shortcut atau jalan pintas adalah salah satu cara cepat dalam melakukan suatu hal. seperti fungsinya, Microsoft Excel juga memiliki Shortcut yang bisa kita pergunakan untuk mempercepat pekerjaan kita dengan bantuan keyboard.
| SHORTCUT KEYBOARD | FUNGSI |
|---|---|
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + Alt + V | Paste Special |
| Ctrl + S | Save |
| Ctrl + Z | Undo |
| Ctrl + X | Cut |
| Ctrl + O | Open |
| Ctrl + W | Close |
| Alt + H | Home Tab |
| Alt + N | Insert Tab |
| Alt + P | Page Layout Tab |
| Alt + A | Data Tab |
| Alt + W | View Tab |
| Alt + M | Formula Tab |
| Alt + R | Review Tab |
| Ctrl + 9 | Hide the Selected Rows |
| Ctrl + 0 | Hide the Selected Colomns |
| Ctrl + 1 | Open Format Cell |
| Ctrl + Shift + P | Open Format Font |
| Shift + F2 | Add Cell Comment |
| Ctrl + Shift + Plus (+) | Open Insert dialog to insert blank cells |
| Ctrl + Minus (-) | Open Delete dialog to delete selected cells |
| Ctrl + Shift + : | Enter current time |
| Ctrl + ; | Enter current date |
| Ctrl + ` | Switch displaying cell values or formulas |
| Ctrl + 5 | Apply or remove Strikethrough Format |
| Ctrl + K | Insert Hyperlink |
| Ctrl + T | Display Create Table Dialog |
| Alt + Enter | Start new line in the same cells |
| Ctrl + Spacebar | Select an entire Colomn |
| Shift + Spacebar | Select an entire Row |
| Alt + = | Insert Total SUM |
| Ctrl + F1 | Hide or Show Tab |
| Alt + Shift + F1 | Add New Sheet |