Very complete microprocessor wisdom ( the 1st rete

accidentally deleted data resumption

accidentally, delete the wrong, also empty the Recycle Bin, conceived ah?
as long as three steps, you can delete and blank the Recycle Bin back your material


steps:

1, click Enter regedit (open registry)

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


Perhaps you have had hundreds of Excel to complete the fiscal expressions, maybe you have been using Excel functions to achieve thousands of complex calculations, but perhaps you think that Excel is so, even nought new. However, we continual innumerable times annual in nearby to use Excel only one percent of all skills. From Excel,Women FiveFingers Performa, the heading of some little-known tips to start a voyage on the Excel Different customs.
one, so that different types of data using different colors
in payroll, if you want more than equal to the total wages of 2,000 yuan to greater than or equal to total wages of 1,500 yuan,
1. open the Click the second drop-down box on the right button, select the Click the
2. Click the
3. After setting,Vibram FiveFingers Classic, press the
see it payroll, payroll file is not according to your apply to exhibit a assorted color.

Second, a category drop-down list items
we constantly want to fill the company name into the table, the name in mandate to preserve consistency, use of
1. on Sheet2 in the name of the business by category (such as
2. Select A column (
follow the above operation, the B, C ... ... column named If column C),Women Vibram FiveFingers Sprint, the implementation of In the corporation
then selected to enter the enterprise name column (eg column D), then open the C1), OK to exit.
4. Select anyone cell in column C (eg, C4), right-click the drop-down button, select the suitable Then select the corresponding cell in column D cell (eg D4), click the drop-down button to the appropriate species affair name from the list, select the desired company name enter the cell.
Tip: When typography a report in the hereafter, if you do not need to print
Third, establish a
1. the space in the toolbar, right-click, choose In the
Click
2. and then in the (mutual file), and follow the above operation it a name (such as
repeat the above operation, the document list to add a few more names.
3. Select the distribution Hyperlink By pressing the
repeat the above operation, the menu item and its corresponding workbook hyperlink documents attach.
4. After the need to open the
Tip: Although we will
Fourth, the product of
1. execute Select .
follow the above operation, one by one to record other special symbols of nice input
2. open the A work area in the toolbar.
alternate to the How many buttons).
3. Select one of the
4. named after right-clicking a button pops up the shortcut menu, select exit.
Repeat this step, the macro buttons and the corresponding interlock.
5. close the
five, with
1. Open the need to print the worksheet, use the mouse in the need to print the row (or column) apparent drag,Women FiveFingers Performa Jane, select them and then right click on the shortcut menu that appears, select will need to print the row (or column) hidden.
2. implement the
3. the secluded rows (or columns) are displayed, and repeat the operation,
4. After the need to print a fashion, open the , issuing what, press the toolbar's
six, so that data on demand
If you want to arrange according to department where employees sort the names both of these departments are not in alphabetical order of the information, nor is it by stroke order, how do? can be self- define the sequence order.
1. appliance the the team, a workshop, two workshops, three workshops,
2. Select the an of the drop-down button, select the just-defined series, according to 2
seven, the data sheet completely hidden
some cell contents do not want guests to way, had it hidden.
1. selected to conceal the contents of the cell (area), the implementation of the
2. and then switch to the
3. execute
After this setting later, the cell contents are no longer shown, is to use Excel's features can not be allowed to borrow transparent.
Tip:
eight, so that in the English input method appeared
smart editing table, some cells to enter the English, and some cells to enter the Chinese, it is inconvenient to again switch the input method, why not set and let the input method intelligently adjust it?
selected range of cells need to enter the Chinese, the implementation of tab, press the
later selected to enter the Chinese in the range of cells in any one cell, the Chinese input method (IME list of the first Chinese input method) automatically open, elected in the other cell, Chinese input method automatically Close.
nine, so that
1. execute
2. In the then click
3. If you need to enter the text later, equitable enter
ten, a custom function in Excel, notwithstanding the wealthy
Excel functions, but it does not encounter all our needs. We can customize a function to act certain operations. Here,Vibram FiveFingers, we define a enumeration from the space of ​​trapezoid function:
1. Execute
2. In the window, execute the
3. the right of the defined function to complete.
can later use the built-in functions favor the same using a custom feature.
Tip: Use the upon method to customize the function is usually only secondhand in the corresponding workbook.
XI header following pictures
lining to add a background for the worksheet, the worksheet is the lining in the following, can not only lined in the chart header below it?
1. execute Worksheet → Background
2. clutch down the Ctrl key while using the mouse 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) below no compare pictures (in fact, is the picture to be
Tip? lining cells in the picture underneath does not support publishing.
XII with a hyphen get it (here assumed that the B, C, D columns into one column).
1. in the D column, insert two empty columns (E, F column), then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select column E, the implementation of , press the
4. the B, C, D, E column deleted to complete the merger go.
Tip: Complete Steps 1 and 2 operation, the combined achieve has been achieved, but by this time if you delete B, C, D line, the formula error. Therefore, to carry out tread 3, the formula is converted to the same


student achievement of
friends often ask, For this consideration, I use the function here gives a easy way to achieve. This assumes that student fulfilment
stored in Sheet1 worksheet range of cells A1 to G64, which doing title 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. again select cell A1 , with the > So distant, the results of the elementary shape, the following simple revision see.
3. adapt the row altitude and column length, the same selected range of cells A1 to G2 (the 1st extravaganza of a student's area), according to The retinue operation).
4. also selected range of cells A1 to G3, click on the To add a border all the results of.
press the What function is more appropriate. Excel's Please enter requirements (such as related assist file, you can quickly determine the desired function.
fifth, meantime viewing a different worksheet within multiple cells of data
Sometimes we edit a worksheet (Sheet1), the need View other worksheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
later,Vibram FiveFingers Sprint, no stuff in which the worksheet, simply open the > In previous editions of Excel 2002, add a siteline for the operation of a scope of cells is also many distress, Excel 2002 which traits a fashionable expansion.
Click the pull button, then the pop-up drop-down menu, choose drop-down button, choose a border style, then you need to add a border range of cells in shuffle, you can rapidly paint the corresponding range of cells on the border.
Tip: ① If you draw the wrong skeleton, does not matter, Select the toolbar's Color >

XVII. control of a characteristic cell type text length
Can you dream while you enter the 4 digits of the cell was fraught with a number, or enter txt in the cell digit you have entered period, Excel will automatically resolve, immediate analysis and pop-up advising namely pleasing ah! To attain this function, Excel, is also not difficult.
example, we enrol the cursor to a cell, in order to enter the consensus and the advantage of calculation, we hope the card alarm Year. style Time distance
We kas long asevery time you open Excel, the software is forever rotated on by default multiple sheets. In addition to this we can see that Excel has a muscular single form of processing power, more suitable for multiple interrelated tables coordination To coordinate the league, of course, first you need to synchronize the input, so in many cases, will need more than one table simultaneously in the same cell type the same content.
So how do you make the table into a group of editors? First first we click the sheet tab name ) At this point, we see the name of the Excel caption bar to a What we base, change the format of how to do it? First, we must change data format the first table, and then click the , Excel will pop-up 9, alteration case of text
In Excel, the form processing and data computing support to provide the maximum mighty formula is not, nor is the database, but the function do not think the function in Excel only for mathematics, in fact, by the time the write into the contents of the table, Excel has its special editing functions such as changing the text of the case.
in Excel 2002, provide at fewest 3 functions to convert the text of the case and they are: UPPER (source data grid), case, as to the first letter of every word to uppercase, etc. For example, in a form of cell A1 enter the lowercase car to get the result will be will be The simple direction, particularly fknow next to nothing ofme of the similar style is particularly true of information, such as hireling lists, area of origin and other information.
quickly if we want to extract the cells from A4 title, it is best to use , the number of characters extracted) grid, the number of characters to extract) word, you only need to enter the target cell and 5 word.
twenty-first, to convert the ordinal base word to the English words into ordinal bottom is a more complicated problem because it does not have a very nailed pattern: Most of the figures into ordinal number is used in the Moreover, function, simply write a formula that can be accessible converted. do not trust, 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 pedestal word and ordinal conversion was so easy and rapid to achieve.
XXII, filled with a special symbol digit
and financial dealings of people know, the paperback fills in when there is a convention Safety Fill Law, The basic format is formula to should be changed to REPT (brain paired with # # 0.00 worksheet consisting of plain text to create the histogram. Its principle is very simple, it is natty to use special symbols repeated according to the specified cell showing the results of the relative effectiveness of different lengths.
example, we first Annual production of a equilibrium sheet, and then The results have been ROUND (D3 * 100,0 )),> XXIV calculate the total number of words in the cell
Sometimes, we may have a number of roles in a cell of amuse, the cells need to think the total number of words. To solve this problem, in increase to using the SUBSTITUTE > is to use a Finally, the number of spaces + 1, we arrive at the cell number of temperaments.
XXV, the euro transition
This is a new tool in Excel 2002, if you choose to install the Excel 2002 is the default, then it may not be in the with other functions of Excel window, we can set the money conversion by the mouse EU membership states a list of other currencies, the parity of course, in order to display the euro is more professional, we can also click on the Excel toolbar, the p>


to redo the computer system, they study, can spend fewer money, ha ha [chart]

one, ready to work:
how to reinstall the computer system
First, start the computer time hold down the DELETE key to enter BIOS, select Advanced BIOS Features option, press the Enter key to enter install. Select First Boot Device option, then press the keyboard's Page Up or Page Down keys to set the CD-ROM, so that you can boot the system to CD.
Second, the return to the chief menu, retention the BIOS settings. (Save is to press F10, then reception Y opener)
1. Ready for Simplified Chinese version of Windows XP Professional installation CD, and check the drive is supported from the start.
2. if likely, ahead escaping the installer with all the hard disk to scan your hard disk error retarding and repair, or install procedure runs as a hard disk error checking that is to be a lot of trouble.
3. using periodical records to the installation files product key (reg code number to install).
4. possible, with the driver export tool (such as: Driver Genius 2004 V1.9 Beta.exe) under the original Windows XP drivers for all backup to disk ( such as: F: Drive). Best to write down the motherboard, network card, graphics card type and other major hardware manufacturers to pre-download the driver back.
5. If you want to format the C drive during the installation or the D drive (recommended installation format the C drive), behind up the C drive or D drive serviceable data.
Second, start the system with a CD-ROM:
(if you yet know the method, work to the next step), reboot the system and set the CD-ROM First boot disk, save the settings and reboot. The XP installation CD into the drive, restart the computer. Just started, when there is fast as shown when pressing the Enter key, or can not start the XP system CD. If you do not understand the specific practices, please refer to the same with this -> how to enter the pure DOS system:
CD from the begin, if no chance you can watch the installation screen will arise as shown in Figure 1
;
View Original
all prompted the Chinese, View Original
copyright agreement, there is no choice, press partition, if you have formatted the C drive, select the C partition, select the partition and press format, which is converted to the file system format, or save an existing file system, a variety of alternative, but to pay attention to the NTFS format to save disk space, amend security and dilute disk fragmentation, but there are many problems and MacOS 98/Me can not see the NTFS partition, where the election Figure
format the C drive of the warning, press the F key will be ready to format the c drive, and the below 6

View Original
Because the space is greater than the selected partition C 2048M ( that 2G), FAT file system does not support disk partitions larger than the 2048M, so the installer will use the FAT32 document system format to format the C steer, press br> View original picture in Figure 7 is to format the C partition; only start with the CD or install XP Setup boot floppy to format the partition during the installation options obtainable; if MS-DOS boot disk access beneath DOS run i386 winnt to install XP, install XP without formatting the partition option. reformat the C partition is completed, and the below

Figure 8 Figure 8 View Original
start copying file, duplicate the file after the installation starts to initialize Windows configuration and the system will automatically restart in 15 seconds. restarts, and the below 9

View Original
9

View Original
than five minutes later, when prompted to need 33 minutes will appear as shown below 10

View Original
regional and language settings to use the default can directly click Next step this password, Administrator system commander has the highest administration in the system, routinely landing system does not require the account. Then click , choose Beijing, click Original
web installation lets you choose the manner used, selected a typical set point
View Original
proceed the installation, here afterward do not you partake in, the installation program will automatically complete the whole process to restart automatically afterward 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 Welcome screen, set the system hint, as shown 20

View Original
Click the lower right corner of the
View Original
here to create broadband dial-up connection, not dial-up connection on the desktop shortcut, and the default dial-up connection named sorcerer to set up broadband dial-up connection, dial-up connection on the desktop shortcut, and the default dial-up connection named button.
where I first create a broadband connection, select the first

View Original
new telecommunications or China Unicom (ADSL) for residential consumers to have accounts and passwords, so I choose , as shown in Figure 23

View Original
Telecom alternatively China Unicom apt invest input account and password in the The name of the list, whether left vacant the system ambition automatically establish a direcotry phoned a dial-up articulation, Microsoft, of course you want to refresh XP above you, merely if I were you also activated a 30-day trial phase, why hurry? prefer Figure 25 shows

View Original
you normally enter a user name used to log the computer, point next appear as shown 26

View Original
Click Finish the end of the installation the system will log off and landing as the new user. landing desktop as shown 27

View Original
6 and ascertain a common icon
; point on the desktop -> Connect to -> broadband connection, as shown 32

View Original
left point Office on the desktop can be seen more than a the open display In the bottom left of the figure click on the My Network Places