Pages
(Move to ...)
Home
Search Engine Google
Katrina kaif hot pics
Punjab Food Civil Supply Exam
▼
Friday, April 5, 2013
Excel shortcut
Ctrl+B
Bold
Format, Cells, Font, Font Style, Bold
Ctrl+a
Select All
Format, Cells, Font, Font Style, Bold
Ctrl+C
Copy
Edit, Copy
Ctrl+D
Fill Down
Edit, Fill, Down
Ctrl+F
Find
Edit, Find
Ctrl+G
Goto
Edit, Goto
Ctrl+H
Replace
Edit, Replace
Ctrl+I
Italic
Format, Cells, Font, Font Style, Italic
Ctrl+K
Insert Hyperlink
Insert, Hyperlink
Ctrl+N
New Workbook
File, New
Ctrl+O
Open
File, Open
Ctrl+P
Print
File, Print
Ctrl+R
Fill Right
Edit, Fill Right
Ctrl+S
Save
File, Save
Ctrl+U
Underline
Format, Cells, Font, Underline, Single
Ctrl+V
Paste
Edit, Paste
Ctrl W
Close
File, Close
Ctrl+X
Cut
Edit, Cut
Ctrl+Y
Repeat
Edit, Repeat
Ctrl+Z
Undo
Edit, Undo
F1
Help
Help, Contents and Index
F2
Edit
None
F3
Paste Name
Insert, Name, Paste
F4
Repeat last action
Edit, Repeat. Works while not in Edit mode.
F4
While typing a formula, switch between absolute/relative refs
None
F5
Goto
Edit, Goto
F6
Next Pane
None
F7
Spell check
Tools, Spelling
F8
Extend mode
None
F9
Recalculate all workbooks
Tools, Options, Calculation, Calc,Now
F10
Activate Menubar
N/A
F11
New Chart
Insert, Chart
F12
Save As
File, Save As
Ctrl+:
Insert Current Time
None
Ctrl+;
Insert Current Date
None
Ctrl+"
Copy Value from Cell Above
Edit, Paste Special, Value
Ctrl+’
Copy Fromula from Cell Above
Edit, Copy
Shift
Hold down shift for additional functions in Excel’s menu
none
Shift+F1
What’s This?
Help, What’s This?
Shift+F2
Edit cell comment
Insert, Edit Comments
Shift+F3
Paste function into formula
Insert, Function
Shift+F4
Find Next
Edit, Find, Find Next
Shift+F5
Find
Edit, Find, Find Next
Shift+F6
Previous Pane
None
Shift+F8
Add to selection
None
Shift+F9
Calculate active worksheet
Calc Sheet
Shift+F10
Display shortcut menu
None
Shift+F11
New worksheet
Insert, Worksheet
Shift+F12
Save
File, Save
Ctrl+F3
Define name
Insert, Names, Define
Ctrl+F4
Close
File, Close
Ctrl+F5
XL, Restore window size
Restore
Ctrl+F6
Next workbook window
Window, ...
Shift+Ctrl+F6
Previous workbook window
Window, ...
Ctrl+F7
Move window
XL, Move
Ctrl+F8
Resize window
XL, Size
Ctrl+F9
Minimize workbook
XL, Minimize
Ctrl+F10
Maximize or restore window
XL, Maximize
Ctrl+F11
Inset 4.0 Macro sheet
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
Ctrl+F12
File Open
File, Open
Alt+F1
Insert Chart
Insert, Chart...
Alt+F2
Save As
File, Save As
Alt+F4
Exit
File, Exit
Alt+F8
Macro dialog box
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment