·
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
0 comments:
Post a Comment