Thursday, February 16, 2012

ពាក្យបញ្ជា Shortcut នៅក្នុង Excel


នេះគឺជា Shortcut Key ដែលមានការប្រើប្រាស់ជាញឹកញាប់ នៅក្នុង Microsoft Excel ហើយអាចជួយ​ឲ្យយើងធ្វើការបានលឿនទៀតផង ។

Shortcut Key
Functions
F2
Edit the selected cell
F5
Goto a specific cell. For example, C6.
F7
Spell check selected text and/or document
F11
Create chart
Ctrl + Shift + ;
Enter the current time
Ctrl + ;
Enter the current date
Alt + Shift + F1
Insert New Worksheet
Shift + F3
Open the Excel formula window
Shift + F5
Bring up search box
Ctrl + A
Select all contents of the worksheet
Ctrl + B
Bold highlighted selection
Ctrl + I
Italic highlighted selection
Ctrl + K
Insert link
Ctrl + U
Underline highlighted selection
Ctrl + 5
Strikethrough highlighted selection
Ctrl + P
Bring up the print dialog box to begin printing
Ctrl + Z
Undo last action
Ctrl + F9
Minimize current window
Ctrl + F10
Maximize currently selected window
Ctrl + F6
Switch between open workbooks / windows
Ctrl + Page up
Move between Excel work sheets in the same Excel document
Ctrl + Page down
Move between Excel work sheets in the same Excel document
Ctrl + Tab
Move between Two or more open Excel files
Alt + =
Create a formula to sum all of the above cells
Ctrl + ‘
Insert the value of the above cell into cell currently selected
Ctrl + Shift + !
Format number in comma format
Ctrl + Shift + $
Format number in currency format
Ctrl + Shift + #
Format number in date format
Ctrl + Shift + %
Format number in percentage format
Ctrl + Shift + ^
Format number in scientific format
Ctrl + Shift + @
Format number in time format
Ctrl + Arrow key
Move to next section of text
Ctrl + Space
Select entire column
Shift + Space
Select entire row

0 បញ្ចេញមតិ:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More