Microsoft Excel 2007 Keyboard Shortcuts

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

Leave a Reply

Your email address will not be published. Required fields are marked *


× 9 = forty five

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>