MS EXCEL SHORTCUT KEYS-MS EXCEL SHORTCUT KEYS
MS EXCEL SHORTCUT KEYS-MS EXCEL SHORTCUT KEYS PDF:In this post you all found the almost all shortcuts keys used in the MS EXCEL are listed below which regularly used MS excel if you have look on the below post short you will be perfect with the MS EXCEL shortcut keys and no need to search options.
v F2 Edit
the selected cell
|
v F5 Go to
a specific cell
|
v F7 Spell
check selected text and/or document
|
v F11 Create
chart
|
v Ctrl +
Shift + ; Enter the current time
|
v Ctrl +
; Enter the current date
|
v Alt +
Shift + F1 Insert new worksheet
|
v Shift
+ F3 Open the Excel® formula window
|
v Shift
+ F5 Bring up search box
|
v Ctrl +
A Select all contents of worksheet
|
v Ctrl +
B Bold highlighted selection
|
v Ctrl +
I Italicize highlighted selection
|
v Ctrl +
C Copy selected text
|
v Ctrl +
V Paste
|
v Ctrl +
D Fill
|
v Ctrl +
K Insert link
|
v Ctrl +
F Open find and replace options
|
v Ctrl +
G Open go-to options
|
v Ctrl +
H Open find and replace options
|
v Ctrl + U Underline highlighted selection
|
v Ctrl +
Y Underline selected text
|
v Ctrl +
5 Strikethrough highlighted selection
|
v Ctrl +
O Open options
|
v Ctrl +
N Open new document
|
v Ctrl +
P Open print dialog box
|
v Ctrl +
S Save
|
v Ctrl +
Z Undo last action
|
v Ctrl +
F9 Minimize current window
|
v Ctrl +
F10 Maximize currently selected window
|
v Ctrl +
F6 Switch between open workbooks/windows
|
v Ctrl +
Page up
|
v &
Page Down
|
v Move
between Excel® worksheets in the
|
v same
document
|
v Ctrl +
Tab Move between two or more open Excel® files
|
v Alt +
= Create formula to sum all of above cells
|
v Ctrl +
‘ Insert value of above cell into current cell
|
v Ctrl +
Shift + ! Format number in comma format
|
v Ctrl +
Shift + $ Format number in currency format
|
v Ctrl +
Shift + # Format number in date format
|
v Ctrl +
Shift + % Format number in percentage format
|
v Ctrl +
Shift + ^ Format number in scientific format
|
v Ctrl +
Shift + @ Format number in time format
|
v Ctrl +
g Move to next section of text
|
v Ctrl +
Space Select entire column
|
v Shift
+ Space Select entire row
|
v Ctrl +
W Close document
|
0 comments:
Post a Comment