In my Previous posts i wil discus the overall shortcuts for Windows7 and 8, in this it is specially for Windows Excel For Both windows7 and 8 OS.
This will be very essential for many of us....
Enjoy the shorcuts.
Shortcuts
|
Description
|
Double Click On a Cell
|
Edit the cell contents
|
Double click on a row or Column
Divider
|
Adjust height/width to auto fit
|
Highlight header of multiple
rows/columns
|
Adjust height/width to auto fit of all rows and columns
|
Triple Click
|
Select the entire content in the cell
|
Click on a row/column divider and drag
|
Adjust height/width of the row/columns
|
Highlight header of multiple
rows/columns then drag
|
Adjust height/width of the row/columns
|
Ctrl+Mouse Wheel
|
Zoom in/out of the document
|
Hold Shift+Click the cells
|
Select Multiple Cells
|
Shortcuts
|
Description
|
F2
|
Edit the selected cell
|
F5
|
Goto Specific cell
|
F7
|
Spell Check
|
F11
|
Create Chart
|
Ctrl+A
|
Select All
|
Ctrl+B
|
Bold
|
Ctrl+C
|
Copy
|
Ctrl+F
|
Find
|
Ctrl+G
|
Goto
|
Ctrl+H
|
Replace
|
Ctrl+I
|
Italic
|
Ctrl+K
|
Insert Link
|
Ctrl+N
|
New workbook
|
Ctrl+O
|
Open workbook
|
Ctrl+P
|
Print Dialog
|
Ctrl+S
|
Save
|
Ctrl+U
|
Underline
|
Ctrl+V
|
Paste
|
Ctrl+Z
|
Undo
|
Ctrl+Y
|
Redo
|
Ctrl+X
|
Cut
|
Ctrl+5
|
Strikethrough text
|
Ctrl+F3
|
Define Name
|
Ctrl+F4
|
Exit excel
|
Ctrl+F6
|
Switch between open workbooks
|
Ctrl+F9
|
Minimize current window
|
Ctrl+F10
|
Maximize Current window
|
Shift+F1
|
Activate help on item
|
Shift+F2
|
Insert comments
|
Shift+F3
|
Insert Functions
|
Ctrl+Shift+;
|
Enter the current time
|
Ctrl+;
|
Enter the current date
|
Ctrl+Pagedown
|
Move to next worksheet
|
Ctrl+Pageup
|
Move to previous worksheet
|
Ctrl+Shift+#
|
Number Format: Date
|
Ctrl+Shift+@
|
Number Format: Time
|
Ctrl+Shift+!
|
Number Format: Commas
|
Ctrl+Shift+$
|
Number Format: Currency
|
Ctrl+Shift+%
|
Number format:Percentage
|
Ctrl+Shift+^
|
Number format :Scientific
|
Ctrl+Space
|
Select entire column
|
Shift+Space
|
Select entire row
|
Ctrl+ ( Arrow keys )
|
Move to next Section
|
No comments:
Post a Comment