Computer learning namely complete , do no fart hug

accidentally canceled file retrieval

accidentally, delete the bad, and also empty the Recycle Bin, the conceived ah?
at the peak of three steps, you can delete and empty the Recycle Bin back your stuff


steps:

1, click the Enter regedit (open registry)

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


Perhaps you have had hundreds of Excel to complete the financial statements, perhaps you have used Excel functions for complex operations a thousand times, maybe you consider that Excel also many, or even nought new. However, we repeated innumerable times everyday in handy to use all the skills in Excel is just one per penny. Excel in the heading from some little-known tips to start, get a peep 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 aggregate remuneration of 2,000 yuan to greater than or equal to the total wages of 1,500 yuan,
1. Open the Click the second drop-down box above the right clasp, elect the Click the
2. Click
3. setup is complete, press the
discern it payroll, payroll data is not along to your request that come in differ colors.

Second, a category drop-down list filled with items
name of the business we often want to enter into the table, the name in order to preserve consistency, the use of
1. in Sheet2 in the name of the business by category (such as
2. Select A column (
modeled on the upon action, the B, C ... ... column labeled such as the C column), the implementation of In the Enterprise
need to enter the company name and then select the column (eg column D), and then open the C1), OK to exit.
4. Select any cell in column C (eg, C4), click the right side of the drop-down button, select the appropriate Then select the cell corresponding to the D column cell (eg D4), click the drop-down button to the appropriate category business name from the list, select the name of the enterprise need to fill the cell.
Tip: When printing a report in the future, if you do not need to print the
Third, establish a
1. the space in the toolbar right click, choose In the
Click
2. then in the (common document), and modeled it for the operation of the above named (such as
repeat the above operations, multi-document list to add a few names.
3. Select the distribution Hyperlink By pressing the
reiterate the above operation, the menu item and its corresponding workbook, the hyperlink documents attach.
4. After the need to open the
Tip: Although we will
four, making
1. the implementation of the Select the .
modeled on the above operation, one by one to record a special sign of the input of other agreeable
2. Open the A go space in the toolbar.
switch to the How many buttons).
3. Select one of the
4. Right-click the button after a name, in the emulating the shortcut menu, select exit.
Repeat this step, the button to interlock with the corresponding macro.
5. close the
five, with
1. Open the worksheet to publish, use the mouse without the need to print the row (or column) marked shuffle, select them and then right click in the shortcut list that appears, select , will not need to print the row (or column) hidden.
2. implementation
3. the hidden rows (or columns) are displayed, and repeat the operation,
4. After the need to print a form, open the , issuing what, on the toolbar click the
six, so that data on claim if you want to sort
departments where workers are sorted according to these sectors is not the name of the pertinent information by both the Pinyin order, not by stroke order, how do? can be self- defined sequence order.
1. execute The group, a workshop, two workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined series, by two
seven
the data canvas entirely secluded part of the contents of the cell do not ambition to enabling observers to way, had it hidden.
1. selected to hide the contents of the cell (area), the implementation of
2. and then switch to the
3. the implementation of the
after this set after the contents of the cell is no longer shown, is to use Excel's features can not be allowed to clear the sky.
Tip:
eight, so in English and Chinese input method appeared
intelligent editing chart, some compartments to enter the English, and some cells to enter the Chinese input method is no handy to switch afresh, why not set and let intelligent input means to modify it?
selected range of cells to enter the Chinese, the implementation of tab, press the Elected in the future
range of cells need to enter anybody one of the Chinese cell, Chinese input method (first in the list input method Chinese input method 1) automatically open, was selected the other cell, Chinese input method automatically closed.
nine, so that
1. the implementation of the
2. In the then click
3. If you need to enter this text in the future, simply enter
ten, a custom function in Excel, though the rich
Excel function, but it does not meet all our needs. We can customize a function to perform definite operations. Here, we define a calculated from the trapezoid area function:
1. The implementation of the
2. In the window, execute
3. the right of the defined function to complete.
can later use the built-in function is 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 header following pictures
lining additional to the backdrop of the worksheet is the lining in the entire worksheet below, can not only lined the first in the table below it?
1. perform → Background Worksheet
2. while holding down the Ctrl key, right in the picture without lining cells (area) in drag, and select those cells (area).
3. Click After this setting later, leaving the cell lining on the picture below, and the selected cell (area) not lining the picture below (in truth, is the picture to be
Tip? lining the image bedefect in ... the cell does not support typography.
second, with a hyphen get it (it is presumed that the B, C, D columns into 1 col.)
1. in the D column, insert 2 empty columns (E,GHD Blue Straighteners, F series), and then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select the E series, the implementation of , press the
4. the B, C, D, E column deleted, completion of the merger work.
Tip: Complete the steps from 1,2 combined effect has been achieved, yet by this time if you delete B, C, D series, the formula error. And accordingly ought be carried out step 3, the formula is converted to the same Performance of Students


article
friends constantly ask, For this consideration, I give here a easy method used to fulfill the feature.
cached in student achievement is assumed here Sheet1 worksheet range of cells A1 to G64, which deed caption 1, 2 acts subject name.
1. Switch to Sheet2 worksheet, select cell A1, enter the formula: = IF (MOD (ROW (), 3) = 0, , sheet1! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. once again select the cell A1 , with the > At this point, the basic fashion results segment, the following simple modified see.
3. adjust the row height and column length, the same selected range of cells A1 to G2 (No. 1 student achievement bar area), according to The following operation).
4. also selected range of cells A1 to G3, click on the To add a border all the results section.
press the What more proper function. Excel box input requirements (such as narrated aid files, you can immediately determine the necessitated function.
fifth, while viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), it is needful View other work sheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
after, no material in which the worksheet, simply open the > In before versions of Excel 2002 for the operation of a range of cells is also much difficulty to add a border, Excel 2002 which functions a new development.
Click the pluck button, pop-up in the subsequent drop-down list, choose drop-down button, 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 Color >

XVII Enter the txt in characteristic cells controlling the width of
Can you imagine while you enter the 4 digits of the cell was filled with a digit, or entering text in the cell digit you have entered time, Excel will automatically determine, instant thinking and pop-up alarm, then be pleasing ah! To achieve this function, the Excel, is likewise not tough.
example, we enroll the cursor to a the cell in order to enter the calculation of the unified and cozy, we wish that the Card warning annual. style time distance,
We know thateach time you open Excel, the software is always turned on at default multiple sheets. Thus we can see that Excel has a mighty counting to the processing power of unattached fashions, more suitable for multiple interrelated coordination table . to coordinate the association, of course, first need to sync input. Therefore, in many cases, will need more than one table simultaneously in the same cell type the same content.
So how do you edit a group of tables? First We click the first worksheet tab name ). At this point, we see the name of the title bar of Excel, a What, we found that alteration the format of how to do? First, we must alteration the data format of the first table, and then click the time, Excel will pop up IX, change the text in the circumstance of
in Excel for form processing and data computing support is not the most powerful formula, neither is the database,GHD Classic Straighteners, but function. Do not think that Excel, the function only for mathematics, in fact, at all times written into the contents of the table, Excel has a special function to edit it. such as changing the text of the case.
in Excel 2002, provide at fewest three of the text case conversion function. They are: UPPER (source data grid), case, such as getting the first letter of every word is capitalized. For example, we have a form of cell A1 enter the lowercase the result the motorcar will be will be the method save trouble, principally for some of the information principally similar manner, such as staff lists, place of origin and additional information.
quickly if we want to extract the cells from A4 title, it is best to use to extract the number of characters) grid, the number of characters extracted) words, only in the target cell to enter and 5 words.
the twenty-first, into the found ordinal number words to English words into ordinal found is a more complex problem. for it is not a very nailed pattern: Most of the diagrams Numerals are used in order to chance the Moreover, function,GHD Purple Butterfly 2011, equitable jot a formula that can be lightly converted. do not deem, see: IF (OR (VALUE (RIGHT (A2)) = 1,2,3,, CHOOSE (RIGHT (A2), Despite the long list, but the averaging is very clear: ① If the number is to bishop and ordinal conversion words so easy and hasty implementation.
XXII, filled with special characters and financial dealings with the centre
folk know, when filling in the paperback there is a conventional Safety Fill Law The elementary format is the formula to should be changed to REPT (pate coupled with # # 0.00 worksheet consisting of plain text to create the histogram. It is also very simple rule, that is, the clever use of special symbols repeated according to a specified cell showing the results of the comparable effectiveness of different lengths.
example,GHD Carry Case & Heat Mat, we first Annual making of a equilibrium sheet, and then The results have been ROUND (D3 * 100,0 )),> circular to calculate the total number of words in the cell
Sometimes, we may have the symbol of a cell in the number of amused need to calculate the total number of words in the cell. To solve this problem, in addition to using the SUBSTITUTE > is to use Finally,GHD Hair Straightener NZ, the number of spaces +1 to paint the number of characters in the cell was.
XXV, the euro transition
This is a new tool in Excel 2002. If you prefer to install the Excel 2002 is the default, then it may not be in the . with the Excel skylight, the other functions, we can set the currency conversion mouse parity EU catalogue of other currencies. Of course, in order to display the euro is more vocational, we can also click on the Excel toolbar, the p>


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

one, ready to work:
how to reinstall the computer system
First, start the computer when holding down the DELETE key to enter BIOS, select Advanced BIOS Features alternative, and press the Enter key to enter setup. Select First Boot Device adoption, then reception the keyboard Page Up or Page Down key to set the CD-ROM, so you tin begin the system to the disc.
Second, the return to the cardinal menu, save the BIOS settings. (Preservation method is to press F10, then press Y button)
1. Prepared to simplified Chinese version of Windows XP Professional installation CD, and check the drive is supported from the start.
2. feasible, ahead sprinting the installer with entire the hard disk apt scan the hard disk peccadillo retarding and repair, or setup the agenda is running, such as retarding that there is an error namely ambition be hard quite bothersome.
3. file with the periodical records the product key to install (installation reg code number).
4. possible, with the driver export tool (such as: Driver Genius 2004 V1.9 Beta.exe) all under the original Windows XP driver export to disk ( such as: F: Drive). Best to memorandum the motherboard, web card, movie card type and other major hardware manufacturers, pre-download the driver for use.
5. If you want to format the C drive during the installation or the D drive (suggested format the C drive during installation), back up the C drive or D drive serviceable data.
Second, start the system with a CD-ROM:
(if you already know the way, work to the afterward step), reboot the system and the CD-ROM set First boot disk, save the settings and reboot. The XP installation CD into the drive, restart the computer. Just started, as shown when there is fast when pressing the Enter key, or can not boot XP system CD. If you do not know the specific practices, please refer to the same with this -> how to get into pure DOS system:
CD-ROM from the start, if no accident to see the installation screen will appear as shown in Figure 1
;
View Original
hinted all Chinese, View original
license agreement, there is no alternative, according to partition, format the C drive if you have select the C partition, select a good partition and press format, which become the file system format, or save an existing file system, a variety of choice, but note that the NTFS format to save disk space, cultivate security and dilute disk fragmentation but there are many problems and MacOS 98/Me can not see the NTFS partition,GHD Green Butterfly 2011, here, choose Figure
advising format C drive, press the F key will be prepared to format the c drive, there is shown in Figure 6 under the original


outlook of the selected section C space than 2048M ( or 2G), FAT file system does not support more than 2048M of the disk partition, so the installer will use the FAT32 file system format to format C pedal, press the br> View native picture in Figure 7 is formatted C partition; only start with the CD or install XP Setup boot floppy disks to cater during the installation process format the partition option; If you use MS-DOS boot disk into DOS, run i386 winnt to install XP, install the XP partition without formatting options. Format C partition is completed, there was beneath the percolate shown in Figure 8
ad
View Original
Figure 8 to start copying files, duplicate the file after the installation process initializes Windows configuration. and then the system will automatically restart in 15 seconds. restarts, there is shown in Figure 9 under

View Original
9

View Original
than 5 minutes later, when prompted to need 33 minutes will seem as below 10

view the original selection of regional and language settings
The default worth can be a straight point of the , click point Please memorize this password, Administrator System Administrator has the highest administration in the system, ordinarily landing system does not require the list. Then click set do not say the referendum GMT, click br> View original
allows you to choose the method used by the network installation, select a typical set point

View Original
persist the installation, here after do not you partake in, the installation program will automatically complete the entire process. automatically restart after the installation is complete, the splash screen appears, as Figure 19

View original
first start takes a long time, please be patient, followed by the salute shade, set the system prompt, as shown 20

View Original
click the bottom right turn

View Original
here to create a broadband dial-up connection, not dial-up connection on the desktop shortcut, and dial-up connection the default name Connection Wizard after the establishment of broadband via dial-up connection, the dial-up connection on the desktop shortcut, and the default dial-up connection named Skip 22 shows

View Original
Telecom or China Unicom are currently using (ADSL) Residential users have accounts and passwords, so I chose step dial-up connection the name of the shortcut menu, and if left empty the system will automatically create a file shrieked > dial-up connection has been established, Microsoft naturally want you to refresh XP you, but even now there does not activate the 30-day trial time, why the hurry? choose button, as shown in Figure 25

View Original
you normally enter a user name to login the computer, click the Next button appears as shown under 26

View Original
Click Finish to complete the installation. the system will log off and log a new user. landing desktop as below 27

View Original
6, and find common icons
On the desktop, point to Start -> Connect to -> broadband connection, as Figure 32

View original
left point to the desktop space, you can see the desktop more than a property
the bottom left of the graph click on the