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 periods Comments (0) Links Share procreated duplicate report in Excel, you probably have hundreds of complete financial expressions, maybe you have been using Excel functions to attain the complexity of thousands of operation, perhaps you meditation that Excel is nothing but this, even naught new. However, we reiterated countless periods everyday in convenient to use all the capabilities in Excel is just one per cent. Excel in the topic from some little-known tips to begin, obtain a glimpse on the Excel Different customs.
one, so that different types of data 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. install is complete, press the
discern it payroll, payroll data is not according to your apply 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 retain consistency,GHD IV Dark Straighteners, 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 company name and then select the column (eg column D), and then open the C1), OK to exit.
4. Select any 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, build a
1. the space in the toolbar right click, choose In the
Click
2. then in the (prevalent 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 distribution Hyperlink By urgent the
repeat the above operation, the menu item and its corresponding workbook, the hyperlink documents together.
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 record a special sign of the input of other nice
2. Open the A work area in the toolbar.
switch to the How numerous buttons).
3. Select one of the
4. Right-click the button after a name, in the retinue the shortcut menu, select exit.
Repeat this step, the button to link with the corresponding macro.
5. close the
five, with
1. Open the worksheet to print, use the mouse without the need to publish the row (or col) marked 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 print a fashion, open the , publishing what, on the toolbar click the
6, 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 pertinent information by both the Pinyin mandate, not by stroke order, how do? can be self- defined sequence order.
1. execute The team, a workshop, two workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined sequence, along 2

seven
the file sheet entirely invisible portion of the cell those who do not absence to explore the contents of the inspection, 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
after this set after the contents of the cell is not longer shown, is to use Excel's functions can not be allowed to remove the sky.
Tip:
8,GHD Blue Straighteners, 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 means is not handy to alternate anew, why not set and let smart input means to adjust it?
selected range of cells to enter the Chinese, the implementation of tab, reception 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 hereafter, simply enter
ten,GHD Hair Straightener, a custom function in Excel, though the wealthy
Excel function, but it does not encounter all our needs. We can customize a function to execute decisive operations. Here, we define a calculated from the trapezoid area function:
1. The implementation of the
2. In the window, execute
3. the right of the defined function to complete.
can afterward use the built-in function is the same for using a custom function.
Tip: Use the upon methods defined in the corresponding function is normally only accustom in the workbook.
XI header following pictures
lining additional to the backdrop sheet is lining in the all worksheet below, can not only lined the 1st in the table underneath it?
1. perform → Background Worksheet
2. meantime holding down the Ctrl key, right in the picture without lining cells (district) 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 below in the cell does not patronize printing.
second, with a hyphen get it (it is pretended that the B, C, D columns into one column.)
1. in the D column, insert two blank columns (E, F array), 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, achievement of the combination work.
Tip: Complete the steps from 1,2 combined efficacy has been achieved, but at this time if you cancel B, C, D series, the formula peccadillo. And accordingly should be carried out step 3, the formula is converted to the same


Performance of Students constantly
Article
friend queried, For this consideration, I give here a simple method used to achieve the function.
cached in student achievement is assumed here Sheet1 worksheet range of cells A1 to G64, which perform caption 1,GHD Red Butterfly 2011, 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 elementary shape results section, the following easy modified look.
3. adjust the row height and column breadth, the same selected range of cells A1 to G2 (No. 1 student fulfilment bar area), according to The following operation).
4. likewise 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 assist files, you can quickly make sure the necessitated function.
fifth, while outlooking 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,GHD IV Straighteners, no matter in which the worksheet, simply open the > In previous editions of Excel 2002 for the operation of a range of cells is too many trouble to add a border, Excel 2002 which features a new evolution.
Click the drag button, pop-up in the subsequent drop-down menu, select drop-down button, choose a siteline neatness, and then in the range of compartments you absence apt add tug and drop the frame, you can immediately draw the corresponding scope of cells ashore the siteline.
Tip: ① If you draw the bad frame, does not matter, on the toolbar select Color



seventh, the control input text given the length of the cell
Can you assume when you enter the four 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, instant thinking and pop-up alarm, then be fine ah! To achieve this function, the Excel, is also not tough.
example, we enrol 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 advising dialog box pops up telling 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 standard, so you do Excel show uncommon sheen.
eighth, a group of more than fill the form of fixed cells
we know thateach time you open Excel, the software is all turned on by default multiple sheets. In addition to this we can see that Excel has a strong capacity pamphlet form, more appropriate for multiple interrelated tables coordination. To coordinate the association, 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 team edit of tables? First we click the first worksheet tab name is not related 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 just sync input is insufficient. For example, we need multiple forms of data in the same position change the format of the uniform how to do? 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
nineteenth and change the text of the case
in Excel, the form processing and data computing support for the most mighty formula is not, nor is the database, but the function. Do not think that Excel, the function only for numbers, in fact, at a time 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, invest by least 3 of the text case transition function. They are: into For example, a table in cells A1 enter lower case Similarly, whether we enter the cell A3
twenty, extract characteristic roles in a string
In adding to direct input, from an existing cell to extract the contents of a specific character input, is indeed a path to save time and save trouble, particularly fjust aboutme style especially similar information, such as staff lists, area of origin and other message.
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 variant case, we do not start from the left and right ends, but instantly extracted from the data hub 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 base ordinal digit words to English words into ordinal bottom is a extra complicated problem. Because it does not a very nailed pattern: Most of the figures are used into ordinal st Moreover, Therefore, it seems very difficult to implement. In fact, at a time we sort out motifs, find the function, just write a formula that can be easily converted. Do not deem, see: ,GHD IV Salon Straighteners, 2,3,}, CHOOSE (RIGHT (A2), is
XXII, filled with special characters and financial dealings with the median
people understand, when filling in the book there is a convention of , or in the quantity of data preceded by digits) 16-LEN (A2))) (A3))) & A3 ) & A4 & REPT (requirements.
xxiii, create text in addition to repeatedly enter the histogram
outside, conviction is very simple, it is the intelligent use of special symbols repeated, according to a specified cell showing the results of the relative effectiveness of different lengths.
example, we first make an year equilibrium sheet, and then font also drag the fill handle to the G14. We see that a function does not use Excel diagrams have been right in front of the histogram in plain text, convenient 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 think the aggregate number of words in the cell. To solve this problem, in addition to using the function to clear 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