MicroSoft Excel shortcut keys

 Excel shortcut keys



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 the search box.


Ctrl + A  Select all contents of a worksheet.


Ctrl + B  Bold highlighted selection.


Ctrl + C  Copy selected text.


Ctrl + D  Fill the Content of the selected cell on top to bottom.


Ctrl + F  Open find and replace options.


Ctrl + G  Open go-to options.


Ctrl + H  Open find and replace options.


Ctrl + I Italicize highlighted selection.


Ctrl + K  Insert link.


Ctrl + N  Open new document.


Ctrl + O  Open options.


Ctrl + P Open print dialog box.


Ctrl + R Fill right.


Ctrl + S  Save.


Ctrl + U  Underline highlighted selection.


Ctrl + V  Paste.


Ctrl + W Close document.


Ctrl + X Cuts all cells within the highlighted section.


Ctrl + Y  Underline selected text.


Ctrl + Z  Undo last action.



Ctrl + 5  Strikethrough highlighted selection.


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 the formula to sum all of the above cells.


Ctrl + Insert the value of above cell into the 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)  Move to next section of text.


Ctrl + Space  Select entire column.


Shift + Space  Select entire row.



Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.