Shortcuts of Microsoft Excel

 Excel Shortcuts

Excel အသုံးပြုသူများလွယ်ကူစေရန်ပြန်လည်မျှဝေပေးပါသည်။ Word သို့မဟုတ် Text File ဖြင့် Copy ယူကာ Print Out လုပ်၍အသုံးပြုနိုင်ပါသည်။

Ctrl + N - New Worksheet

Ctrl + A - Select All

Ctrl + B - Bold

Ctrl + I  - Italic

Ctrl + U - Underline

Ctrl + R - Full Right

Ctrl + S - Save

Ctrl + O - Open

Ctrl + W - Close

Ctrl + C - Copy

Ctrl + V - Paste

Ctrl + X - Cut

Ctrl + Z - Undo

Ctrl + D - Fill Down

Ctrl + F - Find

Ctrl + G - Goto

Ctrl + H - Replace

Ctrl + : - Insert Current Time

Ctrl + ; - Insert Current Date

Ctrl + " - Copy Value From Cell Above

Ctrl + ' - Copy Formula From Cell Above

Ctrl + + - Insert

Ctrl + - - Delete

F1 - Help

F2 - Edit

F3 - Paste Name

F4 - Repeat Last Action

F5 - Goto

F6 - Next Pane

F7 - Spell Check

F8 - Extend Mode

F9 - Recalculate All Workbooks

F10 - Active Menubar

F11 - New Chart

F12 - Save As

Ctrl + F3 - Define Name

Ctrl + F4 - Close

Ctrl + F5- XL, Restore Window Size

Ctrl + F6 - Next Workbook Window

Ctrl + F12 - File Open

Shift+ F1 - What's This?

Shift+ F2 - Edit Cell Comment

Shift+ F3 - Paste Function Into Formula

Shift+ F4 - Find Next

Shift+ F5 - Find

Shift+ F6 - Previous Pane

Shift+ F8 - Add To Selection

Shift+ F9 - Calculat Active Worksheet

Shift+ F10 - Display Shortcut Menu

Shift+ F11 - New Worksheet

Shift+ F12 - Save

Alt + F1 - Insert Chart

Alt + F2 - Save As

Alt + F4 - Exit

Alt + F11 - Visual Basic Editor

Alt + F1 - File Open

Alt + = - Auto Sum

Alt + Down Arrow  - Display Auto Complete List

Alt + Shift + F1 - New Worksheet

Ctrl + Shift + ~ - General Format

Ctrl + Shift + ! - Comma Format

Ctrl + Shift + @ - Time Format

Ctrl + Shift + # - Date Format

Ctrl + Shift + $ - Currency Format

Ctrl + Shift + % - Percent Format

Ctrl + Shift + ^ - Exponential Format

Ctrl + Shift + & - Place Outline Border Around Selected Cells

Ctrl + Shift + _ - Remove Outline Border

Ctrl + Shift + A - Insert Argument Names Into Formula

Ctrl + Shift + F3 - Create Name By Using Names of Row and Column Labels

Ctrl + Shift + F6 - Previous Window

Ctrl + Shift + F12 - Print

crd to Original Uploader


ပြန်လည်‌ဝေမျှပေးလိုက်ပါတယ်......

ကျေးဇူးတင်ပါတယ်...........

မင်္ဂလာရှိသောနေ့လေးကိုပိုင်ဆိုင်နိုင်ပါစေ.......

Comments