Excel shortcut Keys

Yin Nyine NwayJuly 23, 20106min721


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

One comment

  • Thiri

    July 24, 2010 at 1:04 am

    Excel shortcut Keys တွေ လိုချင်နေတာကြာပါပြီ၊ အခုလို မျှဝေပေးတဲ့အတွက် ကျေးဇူးအများကြီးတင်ပါတယ်၊ တခြား Program တွေရဲ့ shortcut Keys တွေရှိရင်လည်း မျှဝေပါဦးနော် …

Leave a Reply