Excel Form 35 strokes ambition study Cheats

Excel table Cheats
35 strokes will study to share friends
Of: Flower Mao Feng has been shared 1 times Comments (0) Links Share rebuilt duplicate report in Excel, you probably have hundreds of complete financial statements, perhaps you have been using Excel functions to achieve the complexity of thousands of operation, perhaps you think that Excel is nought but this,GHD Red Straighteners, even naught new. However, we repeated countless times journal in nearby to use all the skills in Excel is just one per penny. Excel in the heading from some little-known tips to begin, get a glance on the Excel Different customs.
one, so that alter types of file using different colors
in the 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,
1. Open the Click the second drop-down box on the right button, select the Click the
2. Click
3. setup is complete, press the
see it payroll, payroll data is not according to your request that come in different colors.

Second, a category 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, 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),GHD Precious Gift Set, OK to exit.
4. Select anyone cell in column C (eg, C4), click the right side of the drop-down button, select the appropriate 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 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 print the
Third, create a
1. the space in the toolbar right click, choose In the
Click
2. then in the (common 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 distribution 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 above operation, one by one to disc a special sign of the input of other nice
2. Open the A work space 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 clasp to correlate 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) apparent drag, select them and then right click in the shortcut list that appears, select , will not need to print the row (or column) hidden.
2. implementation
3. the hidden rows (or columns) are displayed, and repeat the operation,
4. After the need to publish a fashion, open the , publishing what, above the toolbar click the
6, so that data on demand if you want to sort
divisions where workers are sorted according to these sectors is not the name of the relevant information by either the Pinyin order, not by stroke mandate, how do? can be self- defined sequence mandate.
1. perform The team, 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 sheet entirely hidden chapter of the cell those who do not want to browse the contents of the inspection, had it hidden.
1. selected to conceal the contents of the cell (area), the implementation of
2. and then alternate to the
3. the implementation of the
afterward this set afterward the contents of the cell is no longer shown, is to use Excel's features can not be granted to clear the sky.
Tip:
8, so in English and Chinese input method seemed
smart editing table, some cells to enter the English, and some cells to enter the Chinese input usage is not convenient to switch again, why not set and let intelligent input means to adjust it?
selected range of cells to enter the Chinese, the implementation of tab, press the After the voting
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,GHD Leopard Grain, picked 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 encounter all our needs. We can customize a function to fulfil certain operations. Here, we define a calculated from the trapezoid area function:
1. The implementation of the
2. In the skylight, execute
3. the right of the defined function to complete.
can later use the built-in function is the same for using a custom function.
Tip: Use the above methods defined in the corresponding function is ordinarily only used in the workbook.
XI header following pictures
lining additional to the backdrop sheet is lining in the plenary 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 (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 picture underneath in the cell does not support typography.
second, with a hyphen get it (it is assumed that the B, C, D columns into one col.)
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,GHD IV Styling Set, use the
3. Select the E series, the implementation of , press the
4. the B, C, D, E column deleted, completion of the combination work.
Tip: Complete the steps from 1,2 combined achieve has been achieved, but at this time if you erase 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 often
Article
friend asked, For this consideration, I give here a simple method used to attain the function.
stored in student fulfilment is spurious here 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 ())))。
2. once another select the cell A1 , with the > At this point, the elementary fashion results segment, the following uncomplicated modified see.
3. adjust the row altitude and column breadth, the same selected range of cells A1 to G2 (No. 1 student achievement bar area), 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.
reception the What more applicable function. Excel box input requirements (such as related assist files, you can rapidly make sure the required function.
fifth, while 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 .
after, not matter in which the worksheet, simply open the > In before versions of Excel 2002 because the operation of a scope of cells namely too much trouble to add a boundary, Excel 2002 which traits a current development.
Click the drag button, pop-up in the subsequent drop-down catalogue, choose drop-down button, select a border neatness, and then in the range of cells you need to add haul and drip the skeleton, you can quickly paint the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame, does not matter, on the toolbar select Color



seventh, the control input text given the length of the cell
Can you imagine when you enter the 4 digits of the cell was filled with a digit, or enter text in the cell Enter the number you have the time, Excel will automatically determine, immediate thinking and pop-up omen, then be fine ah,GHD Green Butterfly 2011! To achieve this function, the Excel, is also not difficult.
example, we register the cursor to a Therefore, we can press the In the Then in the We then come to and
Obviously, when somebody entered the cell is not a four-digit time, Excel will exhibit a warning dialog box pops up differentiating you bad causes, and until you enter the correct to persist recording. Amazing? In fact, in Excel's , why not given a free hand, their devise of a test standard, so you do Excel show especial luster.
eighth, a team of more than fill the form of fixed cells
we kas long aseach time you open Excel, the software is forever turned on by default multiple canvases. In addition to this we can see that Excel has a mighty capacity leaflet form, more appropriate for multiple interrelated tables coordination. To coordinate the union, of lesson, first need to sync input. Therefore, in numerous 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 first worksheet tab name is not associated with the form, you can prop down the Ctrl key to click.) At this point, we see the name of the title bar of Excel, a The need to enter more than one cell in the table of contents casually write someone, we find that
But fair sync input is not enough. For example, we need multiple forms of data in the same location change the format of the uniform how to do? First, we must change the data format of the 1st table, and then click the The sub-menu, select At this period, Excel ambition pop up
nineteenth and change the text of the case
in Excel, the form processing and data computing aid for the maximum powerful formula is not, neither is the database, merely the function. Do not calculate that Excel, the function only for numbers, in truth, as long as the content is written into the table, Excel has a special function to amend it. Such as changing the text of the case.
in Excel 2002, invest at fewest three of the txt circumstance conversion function. They are: into For example, a chart in cells A1 enter lower case Similarly, if we enter the cell A3
twenty, extract specific characters in a string
In addition to straight input, from an existing cell to extract the contents of a specific character input, is indeed a way to save time and save trouble, particularly for some style especially similar information, such as staff lists, location of origin and other information.
quickly if we want to extract the cells from A4 title, it is best to use characters Of course, if you want to extract the name, then, will must use the In another case, we do not start from the left and right ends, but instantly extracted from the data megalopolis 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 found is a more intricate problem. Because it does not a very firm pattern: Most of the diagrams are accustomed into ordinal st Moreover, Therefore, it seems very complex to implement. In fact, at all times we sort out minds, detect the function, just write a formula that can be easily converted. Do not believe, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII, fraught with special characters and monetary dealings with the centre
folk understand, when filling in the writing there is a convention of , alternatively in the measure of data preceded by digits) 16-LEN (A2))) (A3))) & A3 ) & A4 & REPT (requirements.
xxiii, build text in addition to again enter the histogram
outdoor, rule is very simple, it is the intelligent use of special symbols reiterated,GHD, according to a specified cell showing the results of the comparable effectiveness of different widths.
example, we first make an daily equilibrium sheet, and then font also drag the fill handle to the G14. We see that a function does not use Excel charts have been right in front of the histogram in plain text, convenient and intuitive, simple and remove.
round, calculate the absolute digit of words in a cell
Sometimes, we may have the temperament of a cell in the number of amused need to calculate the total number of words in the cell. To solve this problem, in increase 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 money conversion display more professional, we can also click on the Excel toolbar, the