supra shoes tk-Tip

one, mistakenly deleted data recovery

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


steps:

1, click Enter regedit (open registry)

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

Perhaps you have done in Excel financial statements had hundreds, maybe you have to use Excel functions to achieve over thousands of complex calculations, but perhaps you think that Excel is the case, even the nothing new, but we repeated countless times daily in handy to use Excel all skills is only one percent of this topic from Excel, some of the little-known tips to start a trip 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 the total wages of 1,500 yuan, workbook, select the Press , press the Second, a classification drop-down list filled with items
we often want to enter the name of the enterprise to the table in order to maintain the name of consistency, the use of
1. on Sheet2 in the name of the business by category (such as in column A (... column named , open the enterprise C4) supra shoes tk, click the right drop-down button, select the appropriate the appropriate category business name list, select the desired company name fill the cell.
Tip: When printing a report in the future, if not print Select Among them, at any time convenient to call.
1. the space in the toolbar right-click, choose Document onto the new menu (common document), and follow the above named action it (such as list name.
3. select the , open the br> repeat the above operation, the menu item and its corresponding workbook hyperlink documents together.
4. After the need to open the menu, click one of the option can be.
Tip: Although we will and , we can make one of their own and save the macro in Click the
switch to the How many buttons).
3. Select one of the the shortcut menu, select link up.
5. Close the Custom Views need to print the row (or column) marked drag, select them and then right-click in the shortcut menu that appears Herve Leger Dresses, select br> 2. implement the ), click kinds of form, open the not by stroke order, how to do? sequence can be customized to sort.
1. implementation sequence in just a custom sequence, according to two seven, the data is completely hidden part of
worksheet cell contents do not want visitors to access, it had to be hidden.
1. selected to hide the contents of the cell (area), the implementation of the Enter
3. execute content is no longer displayed, is to use Excel's features can not be allowed to borrow transparent.
Tip: others hide your deleted data.
eight, so that in the English input method intelligently appear
editing table, some cells to enter the English, and some cells to enter the Chinese, repeated switch the input method is inconvenient, why not set up a bit and let the input method intelligently adjust it?
selected range of cells need to enter the Chinese, the implementation of , switch to the any one cell, the Chinese input method (IME list the first one Chinese input method) automatically opens when you select the other cells, Chinese input method automatically shut down.
nine, so that text
you are not often enter some fixed text, such as correction Computer News, and then confirm it becomes.
ten, custom functions in Excel Herve Leger 2012, although rich
Excel functions, but it does not meet all our needs, we can customize a function to perform specific operations below , we calculate from the definition of a trapezoid area function:
1. execute br> 2. In the window, execute the a, b, h) V = h * (a + b) / 2End Function
4. Close the window, a custom function to complete.
can later be the same as using the built-in functions to use custom functions.
Tip: Use the above method defined in the corresponding function is usually only used in the workbook.
XI header following pictures
lining add to the background of a worksheet, the worksheet is the lining in the following , can not be the first in the table below only lining it?
1. implement the button, the image contrast in the worksheet below.
2. While holding down the Ctrl key while using the mouse 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) there is no lining pictures below (in fact, is the picture to be does not support printing.
twelve, with a hyphen ; Enter the formula: = B1 & C1 & D1.
2. D1 cells again selected, use the be incorporated into the corresponding column E cells.
3. Select column E, the implementation of box, select one of the to complete the merger work.
Tip: Complete Steps 1 and 2 operation, the combined effect has been achieved, but at this time if you delete B, C, D column, the formula error. it is to carry out step 3, the formula into the same
student achievement of
friends often ask, on such considerations, I am here gives a simple way to use the function to achieve.
student achievement is assumed here to save 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 cell A1, use the .
Thus, the results of 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 (the first a student performance of the region), Click This step and the following operation).
4. also selected range of cells A1 to G3, click on cell area, the results of all add a border.
press the do not know what function to use more appropriate. Excel combined view of the help file, you can quickly determine the required function.
fifth, while viewing a different worksheet in multiple cells of data
Sometimes we edit a worksheet (Sheet1) , you need to see the other worksheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's monitoring point border
In previous versions of Excel 2002, add a border to the operation of a range of cells is too much trouble, Excel 2002 which features a new expansion.
Click side of the drop-down button, then the pop-up drop-down list, select the left drop-down button, select a border style, and then add in the need to drag the border of the range of cells, 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 >


XVII control specific cell type text length
Can you imagine when you enter the four digits of the cell was filled with a digit, or in the input text you have entered the cell the number of times, Excel will automatically determine, instant analysis and pop-up warning that nice ah! to achieve this function, Excel, is also not difficult.
example, we 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. In addition to this we can see that Excel has a strong single form of processing power, more suitable for multiple interrelated tables coordinate the work. to coordinate the association, of course, first you need to synchronize the input and therefore, in many cases, will need more than one table simultaneously in the same cell type the same content.
then how to edit the tables into a Group ? First we click on the first sheet tab name to click). At this point, we see the name of the Excel title bar to a just write something, we found that the change the format of the data uniform how to do it? First, we have to change the data format of the first table, and then click . br> ninth, change case of text
In Excel, the form processing and data computing support to provide the most powerful formula is not, nor is the database, but the function in Excel functions do not think only for numbers, in fact, As long as the content is written into the table, Excel has its special editing functions such as changing the text of the case.
in Excel 2002, provide at least three functions to convert the text of the case and they are : appropriate The result will be The easy way to save time, especially for some of the information especially similar style, such as employee 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 to extract) (source data grid, the number of characters to extract) 4 and 5 is the word.
twenty-first, into the base words from English into ordinal base into ordinal word is a more complex problem because it does not have a very fixed pattern: large Most ordinal numbers are in use into end, and, , identify the function, simply 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 last digit to Thus, the base word and ordinal conversion was so easy and quick to achieve.
XXII, filled with a special symbol digit
and financial dealings of the people know, the book fills in when there is a convention of the function and its basic format is only the formula to position, it is necessary to as cell numbers head with $#,## 0.00 can be created directly in the worksheet text composed by the histogram. Its principle is very simple, it is smart to use a special symbol repetition, according to a specified cell results show the comparative effectiveness of different lengths.
For example, we first make an annual balance sheet, and then According to the results already in the table n .
XXIV calculate the total cell number of words
Sometimes, we may have a number of characters in a cell of interest, the cells need to calculate the total number of words To solve this problem, in addition to use the :
The meaning of style is to use number, and finally the number of spaces + 1, we arrive at the number of characters in the cell has.
XXV, the euro conversion
This is a new tool in Excel 2002 if you have Excel installed 2002 is the default mode when selected, then it may not be in the option, appeared with the other functions of Excel window, we can set the currency conversion by mouse EU member states were converted into 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, they learn, can be less money, ha ha [map]

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