Kumpulan Shortcut Key Excel

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

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.