Excel short key
This blog I explain basic Microsoft excel short key............
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 + right arrow key
= Move to next section of text
Ctrl + Space
= Select entire column
Shift + Space
= Select entire row
Ctrl + W
= Close document
Thanks for visit
Mr. Jaljay
