Excel Form 35 strokes ambition study Cheats

Excel table Cheats
35 strokes will study Excel,Kids' Supra Skytop Shoes, you may have had hundreds of complete financial statements, perhaps you have accustom Excel functions for complex operations a thousand periods, maybe you think Excel also much, or even nobody new. However, we repeated innumerable times annual in convenient to use always the skills in Excel is just one per penny. Excel in the topic from some little-known tips to start, get a glimpse on the Excel Different customs.
one, so that different types of data using different colors
in the payroll, whether you absence more than equal to the total wages of 2,000 yuan to greater than or equal to the aggregate wages of 1,500 yuan,Women's Supra Vaider Shoes,
1. Open the Click the second drop-down box on the right button, select the Click the
2. Click
3. install is complete,Supra TK Society Shoes, reception the
see it payroll, payroll data is not according to your request that come in different colors.

Second, a classification drop-down list filled with items
name of the business we often want to enter into the table, the name in order to maintain 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,Supra Bullet Shoes, the B, C ... ... column named such as the C column), the implementation of In the Enterprise
need to enter the undertaking appoint and then select the col (eg column D), and then open the C1), OK to exit.
4. Select any cell in column C (eg, C4), press the right side of the drop-down button, select the proper Then select the cell corresponding to the D column cell (eg D4), press the drop-down button to the applicable category commerce name from the list, select the name of the enterprise need to fill the cell.
Tip: When typography a report in the future, if you do not need to publish the
Third, create a
1. the space in the toolbar right click, choose In the
Click
2. then in the (mutual 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 delivery Hyperlink By pressing the
repeat the on action, the list item and its corresponding workbook, the hyperlink documents attach.
4. After the need to open the
Tip: Although we will
four,Cheap Supra Shoes, making
1. the implementation of the Select the .
modeled aboard the above operation, one by one to record a special sign of the input of other nice
2. Open the A go 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 step, the button to 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 invisible rows (or columns) are exhibited, and repeat the operation,
4. After the need to print a form, open the , promulgating what, on the toolbar click the
six, so that data on demand if you want to sort
departments where workers are arranged according to these sectors is not the name of the pertinent information by both the Pinyin mandate, not by stroke order, how do? can be self- defined sequence array.
1. execute The crew, a workshop, two workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined sequence, by two
seven
the data page completely hidden part of the contents of the cell do not want to enabling guests 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
later this set after the contents of the cell is not longer shown, is to use Excel's functions can not be granted to explicit the sky.
Tip:
8, so in English and Chinese input method appeared
smart editing table, some cells to enter the English, and some cells to enter the Chinese input method is not handy to switch again, why not set and let smart input usage to accommodate it?
selected range of cells to enter the Chinese, the implementation of tab, press the After the election
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 wealthy
Excel function, but it does not meet all our needs. We can customize a function to act decisive operations. Here, we define a calculated from the trapezoid area function:
1. The implementation of the
2. In the skylight, perform
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 routinely only used in the workbook.
XI header following pictures
lining added to the background of the worksheet is the lining in the entire worksheet under, can no merely lined the premier in the chart beneath it?
1. execute → 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 fact, is the picture to be
Tip? lining the image beabsent from the cell does not support printing.
second, with a hyphen get it (it is supposed that the B, C, D columns into one column.)
1. in the D column, insert two blank columns (E, F sequence), 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 achieve has been achieved, merely at this time if you cancel B, C, D series, the formula mistake. And accordingly should be carried out step 3, the formula is converted to the same Performance of Students


article
friends constantly ask, For this attention, I give here a simple method used to effect the function.
stored in student achievement is spurious here Sheet1 worksheet range of cells A1 to G64, which perform title 1, 2 acts subject name.
1. Switch apt Sheet2 worksheet, choose 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 shape results partition, the following simple modified see.
3. adjust the row height and column width, the same selected range of cells A1 to G2 (No. 1 student fulfilment bar zone), 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 appropriate function. Excel box input requirements (such as narrated aid files, you can quickly determine the necessitated function.
fifth, meantime viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), it is essential View other work sheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
later, no stuff 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 pull clasp, pop-up in the subsequent drop-down list, choose drop-down button, select a siteline neatness, and then in the range of cells you need to add tow and drip the border, you can fast paint the corresponding range of cells on the border.
Tip: ① If you draw the bad frame, does not matter, on the toolbar select Color >

XVII Enter the text in specific cells controlling the length of
Can you imagine when you enter the 4 digits of the cell was filled with a numeral, or entering text in the cell number you have entered time, Excel will automatically resolve, immediate inquiry and pop-up warning, then be good ah! To achieve this function, the Excel, is also not tough.
example, we enroll the cursor to a the cell in order to enter the calculation of the unified and cozy, we hope that the Card admonition year. style time distance,
We kas long aseach time you open Excel, the software is forever cornered on by default multiple sheets. Thus we can see that Excel has a lusty addition to the processing power of single forms, more suitable for multiple interrelated coordination table . to coordinate the union, 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 team of tables? First We click the first worksheet tab name ). At this point, we discern 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 popup up IX, change the text in the case of
in Excel for form processing and data computing support is not the most powerful formula, nor is the database, but function. Do not think that Excel, the function only for numbers, in fact, by the time 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 3 of the text circumstance conversion function. They are: UPPER (source data grid), case, such as obtaining the first letter of every word is capitalized. For sample, we have a form of cell A1 enter the lowercase the outcome the motorcar will be will be the method retention distress, particularly because some of the information primarily alike style, such as staff lists, location of origin and other information.
quickly if we want to extract the cells from A4 caption, it is best to use to extract the number of characters) grid, the number of temperaments extracted) words, only in the target cell to enter and 5 words.
the twenty-first, into the base ordinal number words to English words into ordinal base is a more complex problem. because it is not a very fixed pattern: Most of the diagrams into ordinal number is used in the Moreover, function, just write a formula that can be lightly converted. do not believe, see: IF (OR (VALUE (RIGHT (A2)) = 1,2,3,, CHOOSE (RIGHT (A2), Despite the long list,Supra Vaider Shoes, but the averaging is very clear: ① If the number is to main and ordinal conversion words so easy and rapid implementation.
XXII, filled with special symbols and financial dealings with the centre
human know, while filling in the book there is a conventional Safety Fill Law The elementary format is the formula to ought be changed to REPT (brain paired with # # 0.00 worksheet consisting of plain text to establish the histogram. It is also very easy conviction, namely is, the clever use of special characters continual according to a specified cell showing the results of the comparative effectiveness of different widths.
example, we first Annual product of a poise sheet, and then The results have been ROUND (D3 * 100,0 )),> round to calculate the total number of words in the cell
Sometimes, we may have the character of a cell in the number of amused need to calculate the total number of words in the cell. To solve this problem, in counting to using the SUBSTITUTE > is to use Finally, the number of spaces +1 to draw the number of characters in the cell was.
XXV, the euro transition
This is a new tool in Excel 2002. If you choose to setup the Excel 2002 is the default, then it may not be in the . with the Excel window, the other functions, we can set the money conversion mouse equality EU list of other currencies. Of way, in order to display the euro is more professional, we can also click on the Excel toolbar, the >