Ms Excel Short Cut

This trick for MS Excel. It'll help you to save your valuable time during operation with Excel. So, use it wisely 'n don't forget to give comment if you like this trick:































Ctrl + A
Select all contents of the worksheet.
Ctrl + B
Bold highlighted selection.
Ctrl + C
Copy highlighted selection.
Ctrl + I
Italic highlighted selection.
Ctrl + K
Insert link.
Ctrl + P
Print dialog -- to print document.
Ctrl + SSave document.
Ctrl + U
Underline highlighted selection.
Ctrl + X
Cut the selected text.
Ctrl + Y
Redo the process.
Ctrl + Z
Undo the process.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + F6Switch between open workbooks / windows.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove 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 keyMove to next section of text.
Ctrl + SpaceSelect entire column.
F2Edit the selected cell.
F5
Goto a specific cell. For example, C6. Shift + F5 Bring up search box.
F7
Spell check selected text and/or document.
F11
Create chart.
Shift + F3Open the Excel formula window.
Shift + SpaceSelect entire row.
Alt + Shift + F1Insert New Worksheet.
Alt + =Create a formula to sum all of the above cells

0 komentar: