Excel Form 35 strokes ambition study Cheats ( repr

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 think that Excel also much, or even nobody new. However, we repeated countless times daily in convenient to use all the skills in Excel is just one per cent. Excel in the topic from some little-known tips to begin, get a peep on the Excel Different customs.
one, so that alter types of file using alter colors
in the payroll, if you want more than equal to the aggregate wages 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 carton on the right button, select the Click the
2. Click
3. install is complete, press the
see it payroll, payroll data is not according to your apply that come in different colors.

Second, a category drop-down list filled with items
name of the business we often absence to enter into the table, the appoint in mandate 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 above operation, the B, C ... ... column named such as the C column), the implementation of In the Enterprise
need to enter the enterprise name and then select the column (eg column D), and then open the C1), OKAY to exit.
4. Select any compartment in col C (eg, C4), press the right side of the drop-down button, select the suitable 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 account,GHD Hair Straightener, select the name of the company absence to fill the cell.
Tip: When typography a report in the future, whether you do not need to publish the
Third, build a
1. the space in the toolbar right click, prefer In the
Click
2. then in the (mutual file), 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 delivery Hyperlink By pressing the
repeat 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 on operation, one along one to disc a special sign of the input of other agreeable
2. Open the A work area in the toolbar.
switch to the How many buttons).
3. Select one of the
4. Right-click the button after a name, in the following the shortcut menu, select exit.
Repeat this tread, the button apt interlock with the corresponding macro.
5. close the
five, with
1. Open the worksheet to print, use the mouse without the need to print the row (or column) marked drag, select them and then right click in the shortcut menu that appears, select , will not need to print the row (or column) hidden.
2. implementation
3. the hidden rows (alternatively columns) are displayed, and reiterate the action,
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
ministries where workers are sorted according to these sectors is not the name of the relevant information by either the Pinyin order, not by stroke order, how do? can be self- defined sequence order.
1. execute The crew, a workshop, two workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined series, by two


7, the data page entirely hidden
portion of the contents of the cell do not want visitors 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
afterward this set later the contents of the cell is not longer shown, is to use Excel's traits can not be allowed to clear the sky.
Tip:
8, so in English and Chinese input usage seemed
intelligent editing table, some cells to enter the English, and some cells to enter the Chinese input method is not convenient to switch again, why not set and let smart input method to adjust it?
selected range of cells to enter the Chinese, the implementation of tab, reception the After the co-optation
range of cells that need to input Chinese characters in any cell, Chinese input method (IME list, the first a Chinese input method) automatically open, elected in 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, notwithstanding the rich
Excel function, but it does not encounter all our needs. We can customize a function to perform certain operations. Here, we define a enumerated from the trapezoid area function:
1. The implementation of the
2. In the skylight, execute
3. the right of the defined feature to complete.
can after use the built-in function is the same as using a custom function.
Tip: Use the above methods defined in the corresponding function is commonly only accustomed in the workbook.
XI header emulating pictures
lining additional to the background of the worksheet is the lining in the entire worksheet below, can not only lined the first in the table below it?
1. execute → Background Worksheet
2. while holding down the Ctrl key, right in the picture without lining cells (space) in drag, and select those cells (zone).
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 fact, is the picture to be
Tip? lining the picture beneath in the cell does not support printing.
second, with a hyphen obtain it (it is assumed that the B, C, D columns into one column.)
1. in the D column, insert two empty columns (E, F series), and then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select the E catena, the implementation of , press the
4. the B, C, D, E column deleted,GHD Leopard Grain, achievement of the combination work.
Tip: Complete the steps from 1,2 combined effect has been achieved, but at this time if you cancel B, C, D series, the formula error. And accordingly should be carried out step 3, the formula is converted to the same


Performance of Students often
Article
friend inquired, For this attention, I give here a simple method used to achieve the function.
cached in student accomplishment is supposed here Sheet1 worksheet scope 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, , 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 section, the retinue easy modified see.
3. accommodate the row elevation and column breadth, the same selected range of cells A1 to G2 (No. 1 student achievement bar area), according to The following operation).
4. too selected range of cells A1 to G3, click on the To join a boundary always the results section.
press the What more appropriate function. Excel box input requirements (such as narrated help files, 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),GHD Red Butterfly 2011, it is needful View other work sheet (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 for the operation of a range of cells is also much trouble to add a border, Excel 2002 which features a new development.
Click the drag 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 drip the border, you can speedily paint the corresponding range of cells on the border.
Tip: ① If you draw the bad frame, does not stuff, on the toolbar select Color



seventh, the control input text given the width of the cell
Can you imagine while you enter the 4 digits of the cell was filled with a number, or enter text in the cell Enter the number you have the time, Excel will automatically determine, instant thinking and pop-up warning, then be pleasing ah,GHD IV Salon Straighteners! To accomplish this function, the Excel, is also not tough.
example, we register the cursor to a Therefore, we can click the In the Then in the We then come to and
Obviously, when something entered the cell is not a four-digit time, Excel will display a admonition dialog box pops up acquainting you wrong causes, and until you enter the correct to continue recording. Amazing? In fact, in Excel's , why not given a free hand, their devise of a test criterion, so you do Excel show unique honour.
eighth, a group of more than fill the form of nailed cells
we know thateach time you open Excel, the software is always rotated on by default multiple sheets. In addition to this we can see that Excel has a lusty capability brochure form, more appropriate for multiple interrelated tables coordination. To coordinate the league, of course, first need to sync input. Therefore, in many cases, will need more than the same time in the same table cell, enter the same content.
So how do a group edit of tables? First we click the premier worksheet tab name namely not associated with the form, you can prop down the Ctrl opener to click.) At this point, we look the name of the heading bar of Excel, a The need to enter extra than one cell in the table of contents casually jot something, we find that
But just sync input is insufficient. For example, we need multiple forms of data in the same location change the format of the uniform how to do? First, we must alteration the data format of the first table, and then click the The sub-menu, select At this time, Excel will popup up
nineteenth and change the text of the case
in Excel, the form processing and data computing assist for the maximum powerful formula is not, neither is the database, but the function. Do not calculate that Excel, the function only for numbers, in truth, 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, cater at least 3 of the text circumstance conversion function. They are: into For example, a table in cells A1 enter lower circumstance Similarly, if we enter the cell A3
twenty, extract specific characters in a string
In increase to direct input, from one existing cell to extract the contents of a characteristic persona input, is absolutely a path to retention time and retention distress, primarily because some style especially similar message, such as staff lists, location of origin and other message.
quickly if we want to extract the cells from A4 title, it is best to use characters Of lesson, if you want to extract the name, then, will must use the In distinct case, we do not start from the left and right ends, but directly extracted from the data center a few characters. For example, we want to extract the cells from A5 Means: in the A5 cell extract after the first 4 characters of the two characters, that is, 4 and 5 words.
the twenty-first, into the found ordinal number words to English words into ordinal base is a more complex problem. Because it does not a very fixed pattern: Most of the diagrams are used into ordinal st Moreover, Therefore, it seems very difficult to implement. In fact, at the peak of we sort out fancies, find the function, just write a formula that can be lightly converted. Do not trust, see: ,GHD Carry Case & Heat Mat, 2,3,}, CHOOSE (RIGHT (A2), is
XXII, filled with special symbols and financial dealings with the centre
people understand, when filling in the book there is a convention of , or in the amount of data preceded by digits) 16-LEN (A2))) (A3))) & A3 ) & A4 & REPT (requirements.
xxiii, build text in addition to again enter the histogram
outdoor, principle is very simple, it is the intelligent use of special symbols repeated, according to a specified cell showing the results of the comparable effectiveness of different lengths.
example, we first make an annual balance sheet,GHD Green Straighteners, and then font also drag the fill knob to the G14. We see that a function does not use Excel diagrams have been right in front of the histogram in plain text, handy and intuitive, simple and clear.
round, calculate the total number of words in a 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 function to remove spaces. For example cell A1 immediately enter a LEN (TRIM (A1))-LEN (SUBSTITUTE (TRIM (A1 ),use The number of characters.
XXV, the euro conversion
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 find it. However, we can first select the > After we again open the currency conversion display more vocational, we can also click on the Excel toolbar, the