Tables
Action Keystroke
Go to next cell Tab
Go to previous cell SHIFT+Tab
Go to beginning of column ALT+PageUp
Highlight to beginning of column ALT+SHIFT+PageUp
Go to end of column ALT+PageDown
Highlight to end of column ALT+SHIFT+PageDown
Go to beginning of row ALT+Home
Highlight to beginning of row ALT+SHIFT+Home
Go to end of row ALT+End
Highlight to end of row ALT+SHIFT+End
Column break CTRL+SHIFT+Enter
Formatting
Action Keystroke
Select all CTRL+A
Copy CTRL+C
Cut CTRL+X
Paste CTRL+V
Undo CTRL+Z
Redo CTRL+Y
Left alignment CTRL+L
Center alignment CTRL+E
Right alignment CTRL+R
Justified CTRL+J
Indent from left CTRL+M
Decrease indent from left CTRL+SHIFT+M
Hanging indent CTRL+T
Decrease hanging indent CTRL+SHIFT+T
Page break CTRL+Enter
Promote list item ALT+SHIFT+Left arrow
Demote list item ALT+SHIFT+Right arrow or TAB
Part II: Microsoft Excel Keyboard Shortcuts
Spreadsheet Actions
Action Keystroke
Open a workbook CTRL+O
New workbook CTRL+N
Close a workbook CTRL+W
Open the Save As dialog box F12
Save a workbook CTRL+S
Print a workbook CTRL+P
Help F1
Open the Find tab of the Find and
Replace dialog box
CTRL+F
Open the Replace tab of the Find and
Replace dialog box
CTRL+H
Go to CTRL+G / F5
Quit/Exit Excel ALT+F4
Insert a new worksheet SHIFT + F11
Hide selected columns CTRL + 0
Display hidden columns CTRL + SHIFT + 0
Hide selected rows CTRL + 9
Display hidden rows CTRL + SHIFT + 9
Selecting & Navigating
Action Keystroke
All cells left of current cell SHIFT+Left arrow
All cells right of current cell SHIFT+Right arrow
Entire column CTRL+Spacebar
Entire row SHIFT+Spacebar
Entire worksheet CTRL+A
One cell up Up arrow
One cell down Down arrow
One cell right Tab
One cell left SHIFT+Tab
Top of worksheet (cell A1) CTRL+Home
End of worksheet (last cell with data) CTRL+End
End of row Home
End of column CTRL+Left arrow
Move to next worksheet CTRL+PageDown
Move to previous worksheet CTRL+PageUp
Cycle between open workbooks CTRL+F6
Format painter CTRL+SHIFT+C
Delete previous word CTRL+Backspace
Apply bulleted list CTRL+SHIFT+L
Style CTRL+SHIFT+S
Normal style CTRL+SHIFT+N
Cursor Movement
Action Keystroke
Select from cursor to beginning of line SHIFT+Home
Select from cursor to end of line SHIFT+End
Go to beginning of line Home
Go to end of line End
Go to beginning of document CTRL+Home
Go to end of document CTRL+End
Miscellaneous
Action Keystroke
Copyright symbol - © ALT+CTRL+C
Insert current date ALT+SHIFT+D
Insert current time ALT+SHIFT+T
Go to footnotes ALT+CTRL+F
Show/Hide ¶ CTRL+SHIFT+8
Thesaurus SHIFT+F7
Advanced – F1 to F12
Keystroke Action
F1 Help
Alt+F1 Next field
Alt+Shift+F1 Previous field
Shift+F1 ‘What is This’ Help
F2 Move text or graphic
Alt+F2 Unassigned
Alt+Shift+F2 File Save
Ctrl+F2 File Print Preview
Shift F2 Copy Text
F3 Edit AutoText
Ctrl+F3 Store in Spike
Ctrl+Shift+F3 Insert Spike and empty contents
Shift+F3 Changes case
F4 Edit Repeat frame
Alt+F4 File Exit
Ctrl+F4 File Close
Shift+F4 Repeat a Go To or Find command
F5 Edit Go To
Alt+F5 Previous application window size
Ctrl+F5 Previous document window size
Ctrl+Shift+F5 Edit bookmark
Shift+F5 Previous position
F6 Next pane
Ctrl+F6 Next window
Ctrl+Shift+F6 Previous window
Shift+F6 Previous pane
F7 Tools Spelling
Ctrl+F7 Move window
Ctrl+Shift+F7 Update link
Shift+F7 Tools Thesaurus
F8 Extend selection
Ctrl+F8 Size window
Ctrl+Shift+F8 Select column or display/hide tab and paragraph marks
Shift+F8 Shrink selection
F9 Update field
Alt+Shift+F9 Go To/Macro button fields
Ctrl+F9 Field characters
Ctrl+Shift+F9 Unlink field
Shift+F9 Switch field codes or results
F10 Menu bar
Alt+F10 Enlarge Application window
Ctrl+F10 Enlarge Document window
Shift+F10 Cut/Copy/Paste/Font/Paragraph/Bullets and Numbering menu
bar
F11 Next field
Ctrl+F11 Lock field
Ctrl+Shift+F11 Unlock field
Shift+F11 Previous field
F12 File Save As
Ctrl+F12 File Open
Ctrl+Shift+F12 File Print
Shift+F12 File Save
Mastersdaily Represents SEO optamization.
Just Think About Best SEO and Offline Data Entry Services in Bulk its only in Ahmedabad here with us..
Just Our Services and Clients enjoys best Services in Gujarat.
Just SEO Rocks With Online Marketing.
what u expect from us Contact us email us: jetmaster007@live.com.
Archives for March 2009




Subscribe to our RSS Feed
Follow Us on Twitter
Become Our Fan on Facebook