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:
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
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 + S | Save 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 + F6 | Switch between open workbooks / windows. |
Ctrl + F9 | Minimize current window. |
Ctrl + F10 | Maximize currently selected window. |
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. |
F2 | Edit 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 + F3 | Open the Excel formula window. |
Shift + Space | Select entire row. |
Alt + Shift + F1 | Insert New Worksheet. |
Alt + = | Create a formula to sum all of the above cells |
0 komentar:
Post a Comment