Best of Microsoft Excel Useful Shortcuts:


Best of Microsoft Excel Useful Shortcuts:

Excel is the best software I have ever seen. You can do anything in it, from home and personal accounts to complex calculations to games. Use the below shortcuts wisely!!!!
Shortcut Keys
Description
Ctrl + Shift + ;
Enter the current time.
Ctrl + ;
Enter the current date.
Ctrl + A
Select all contents of the worksheet.
Ctrl + B
Bold highlighted selection.
Ctrl + I
Italic highlighted selection.
Ctrl + K
Insert link.
Ctrl + U
Underline highlighted selection.
Ctrl + 5
Strikethrough highlighted selection.
Ctrl + P
Bring up the print dialog box to begin printing.
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
Move between Excel work sheets in the same Excel document.
Ctrl + Page down
Move between Excel work sheets in the same Excel document.
Ctrl + Tab
Move between Two or more open Excel files.
Ctrl + '
Insert the value of the above cell into cell currently selected.
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 + Arrow key
Move to next section of text.
Ctrl + Space
Select entire column.
Shift + Space
Select entire row.
F2
Edit the selected cell.
F5
Go to a specific cell. For example, C6.
F7
Spell check selected text or document.
F11
Create chart.
Alt + =
Create a formula to sum all of the above cells
Alt + Shift + F1
Insert New Worksheet.
Shift + F3
Open the Excel formula window.
Shift + F5
Bring up search box.


Popular posts from this blog

How to increase Write/Copy/Read speed of Memory Card or Pen drive in Windows 7