Salam, apakabar teman-teman, dah lama tidak bersua....
sekarang saya mau share nih mengenai shortcut di Excel.
Bagi temen-teman yang setiap hari berhadapan dengan program Excel mungkin info ini akan sangat berguna
Sumber dari ilmuexcel.blogspot.com
Berikut beberapa fungsi mempercepat pengetetikan menggunakan Ms. Excel dengan menggunakan beberapa fasilitas Shortcut key Excel
Shortcut Key Umum
Shortcut Key Editing
Shortcut Key Umum
| Ctrl + O | Open existing file |
|---|---|
| Ctrl + N | Create new workbook |
| Ctrl + S | Save current workbook |
| Ctrl + F4 | Close current workbook |
| Ctrl + Z | Undo last action |
| Ctrl + Y | Redo last action |
| Ctrl + C | Copy selection |
| Ctrl + X | Cut selection |
| Ctrl + V | Paste selction |
| Ctrl + P | Print (displays print menu and options) |
| Ctrl + S | Save file |
| F12 | Save file as |
Shortcut Key Editing
| Enter | Complete cell data entry and move to cell below. | ||
|---|---|---|---|
| Ctrl + Shift + Enter | Enter/create array formula | ||
| Alt + Enter | Start new line in the same cell. | ||
| Ctrl + Enter | Fill selected cell range with current entry. | ||
| Shift + Enter | Complete cell data entry and move to cell directly above current cell. | ||
| Tab | Complete cell data entry and move to the cell to the right. | ||
| Shift + Tab | Complete cell data entry and move to the cell to the left. | ||
| Esc | Cancel a cell entry and go back to what was there before. | ||
| Arrow Keys | Move one cell left, right, up, or down. | ||
| Home | Move to the first column (A). | ||
| F4 / Ctrl + Y | Repeat last action. | ||
| Ctrl + Shift + F3 | Create names for row and column labels. | ||
| Ctrl + D | Fill down. | ||
| Ctrl + R | Fill to the right. | ||
| Ctrl + F3 | Define a name for a cell or range of cells. | ||
| Ctrl + K | Insert a hyperlink. | ||
| Enter (after insertion of hyperlink) | Activate a hyperlink. | ||
| Ctrl + ; | Enter the current date. | ||
| Ctrl + Shift + : | Enter the current time. | ||
| Alt + Down Arrow | Display a drop-down list of the values in the current column of a list. | ||
| Ctrl + Z | Undo the last action. | ||
| Alt + F8 | Displays macro dialog box. | ||
| Alt + F11 | Displays the visual basic editor. | ||
| Ctrl + F11 | Inserts an Excel 4.0 macro sheet. |
Shortcut Key Formating Data
| Alt + ' | Display style dialog box. |
|---|---|
| Ctrl + 1 | Display format cells dialog box. |
| Shift + Spacebar | Highlight row |
| Ctrl + Spacebar | Highlight column |
| Ctrl + Shift + ~ | Apply the 'general number' format to selected cells. |
| Ctrl + Shift + $ | Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells. |
| Ctrl + Shift + % | Apply the 'percentage' format with no decimal places to selected cells. |
| Ctrl + Shift + ^ | Apply the 'exponential number' format with two decimal places to selected cells. |
| Ctrl + Shift + # | Apply the 'date' format with the day, month, and year to selected cells. |
| Ctrl + Shift + @ | Apply the 'time' format with the hour, minute, and AM or PM to selected cells. |
| Ctrl + Shift +! | Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells. |
| Ctrl + B | Apply/remove bold format to selected cells. |
| Ctrl + I | Apply/remove italic format to selected cells. |
| Ctrl + U | Apply/remove underline to selected cells. |
| Ctrl + 5 | Apply or remove 'strikethrough' to selected cells. |
| Ctrl + 8 | Displays or hides the outline of symbols. |
| Ctrl + 9 | Hide row. |
| Ctrl + Shift + 9 | Unhide row. |
| Ctrl + Shift + ( | Unhide any hidden rows within the selection. |
| Ctrl + 0 | Hide the selected columns. |
| Ctrl + Shift + ) | Unhide any columns within the selection. |
| Ctrl + Shift + & | Apply the 'border outline' to selcted cells. |
| Ctrl + Shift + _ | Remove the 'border outline' from selected cells. |
| Alt + Shift + Right Arrow | Groups selected rows or columns. |
| Alt + Shift + Left Arrow | Ungroups selected rows or columns. |
