Macam-macam Shortcut Key Ms Excel

inulwara.blogspot.com
Ketika kita sedang melakukan entri data pada micsorsoft excel tentu akan berusaha menggunakan waktu seefisien mungkin agar data yang diolah cepat selesai, tak terkecuali dengan menggunakan cara-cara pintas yang lazim digunakan para type writers. Berikut adalah beberapa bentuk shortcut key/cara pintas yang biasa digunakan ketika kita mengoperasikan microsoft excel:

Jenis Shortcut Key
Fungsi
Lazimnya/Tanpa Shortcut Key
Ctrl+A
Select All
None
Ctrl+B
Bold
Format, Cells, Font, Font Style, Bold
Ctrl+C
Copy
Edit, Copy
Ctrl+D
Fill Down
Edit, Fill, Down
Ctrl+F
Find
Edit, Find
Ctrl+G
Goto
Edit, Goto
Ctrl+H
Replace
Edit, Replace
Ctrl+I
Italic
Format, Cells, Font, Font Style, Italic
Ctrl+K
Insert Hyperlink
Insert, Hyperlink
Ctrl+N
New Workbook
File, New
Ctrl+O
Open
File, Open
Ctrl+P
Print
File, Print
Ctrl+R
Fill Right
Edit, Fill Right
Ctrl+S
Save
File, Save
Ctrl+U
Underline
Format, Cells, Font, Underline, Single
Ctrl+V
Paste
Edit, Paste
Ctrl W
Close
File, Close
Ctrl+X
Cut
Edit, Cut
Ctrl+Y
Repeat
Edit, Repeat
Ctrl+Z
Undo
Edit, Undo
F1
Help
Help, Contents and Index
F2
Edit
None
F3
Paste Name
Insert, Name, Paste
F4
Repeat last action
Edit, Repeat. Works while not in Edit mode.
F4
While typing a formula, switch between absolute/relative refs
None
F5
Goto
Edit, Goto
F6
Next Pane
None
F7
Spell check
Tools, Spelling
F8
Extend mode
None
F9
Recalculate all workbooks
Tools, Options, Calculation, Calc,Now
F10
Activate Menubar
N/A
F11
New Chart
Insert, Chart
F12
Save As
File, Save As
Ctrl+:
Insert Current Time
None
Ctrl+;
Insert Current Date
None
Ctrl+"
Copy Value from Cell Above
Edit, Paste Special, Value
Ctrl+’
Copy Fromula from Cell Above
Edit, Copy
Shift
Hold down shift for additional functions in Excel’s menu
none
Shift+F1
What’s This?
Help, What’s This?
Shift+F2
Edit cell comment
Insert, Edit Comments
Shift+F3
Paste function into formula
Insert, Function
Shift+F4
Find Next
Edit, Find, Find Next
Shift+F5
Find
Edit, Find, Find Next
Shift+F6
Previous Pane
None
Shift+F8
Add to selection
None
Shift+F9
Calculate active worksheet
Calc Sheet
Shift+F10
Display shortcut menu
None
Shift+F11
New worksheet
Insert, Worksheet
Shift+F12
Save
File, Save
Ctrl+F3
Define name
Insert, Names, Define
Ctrl+F4
Close
File, Close
Ctrl+F5
XL, Restore window size
Restore
Ctrl+F6
Next workbook window
Window, ...
Shift+Ctrl+F6
Previous workbook window
Window, ...
Ctrl+F7
Move window
XL, Move
Ctrl+F8
Resize window
XL, Size
Ctrl+F9
Minimize workbook
XL, Minimize
Ctrl+F10
Maximize or restore window
XL, Maximize
Ctrl+F11
Inset 4.0 Macro sheet
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
Ctrl+F12
File Open
File, Open
Alt+F1
Insert Chart
Insert, Chart...
Alt+F2
Save As
File, Save As
Alt+F4
Exit
File, Exit
Alt+F8
Macro dialog box
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
Alt+F11
Visual Basic Editor
Tools, Macro, Visual Basic Editor
Ctrl+Shift+F3
Create name by using names of row and column labels
Insert, Name, Create
Ctrl+Shift+F6
Previous Window
Window, ...
Ctrl+Shift+F12
Print
File, Print
Alt+Shift+F1
New worksheet
Insert, Worksheet
Alt+Shift+F2
Save
File, Save
Alt+=
AutoSum
No direct equivalent
Ctrl+`
Toggle Value/Formula display
Tools, Options, View, Formulas
Ctrl+Shift+A
Insert argument names into formula
No direct equivalent
Alt+Down arrow
Display AutoComplete list
None
Alt+’
Format Style dialog box
Format, Style
Ctrl+Shift+~
General format
Format, Cells, Number, Category, General
Ctrl+Shift+!
Comma format
Format, Cells, Number, Category, Number
Ctrl+Shift+@
Time format
Format, Cells, Number, Category, Time
Ctrl+Shift+#
Date format
Format, Cells, Number, Category, Date
Ctrl+Shift+$
Currency format
Format, Cells, Number, Category, Currency
Ctrl+Shift+%
Percent format
Format, Cells, Number, Category, Percentage
Ctrl+Shift+^
Exponential format
Format, Cells, Number, Category,
Ctrl+Shift+&
Place outline border around selected cells
Format, Cells, Border
Ctrl+Shift+_
Remove outline border
Format, Cells, Border
Ctrl+Shift+*
Select current region
Edit, Goto, Special, Current Region
Ctrl++
Insert
Insert, (Rows, Columns, or Cells) Depends on selection
Ctrl+-
Delete
Delete, (Rows, Columns, or Cells) Depends on selection
Ctrl+1
Format cells dialog box
Format, Cells
Ctrl+2
Bold
Format, Cells, Font, Font Style, Bold
Ctrl+3
Italic
Format, Cells, Font, Font Style, Italic
Ctrl+4
Underline
Format, Cells, Font, Font Style, Underline
Ctrl+5
Strikethrough
Format, Cells, Font, Effects, Strikethrough
Ctrl+6
Show/Hide objects
Tools, Options, View, Objects, Show All/Hide
Ctrl+7
Show/Hide Standard toolbar
View, Toolbars, Stardard
Ctrl+8
Toggle Outline symbols
None
Ctrl+9
Hide rows
Format, Row, Hide
Ctrl+0
Hide columns
Format, Column, Hide
Ctrl+Shift+(
Unhide rows
Format, Row, Unhide
Ctrl+Shift+)
Unhide columns
Format, Column, Unhide
Alt or F10
Activate the menu
None
Ctrl+Tab
In toolbar: next toolbar
None
Shift+Ctrl+Tab
In toolbar: previous toolbar
None
Ctrl+Tab
In a workbook: activate next workbook
None
Shift+Ctrl+Tab
In a workbook: activate previous workbook
None
Tab
Next tool
None
Shift+Tab
Previous tool
None
Enter
Do the command
None
Shift+Ctrl+F
Font Drop Down List
Format, Cells, Font
Shift+Ctrl+F+F
Font tab of Format Cell Dialog box
Format, Cells, Font
Shift+Ctrl+P
Point size Drop Down List
Format, Cells, Font

Itulah beberapa tips shortcut key untuk Ms Excel. Shortcut key ini juga berlaku untuk Ms Word dan aplikasi office lainnya pada sistem operasi Windows. Semoga bermanfaat!

Macam-macam Shortcut Key Ms Excel Rating: 4.5 Diposkan Oleh: as