accidentally deleted data recovery
accidentally, delete the wrong, also empty the Recycle Bin, assumed ah?
as long as three steps, you can delete and blank 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 outside the left margin click on
, select: Recycle Bin .
Perhaps you have had hundreds of Excel to complete the financial expressions, maybe you have been using Excel functions to effect thousands of complex measurements, but perhaps you think that Excel is so, even naught new. However, we repeated countless times journal in nearby to use Excel only one percentage of all capabilities. From Excel, the topic of some little-known tips to start a voyage on the Excel Different customs.
an, 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 carton on the right button, select the Click the
2. Click the
3. After setting, reception the
see it payroll, payroll data is not according to your request to display a different color.
Second, a category drop-down list items
we often want to fill the company name into the table, the name in array to retain consistency, use of
1. on Sheet2 in the name of the business by category (such as
2. Select A column (
follow the upon operation, the B, C ... ... column named If column C), the implementation of In the enterprise
then selected to enter the company name column (eg column D),
GHD MK4 Gold Straighteners, then open the C1), OK to exit.
4. Select anybody compartment in col C (eg, C4), right-click the drop-down clasp, choose the applicable Then select the corresponding compartment in column D cell (eg D4), press the drop-down clasp apt the proper category commerce name from the list, select the lusted enterprise label enter the cell.
Tip: When printing a report in the future,
GHD Red Styler Straighteners, 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 (general document), and follow the above operation it a name (such as
repeat the above operation,
GHD NZ, the document list to add a few more names.
3. Select the delivery Hyperlink By pressing the
repeat the above operation, the menu item and its corresponding workbook hyperlink documents together.
4. After the need to open the
Tip: Although we will
Fourth, the production of
1. execute Select .
follow the above operation, one by one to log other special symbols of nice input
2. open the A work area in the toolbar.
switch to the How many buttons).
3. Select one of the
4. named afterward 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 publish the worksheet, use the mouse in the need to print the row (or column) apparent drag, 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 hidden rows (or columns) are exhibited, and repeat the operation,
4. After the need to print a form, open the , promulgating what, press the toolbar's
six, so that file on claim
If you want to sort according to division where employees sort the names either of these departments are not in alphabetical order of the information, nor is it by stroke order, how do? can be self- define the series order.
1. implement the the group, a workshop, two workshops, 3 workshops,
2. Select the one of the drop-down button, select the just-defined sequence, according to two
7, the data canvas completely hidden
portion of the cell contents do not want visitors 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 perspicuous.
Tip:
eight, so that in the English input method appeared
intelligent amending table, some cells to enter the English, and some cells to enter the Chinese, it is inconvenient to repeatedly switch the input method, why no set and let the input method intelligently adapt it?
selected range of cells need to enter the Chinese, the implementation of tab, press the
later elected 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, just enter
ten, a custom function in Excel, although the rich
Excel functions, but it does not encounter all our needs. We can customize a function to fulfil definite operations. Here, we define a calculation from the area of trapezoid function:
1. Execute
2. In the skylight, execute the
3. the right of the defined function to complete.
can later use the built-in functions like the same using a custom function.
Tip: Use the above method to customize the function is usually only used in the corresponding workbook.
XI header following pictures
lining to multiplication a background as the worksheet, the worksheet is the lining in the retinue, can not only lined in the table header beneath it?
1. execute Worksheet → Background
2. hold 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 after, leaving the cell lining on the picture below, and the selected cell (zone) below not compare pictures (in fact, is the picture to be
Tip? lining cells in the picture below does not patronize typography.
XII with a hyphen obtain it (here presumed 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 erased to complete the merger work.
Tip: Complete Steps 1 and 2 operation, the combined achieve has been achieved, but at this time if you delete B, C, D line, the formula mistake. Therefore, to carry out step 3, the formula is converted to the same
student completion of
friends often ask, For this consideration, I use the function here gives a simple way to achieve. This assumes that student achievement
cached in Sheet1 worksheet range of cells A1 to G64, which deed 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 ()))),
GHD Pink Limited Edition。
2. afresh select cell A1 , with the > So distant, the results of the basic fashion, the following easy modification see.
3. adjust the row height and column length, the same selected range of cells A1 to G2 (the first extravaganza of a student's area), according to The following operation).
4. also selected range of cells A1 to G3, click on the To add a border entire the results of.
press the What feature is more appropriate. Excel's Please enter requirements (such for related assist file, you can speedily resolve the desired feature.
fifth, when 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, no matter in which the worksheet, simply open the > In previous editions of Excel 2002, add a border for the operation of a range of cells is too many trouble, Excel 2002 which traits a new expansion.
Click the pluck button, then the pop-up drop-down list, choose drop-down button, select a boundary manner, then you absence to add a siteline range of cells in haul, you can quickly paint the corresponding scope of cells on the border.
Tip: ① If you draw the wrong border, does not material, Select the toolbar's Color
XVII control cell type-specific length of the text
Can you dream when you enter the four digits of the cell was filled with a digit, or enter text in the cell You have entered a number of times, Excel will automatically determine, instant inquiry and pop-up admonition that fine ah! To achieve this function, Excel, is also not complicated.
example, we register the cursor to a Therefore, we can click the In the Then in the We then came to the and
Obviously, when if someone in the cell when the input is not a four-digit number, Excel will display a warning dialog box pops up narrating you what went wrong, and until you enter the correct can proceed to input. Amazing, right? In fact, in Excel's , why not given a free hand, he charted a test criterion,
GHD Hair NZ, to make your show solitary gloss Excel does.
eighth, more than filled the form in groups of firm cells
We know thatevery time you open Excel, the software is always cornered on by default multiple sheets. In addition to this we can see that Excel has a mighty 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. Therefore, in numerous cases, there will need to more than one table in the same cell type the same content.
then how to edit tables in groups? First we click the first worksheet tab name The form is not associated with, prop down the Ctrl key to click). At this point, we watch the name of the Excel caption bar to a The need to enter more than one table cell content just to write, we found that the
However, only the synchronization input is not enough. For example, we need multiple forms of data in the same situation change the format of the uniform how to do it? First, we have to change the data format of the first table, and then click the The sub-menu, select At this time, Excel will pop up,
ninth,
change text case in Excel, for form processing and data computing support to invest the most mighty formula is not, nor is the database, but the function. Do not think the function in Excel only for numbers, in fact, at the peak of 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 functions to convert the text case. They are: into For example, in a form of cell A1 enter the lowercase Similarly, if we enter in cell A3
XX extract a specific string of characters
addition to the direct importation from the existing cell contents to extract characteristic temperament input, is indeed a direction to save period and save difficulty, primarily fjust aboutme of the style primarily alike message, such as employee lists, location of origin and additional information.
If we want to quickly extract a cell from A4 title, it is best to use characters' input to this location. Of course, if you want to extract the name, then they have to use In dissimilar case, we do not begin from the left and right ends, but directly extracted from the data center a few characters. For sample, we want to extract from the A5 cell Means: in the A5 cell extract after the first four characters of the two characters,
GHD, that is, 4 and 5 word.
twenty-first, to convert the ordinal base word to the English words into ordinal found is a more complicated publish. Because it is not a quite fixed pattern: most of the ordinal mathematics are in use into the st Moreover, Therefore, it seems very perplexing to appliance. In fact, at the peak of we sort out minds, find out the function, just jot a formula namely can be easily converted. Do not trust, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII, fraught with a special symbol digit
and financial dealings of folk understand, the paperback fills in when there is a convention of , or in the amount of data preceded by digits) 16-LEN (A2))) (A3))) & A3 ) & A4 & REPT (requirements.
xxiii, establish histograms
counting to repeatedly enter the text in addition, principle is very simple, it is intelligent to use special symbols reiterated along to the specified cell showing the results of the relative effectiveness of different lengths.
example, we first make one anniversary poise sheet, and then font , and drag the fill handle to the G14. we see a chart without the use of Excel's text functions histogram has been unfolding ahead our eyes, convenient and intuitive, simple and explicit.
XXIV reckon the total digit of words in a cell
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 using the function to remove spaces, such as cell A1 immediately enter a LEN (TRIM (A1))-LEN (SUBSTITUTE (TRIM (A1 ),use The number of characters.
XXV, the euro conversion
This is a current tool in Excel 2002, whether you select to install the Excel 2002 is the default, then it may not be in the find it, but we can 1st select the > After we again open the money conversion The show is more professional, we can also click on the Excel toolbar, the
Excel spreadsheet of 35 strokes {ambition} {study}
Hybrid Mode
