تو و من

موضوعات مختلف

تو و من

موضوعات مختلف

میان برهای مورد استفاده در اکسل

Excels Keyboard Shortcuts 

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
Ctrl+Tab
In a workbook: activate next workbook
None

نظرات 0 + ارسال نظر
برای نمایش آواتار خود در این وبلاگ در سایت Gravatar.com ثبت نام کنید. (راهنما)
ایمیل شما بعد از ثبت نمایش داده نخواهد شد