Use the following keyboard shortcuts in MS Excel 2007.
Use These Keys
|
Function
|
F2
|
Edit the selected cell
|
F5
|
Go to a specific cell
|
F7
|
Spell check selected
text and/or document
|
F11
|
Create chart
|
Ctrl + Shift + ;
|
Enter the current time
|
Ctrl + ;
|
Enter the current date
|
Alt + Shift + F1
|
Insert new worksheet
|
Shift + F3
|
Open the Excel®
formula window
|
Shift + F5
|
Bring up search box
|
Ctrl + A
|
Select all contents of
worksheet
|
Ctrl + B
|
Bold highlighted
selection
|
Ctrl + I
|
Italicize highlighted
selection
|
Ctrl + C
|
Copy selected text
|
Ctrl + V
|
Paste
|
Ctrl + D
|
Fill
|
Ctrl + K
|
Insert link
|
Ctrl + F
|
Open find and replace
options
|
Ctrl + G
|
Open go-to options
|
Ctrl + H
|
Open find and replace
options
|
Ctrl + U
|
Underline highlighted
selection
|
Ctrl + Y
|
Underline selected
text
|
Ctrl + 5
|
Strikethrough
highlighted selection
|
Ctrl + O
|
Open options
|
Ctrl + N
|
Open new document
|
Ctrl + P
|
Open print dialog box
|
Ctrl + S
|
Save
|
Ctrl + Z
|
Undo last action
|
Ctrl + F9
|
Minimize current
window
|
Ctrl + F10
|
Maximize currently
selected window
|
Ctrl + F6
|
Switch between open
workbooks/windows
|
Ctrl + Page up
& Page Down
|
Move between Excel®
worksheets in the same document
|
Ctrl + Tab
|
Move between two or
more open Excel® files
|
Alt + =
|
Create formula to sum
all of above cells
|
Ctrl + ‘
|
Insert value of above
cell into current cell
|
Ctrl + Shift + !
|
Format number in comma
format
|
Ctrl + Shift + $
|
Format number in
currency format
|
Ctrl + Shift + #
|
Format number in date
format
|
Ctrl + Shift + %
|
Format number in
percentage format
|
Ctrl + Shift + ^
|
Format number in
scientific format
|
Ctrl + Shift + @
|
Format number in time
format
|
Ctrl + g
|
Move to next section
of text
|
Ctrl + Space
|
Select entire column
|
Shift + Space
|
Select entire row
|
Ctrl + W
|
Close document
|
With the help of these keys you can reduce your mouse use and make your keyboard activity faster.
Other Keyboard Shortcut Links:
- Windows 7 - General Keyboard Shortcuts
- Windows 7 - Dialog Box Keyboard Shortcuts
- Windows 7 - Windows Logo Key Keyboard Shortcuts
- Microsoft Office 2007 Keyboard Shortcuts
- Microsoft Excel 2007 Keyboard Shortcuts
- Keyboard Shortcuts for Special Characters and Symbols
- Magic Keyboard Shortcut Guide
Facebook
No comments:
Post a Comment