excel အသုံးျပဳသူေတြအတြက္ shortcut key ေတြပါ….အသုံးတည္႔ျကပါေစ……..

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

About Yin Nyine Nway

Yin Nyine Nway has written 358 post in this Website..

I m web developer