Google Find us on Google+ Computer Tips: Exel Tips

Wednesday, March 26, 2014

Exel Tips

                   Copy - paste: paste Excel data set or press Control + V to paste pattanaittan not use. Control + C to copy the information in a cell-click. After all, you want to paste the contents into the cell cursor to the cell. Just then tap Enter. Wow! Are paste your information.
 watch window: In formula use Excel spread sheet, an essential process. Higher  no formula, no celles directing us to remember that it is impossible in many instances. Give them the values ​​of the cells in some cases these accounts are linked to each other formulas cells results in the formation of further organizing done. Thus, related to the set of the new formula cells that give the correct answers to the function of cells in the waching many places you might visit. Sometimes looking at the wrong information in the wrong cells and formula gives rise to opportunity. To avoid this, it is equipped with a set of Excel Excel Watch Window. succession  Excel is convenient to all of us to monitor the  Watch Window. What changes in the value of the cells involved in cell changing all times we are showing us that the watch window to window. We will monitor the work of each cell and thus reduces to navigate. The watch was originally set in window Tools menu and Vice menu Formula Auditing to select that. And then click Show Watch Window in need. Eye-glass picture window with a small section of the Formula Auditing in the Watch Window. Watch our window to get the clicks. Now select any cell in the Formula worked would notice the Add Watch button to press. Now watch the Formula window, the value of the relevant cells, the result is calculated. Similarly, one may wish to monitor the performance of any the formula click Add to select the order they are added to the Watch window. The monitor can be placed in any corner of the window. This trend is changing the values ​​in cells no longer felt that changing the values ​​in the cells by formulas monitor in the same window. If you do not want to track in a Formula working something and select Delete Watch button pressing delete other in formula monitor's functions.
 paste Button: Excel 2003 after serving in the workforce, and many do not know. Otherwise provided in the paste button and without the usual button to see some of the facilities. If you click on the little arrow symbol in it for Excel you can see that it is ready for some more work to be done. The paste is a special button. Some units also offer additional features that can be found in press pestceyvat. So if you want the formula from the selected cell, to Value, only the data you want to go, go with the coffee to be done format, Unicode text, the text should be organized into several categories that help will be given to your needs. Run section, select your custom.


No comments:

Post a Comment