Some computer knowledge

 Accidentally deleted data recovery

accidentally, delete the wrong, and also empty the Recycle Bin, the supposed ah?
as long as three steps, you can delete and empty the Recycle Bin back your stuffer
Steps:

1, click the Enter regedit (open registry)

2, expand: HEKEY--LOCAL--MACHIME/SOFTWARE/microsoft/WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE outside the left margin click on
, select: Recycle Bin .

Maybe you already have hundreds of Excel to complete the financial statements, perhaps you have used Excel functions for complex operations a thousand times, maybe you think that Excel is nothing but this, even the nothing new. but we repeated countless times daily in handy to use all the skills in Excel is just one per cent. the topic from the Excel skills of some of the little-known start, get a glimpse on the Excel Different customs.
one, so that different types of data using different colors
in the payroll, if you want more than equal to the total wage of 2,000 yuan to greater than or equal to the total wages of 1,500 yuan, workbook, select the . Click , press the Second, the establishment of categories drop-down list filled with items
name of the business we often want to enter into the table, the name in order to maintain consistency, the use of
1. in Sheet2 in the name of the business by category (such as in the A column (... the column named , open the Enterprise C4), click the right side of the drop-down button, select the appropriate the appropriate category list, select the name of the enterprise need to populate the corporate name of the cell.
Tip: When printing a report in the future, if you do not need to print the Select Among them, at any time convenient to call.
1. the space in the toolbar right click, choose Documents onto the new menu (common document), and modeled it for the operation of the above named (such as list name.
3. Select the , open the br> Repeat the above operation, the menu item and its corresponding workbook, the hyperlink documents together.
4. After the need to open the menu, click one of the appropriate option to.
Note: Although we will and We can make one of their own and macros stored in the Click the
switch to the How many buttons).
3. Select one of the the shortcut menu, select linked.
5. off Manager as the face, no printed row (or column) marked drag, select them and then right click in the shortcut menu that appears, select br> 2. implementation ), click species form, open the not by stroke order, how do? sequences can be customized to sort.
1. execute sequence in the sequence just defined by two VII, the data sheet completely hidden
content of cells in the visitors do not want access, it had to be hidden.
1. selected to hide the contents of the cell (regional), the implementation of Enter
3. the implementation of the Content is no longer shown, is to use Excel's features can not be allowed to betray oneself clear.
Tip: others delete your hidden data.
eight, so in English and Chinese input method appeared
intelligent editing table, some cells to enter the English, and some cells to enter the Chinese, repeated it is inconvenient to switch the input method, why not set and let intelligent input method to adjust it?
selected range of cells to enter the Chinese, the implementation of , switch to any one cell, the Chinese input method (first in the list input method Chinese input method 1) automatically open, elected in the other cell, Chinese input method automatically shut down.
nine, so that text
you are not often enter some fixed text, such as Correction computer and then confirm it has become.
ten, a custom function in Excel, although the rich
Excel function, but it does not meet all our needs. We can customize a function to perform some specific operations. The following , we define a calculated from the trapezoid area function:
1. the implementation of the br> 2. In the window, execute a, b, h) V = h * (a + b) / 2End Function
4. Close the window, a custom function to complete.
can later use the built-in function the same as using a custom function.
Tip: Use the above methods defined in the corresponding function is usually only used in the workbook.
XI, the first table below pictures
lining added to the background of the worksheet is the lining in the entire worksheet below can not just lining in the header Next,?
1. implementation button, the image contrast in the entire worksheet below.
2. while holding down the Ctrl key, right in the picture without lining cells (area) in drag, and select those cells (area).
3. Click cell lining on the picture below, and the selected cell (area) not lining the picture below (in fact, is the picture to be does not support printing.
second, with a hyphen ; Enter the formula: = B1 & C1 & D1.
2. D1 cells again selected, use the E is incorporated into the corresponding cells in the column.
3. Select the E series, the implementation of box, select one of the to complete the merger work.
Note: Step 1,2 complete the operation, combined effect has been achieved, but at this time if you delete B, C, D series, the formula error. and thus should be carried out step 3, the converted to the same formula of the Performance of Students often
Article
friend asked, to such considerations, I am here gives a simple way to use the function implementation.
is assumed that the student performance stored in the Sheet1 worksheet range of cells A1 to G64, which act title 1, 2 acts Subject Name.
1. Switch to Sheet2 worksheet, select cell A1, enter the formula: = IF (MOD (ROW (), 3) = 0, (= 1, sheet1! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. again selected A1 cells, use the .
this point, the results section the basic shape, the following simple modified look.
3. adjust the row height and column width, the same selected range of cells A1 to G2 (No. 1 student achievement bar area), Click this step and the following operation).
4. also selected range of cells A1 to G3, click on the cell area, the results of all articles add a border.
press the do not know what the function is appropriate to use. Excel combined view of the Help file, you can quickly determine the required function.
fifth, while viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1) , you need to view the other work sheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's monitoring point border
in previous versions of Excel 2002 for the operation of a range of cells is too much trouble to add a border, Excel 2002 which features a new development.
Click the side of the drop-down button, then pops up in the drop-down list, choose the drop-down button on the left, select a border style, and then in the range of cells you need to add drag and drop the frame, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame , does not matter, on the toolbar select the >


seventh, entering text specific cells control the length of
Can you imagine when you enter the four digits of the cell was filled with a digit, or enter text in the cell that you have entered When the number, Excel will automatically determine, instant analysis and pop-up warning, then be nice ah! To achieve this function, the Excel, is also not difficult.
example, we will position the cursor to a registration to the four-digit year. the right ah, the Fixed cells
we know each time you open Excel, the software is always turned on by default multiple sheets. Thus we can see that Excel has a strong addition to the processing power of single forms, more suitable for multiple interrelated tables in coordination. Yao coordinated association, of course, first need to sync input. Therefore, in many cases, will need more than one table while the same cell type the same content.
So how do you edit a group of tables ? First we click the first worksheet tab name the click). At this point, we see the name of the title bar of Excel, a casually write something, we found that change the format of the data uniform how to do? First, we have to change the data format of the first table, and then click the . br> nineteenth and change the text of the case
in Excel, the form processing and data computing support for the most powerful formula is not, nor is the database, but the function. Do not think that Excel, the function only for numbers, in fact, As long as the content is written into the table, Excel has a special function to edit it. such as changing the text of the case.
in Excel 2002, provide at least three of the text case conversion function. They are : appropriate The result will be save time and save trouble in the method, especially for some of the information especially similar style, such as staff lists, place of origin and other information.
quickly if we want to extract the cells from A4 title, it is best to use source data grid, the number of characters extracted) (source data format to extract the number of characters) 4 and 5 is the first word.
the twenty-first, into the base ordinal number words to English words into ordinal base is a more complex problem. because it is not a very fixed pattern: large Duoshuo into ordinal numbers are in use end. Moreover, , find out the function, just write a formula that can be easily converted. do not believe, see: th . The formula despite the long list, but the meaning is very clear: ① If the number is the last digit to . Therefore, the cardinal and ordinal conversion words so easy and fast implementation.
XXII, filled with special symbols and financial dealings with the median
people know that when there is a book filled conventional function. It's basic format is only the formula to bit, we should read as head cell numbers with $#,## 0.00 can be created directly in the worksheet histogram formed by the plain text. It is also very simple principle, that is, the intelligent use of special symbols repeated according to a specified cell results show comparative effects of different lengths.
For example, we first make an annual balance sheet, and then According to the results already in the table n .
round, calculate the total number of words in the cell
Sometimes, we may have the character of a cell in the number of interested need to calculate the total number of words in the cell. To solve this problem, in addition to Using the :
the meaning of style is to use number, and finally number of spaces +1 to draw the number of characters in the cell was.
XXV, the euro conversion
This is a new tool in Excel 2002. If you install the Excel 2002 is the default mode the selection, then it may not be in the option, emerged. and other functions Excel window, we can set the currency conversion mouse EU Member States were converted to other currencies, the list price ratio. Of course, in order to display the euro is more professional, we can also click on the Excel toolbar, the .


to redo the computer system, learn their own, can spend less money, ha ha [map]

one, ready to work:
how to reinstall the computer system
First, restart the computer while holding down the DELETE key to enter BIOS, select Advanced BIOS Features option, and press the Enter key to enter setup. Select First Boot Device option, then press the keyboard Page Up or Page Down key to the is set to CD-ROM, so you can start the system to the disc.
Second, back to the main menu, save the BIOS settings. (preservation method is to press F10, then press Y button)
; 1. ready for Simplified Chinese version of Windows XP Professional installation CD, and check the drive is supported from the start.
2. possible, run the installation program before use ScanDisk to scan all hard disk to check and repair disk errors, or run the Setup program to a hard disk for errors, such as checks that will be very troublesome.
3. with the installation files of paper records product key (serial number installed).
4. possible, with the driver backup tool (such as: Driver Genius 2004 V1.9 Beta.exe) under the original Windows XP all the drivers back to the hard disk (such as: F: Drive). best to write down the motherboard, network card, video card type and other major hardware manufacturers, download the driver in advance reserve.
5. If you want to format the C drive during the installation or the D drive (recommended format the C drive during installation), back up the C drive or D drive useful data.
; Second, start the system with a CD-ROM:
(if you already know the way, go to the next step), reboot the system and to set the first boot disk drive to save the settings and reboot.