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

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

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

• 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