إختصارات الإكسيل

إختصارات الإكسيل 

 

السلام عليكم و رحمة الله 

مجموعة من الإختصارات المفيدة في الإكسيل 

 

  • F1: Help
  • F2: Edit
  • F4: Repeat Action
  • F5: Open Goto Dialog Box
  • F6: Next Pane
  • F7: Spell Check
  • F8: Extend Selection Mode
  • F9: Calculate All
  • F10: Activate Menu
  • F11: New Chart
  • F12: Save As
  • =: Formula
  • Insert: Insert Mode
  • Delete: Delete Active Cell’s Contents
  • Home: Go to the Beginning of the Row
  • End: Go to the End of the Row
  • Page Up: Page Up
  • Page Down: Page Down
  • Left Arrow: Move Left
  • Right Arrow: Move Right
  • Up Arrow: Move Up
  • Down Arrow: Move Down
  • Space Bar: Space
  • Tab: Move Right
  • Shift+F1: What’s This Help
  • Shift+F2: Edit Comment
  • Shift+F3: Insert Function
  • Shift+F4: Find Again (With Find Open)
  • Shift+F5: Find
  • Shift+F6: Previous Pane
  • Shift+F8: Add To Selection
  • Shift+F9: Calculate Worksheet
  • Shift+F10: Right Click Menu
  • Shift+F11: New Worksheet
  • Shift+F12: Save
  • Shift+Left Arrow: Select Left
  • Shift+Right Arrow: Select Right
  • Shift+Up Arrow: Select Up
  • Shift+Down Arrow: Select Down
  • Shift+Space Bar: Select Row
  • Shift+Tab: Move Left
  • Ctrl+F3: Open Name Manager
  • Ctrl+F4: Close Window
  • Ctrl+F5: Restore Window Size
  • Ctrl+F6: Next Workbook
  • Ctrl+F7: Move Window
  • Ctrl+F8: Resize Window
  • Ctrl+F9: Minimize Workbook
  • Ctrl+F10: Restore Workbook
  • Ctrl+F11: New Macro Sheet
  • Ctrl+F12: Open
  • Ctrl+A: Select All 
  • Ctrl+B: Bold Selection
  • Ctrl+C: Copy Selection
  • Ctrl+D: Fill Down
  • Ctrl+F: Open Find Menu
  • Ctrl+G: Open Goto Dialog Box
  • Ctrl+H: Open Find/Replace Menu
  • Ctrl+I: Italicize Selection
  • Ctrl+K: Insert Hyperlink
  • Ctrl+N: New Workbook
  • Ctrl+O: Open Workbook
  • Ctrl+P: Print
  • Ctrl+R: Fill Right
  • Ctrl+S: Save
  • Ctrl+U: Underline Selection
  • Ctrl+V: Paste
  • Ctrl+W: Close Workbook
  • Ctrl+X: Cut
  • Ctrl+Y: Redo
  • Ctrl+Z: Undo
  • Ctrl+`: Toggle Formula View
  • Ctrl+1: Open Format Cell Menu
  • Ctrl+2: Bold Selection
  • Ctrl+3: Italicize Selection
  • Ctrl+4: Underline Selection
  • Ctrl+5: Strikethrough Selection
  • Ctrl+8: Outline
  • Ctrl+9: Hide Selected Rows
  • Ctrl+0: Hide Selected Columns
  • Ctrl+-: Delete Selection
  • Ctrl+[: Go to Dependents
  • Ctrl+]: All Dependents
  • Ctrl+;: Insert Date
  • Ctrl+/: Select Array
  • Ctrl+: Select Differences
  • Ctrl+Insert: Copy
  • Ctrl+Delete: Delete To End Of Line
  • Ctrl+Home: Start Of Worksheet
  • Ctrl+End: End Of Worksheet
  • Ctrl+Page Up: Previous Worksheet
  • Ctrl+Page Down: Next Worksheet
  • Ctrl+Left Arrow: Move to Next Cell With Data to Left
  • Ctrl+Right Arrow: Move to Next Cell With Data to Right
  • Ctrl+Up Arrow: Move to Next Cell With Data Above
  • Ctrl+Down Arrow: Move to Next Cell With Data Below
  • Ctrl+Space Bar: Select Column
  • Ctrl+Tab: Next Window
  • Ctrl+BackSpace: Goto Active Cell
  • Alt+F1: Insert Chart in Current Sheet
  • Alt+F2: Save As
  • Alt+F4: Quit Excel
  • Alt+F6: Switch To VBA
  • Alt+F8: Open Macro List
  • Alt+F11: Open VB Editor
  • Alt+D: Open Data Menu
  • Alt+E: Open Edit Menu
  • Alt+F: Open File Menu
  • Alt+H: Open Help Menu
  • Alt+I: Open Insert Menu
  • Alt+O: Open Format Menu
  • Alt+T: Open Tools Menu
  • Alt+W: Open Window Menu
  • Ctrl+Shift+F3: Create Names From Selection
  • Ctrl+Shift+F6: Previous Workbook
  • Ctrl+Shift+F12: Print
  • Ctrl+Shift+A: Formula Arguments
  • Ctrl+Shift+F: Fomat Cells Font Tab
  • Ctrl+Shift+O: Select Comments
  • Ctrl+Shift+P: Fomat Cells Font Tab
  • Ctrl+Shift+`: Format Cells – General Format
  • Ctrl+Shift+1: Format Cells – Number Format
  • Ctrl+Shift+2: Format Cells – Time Format
  • Ctrl+Shift+3: Format Cells – Date Format
  • Ctrl+Shift+4: Format Cells – Currency Format
  • Ctrl+Shift+5: Format Cells – Percent Format
  • Ctrl+Shift+6: Format Cells – Exponent Format
  • Ctrl+Shift+7: Format Cells – Apply Border
  • Ctrl+Shift+8: Select Region
  • Ctrl+Shift+9: Unhide Rows
  • Ctrl+Shift+0: Unhide Columns
  • Ctrl+Shift+-: Format Cells – Remove Border
  • Ctrl+Shift+=: Open Insert Dialog Box
  • Ctrl+Shift+[: Direct Precedents
  • Ctrl+Shift+]: All Precedents
  • Ctrl+Shift+;: Insert Time
  • Ctrl+Shift+’: Copy Cell Value Above
  • Ctrl+Shift+/: Select Array
  • Ctrl+Shift+: Select Unequal Cells
  • Ctrl+Shift+Space Bar: Select All
  • Ctrl+Shift+Tab: Previous Window

 

 

دمتم في حفظ الله 

 

يحيى حسين 

Excel MVP 

اترك تعليقك

الاسم
:
 

البريد الإلكتروني
:
 


رقم الهاتف
:
 
 


التعليق
:
 

التعليقات