Shortcut key
Shortcut key
Action
| Menu equivalent
comments
| Version
| Ctrl+A
| Select All
| None
| All
| Ctrl+B
| Bold
| Format, Cells, Font, Font Style, Bold
| All
| Ctrl+C
| Copy
| Edit, Copy
| All
| Ctrl+D
| Fill Down
| Edit, Fill, Down
| All
| Ctrl+F
| Find
| Edit, Find
| All
| Ctrl+G
| Goto
| Edit, Goto
| All
| Ctrl+H
| Replace
| Edit, Replace
| All
| Ctrl+I
| Italic
| Format, Cells, Font, Font Style, Italic
| All
| Ctrl+K
| Insert Hyperlink
| Insert, Hyperlink
| Excel 97/2000
| Ctrl+N
| New Workbook
| File, New
| All
| Ctrl+O
| Open
| File, Open
| All
| Ctrl+P
| Print
| File, Print
| All
| Ctrl+R
| Fill Right
| Edit, Fill Right
| All
| Ctrl+S
| Save
| File, Save
| All
| Ctrl+U
| Underline
| Format, Cells, Font, Underline, Single
| All
| Ctrl+V
| Paste
| Edit, Paste
| All
| Ctrl W
| Close
| File, Close
| Excel 97/2000
| Ctrl+X
| Cut
| Edit, Cut
| All
| Ctrl+Y
| Repeat
| Edit, Repeat
| All
| Ctrl+Z
| Undo
| Edit, Undo
| All
| F1
| Help
| Help, Contents and Index
| All
| F2
| Edit
| None
| All
| F3
| Paste Name
| Insert, Name, Paste
| All
| F4
| Repeat last action
| Edit, Repeat. Works while not in Edit mode.
| All
| F4
| While typing a formula, switch between absolute/relative refs
| None
| All
| F5
| Goto
| Edit, Goto
| All
| F6
| Next Pane
| None
| All
| F7
| Spell check
| Tools, Spelling
| All
| F8
| Extend mode
| None
| All
| F9
| Recalculate all workbooks
| Tools, Options, Calculation, Calc,Now
| All
| F10
| Activate Menubar
| N/A
| All
| F11
| New Chart
| Insert, Chart
| All
| F12
| Save As
| File, Save As
| All
| Ctrl+:
| Insert Current Time
| None
| All
| Ctrl+;
| Insert Current Date
| None
| All
| Ctrl+"
| Copy Value from Cell Above
| Edit, Paste Special, Value
| All
| Ctrl+'
| Copy Fromula from Cell Above
| Edit, Copy
| All
| Shift
| Hold down shift for additional functions in Excel's menu
| none
| Excel 97/2000
| Shift+F1
| What's This?
| Help, What's This?
| All
| Shift+F2
| Edit cell comment
| Insert, Edit Comments
| All
| Shift+F3
| Paste function into formula
| Insert, Function
| All
| Shift+F4
| Find Next
| Edit, Find, Find Next
| All
| Shift+F5
| Find
| Edit, Find, Find Next
| All
| Shift+F6
| Previous Pane
| None
| All
| Shift+F8
| Add to selection
| None
| All
| Shift+F9
| Calculate active worksheet
| Calc Sheet
| All
| Shift+F10
| Display shortcut menu
| None
| All
| Shift+F11
| New worksheet
| Insert, Worksheet
| All
| Shift+F12
| Save
| File, Save
| All
| Ctrl+F3
| Define name
| Insert, Names, Define
| All
| Ctrl+F4
| Close
| File, Close
| All
| Ctrl+F5
| XL, Restore window size
| Restore
| All
| Ctrl+F6
| Next workbook window
| Window, ...
| All
| Shift+Ctrl+F6
| Previous workbook window
| Window, ...
| All
| Ctrl+F7
| Move window
| XL, Move
| All
| Ctrl+F8
| Resize window
| XL, Size
| All
| Ctrl+F9
| Minimize workbook
| XL, Minimize
| All
| Ctrl+F10
| Maximize or restore window
| XL, Maximize
| All
| Ctrl+F11
| Inset 4.0 Macro sheet
| None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
| All
| Ctrl+F12
| File Open
| File, Open
| All
| Alt+F1
| Insert Chart
| Insert, Chart...
| All
| Alt+F2
| Save As
| File, Save As
| All
| Alt+F4
| Exit
| File, Exit
| All
| Alt+F8
| Macro dialog box
| Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
| Excel 97/2000
| Alt+F11
| Visual Basic Editor
| Tools, Macro, Visual Basic Editor
| Excel 97/2000
| Ctrl+Shift+F3
| Create name by using names of row and column labels
| Insert, Name, Create
| All
| Ctrl+Shift+F6
| Previous Window
| Window, ...
| All
| Ctrl+Shift+F12
| Print
| File, Print
| All
| Alt+Shift+F1
| New worksheet
| Insert, Worksheet
| All
| Alt+Shift+F2
| Save
| File, Save
| All
| Alt+=
| AutoSum
| No direct equivalent
| All
| Ctrl+`
| Toggle Value/Formula display
| Tools, Options, View, Formulas
| All
| Ctrl+Shift+A
| Insert argument names into formula
| No direct equivalent
| All
| Alt+Down arrow
| Display AutoComplete list
| None
| Excel 95
| Alt+'
| Format Style dialog box
| Format, Style
| All
| Ctrl+Shift+~
| General format
| Format, Cells, Number, Category, General
| All
| Ctrl+Shift+!
| Comma format
| Format, Cells, Number, Category, Number
| All
| Ctrl+Shift+@
| Time format
| Format, Cells, Number, Category, Time
| All
| Ctrl+Shift+#
| Date format
| Format, Cells, Number, Category, Date
| All
| Ctrl+Shift+$
| Currency format
| Format, Cells, Number, Category, Currency
| All
| Ctrl+Shift+%
| Percent format
| Format, Cells, Number, Category, Percentage
| All
| Ctrl+Shift+^
| Exponential format
| Format, Cells, Number, Category,
| All
| Ctrl+Shift+&
| Place outline border around selected cells
| Format, Cells, Border
| All
| Ctrl+Shift+_
| Remove outline border
| Format, Cells, Border
| All
| Ctrl+Shift+*
| Select current region
| Edit, Goto, Special, Current Region
| All
| Ctrl++
| Insert
| Insert, (Rows, Columns, or Cells) Depends on selection
| All
| Ctrl+-
| Delete
| Delete, (Rows, Columns, or Cells) Depends on selection
| All
| Ctrl+1
| Format cells dialog box
| Format, Cells
| All
| Ctrl+2
| Bold
| Format, Cells, Font, Font Style, Bold
| All
| Ctrl+3
| Italic
| Format, Cells, Font, Font Style, Italic
| All
| Ctrl+4
| Underline
| Format, Cells, Font, Font Style, Underline
| All
| Ctrl+5
| Strikethrough
| Format, Cells, Font, Effects, Strikethrough
| All
| Ctrl+6
| Show/Hide objects
| Tools, Options, View, Objects, Show All/Hide
| All
| Ctrl+7
| Show/Hide Standard toolbar
| View, Toolbars, Stardard
| All
| Ctrl+8
| Toggle Outline symbols
| None
| All
| Ctrl+9
| Hide rows
| Format, Row, Hide
| All
| Ctrl+0
| Hide columns
| Format, Column, Hide
| All
| Ctrl+Shift+(
| Unhide rows
| Format, Row, Unhide
| All
| Ctrl+Shift+)
| Unhide columns
| Format, Column, Unhide
| All
| Alt or F10
| Activate the menu
| None
| All
| Ctrl+Tab
| In toolbar: next toolbar
| None
| Excel 97/2000
| Shift+Ctrl+Tab
| In toolbar: previous toolbar
| None
| Excel 97/2000
|
__________________
|
10-12-2006, 11:13 PM
العرض العادي
