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 consider that Excel also much, or even naught new. However, we repeated innumerable times journal in convenient to use all the capabilities in Excel is just one per penny. Excel in the heading from some little-known tips to start, get a glance on the Excel Different customs.
one, so that different 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,GHD Purple Gift Set,
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
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 absence to enter into the table, the name in mandate to preserve consistency, the use of
1. in Sheet2 in the name of the business by classification (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), 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, establish a
1. the space in the toolbar right click, choose In the
Click
2. then in the (general document), and modeled it for the operation of the above named (such for
repeat the above operations, multi-document catalogue to add a few names.
3. Select the distribution Hyperlink By pressing the
reiterate the above operation, the list item and its corresponding workbook,GHD Diamond Flag 2011, 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 aboard the above operation, an along an to log a special sign of the input of other good
2. Open the A go district 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 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) apparent 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 secluded rows (or columns) are displayed, and repeat the operation,
4. After the need to print a form, open the , promulgating what, on the toolbar click the
6, so that data on demand if you want to sort
divisions where employees are sorted according to these sectors is not the name of the relevant information by both the Pinyin order, not by stroke order, how do? can be self- defined sequence order.
1. perform The team, a workshop, two workshops, three workshops,
2. Select the one of the drop-down button, choose the just-defined series, by 2


7, the data sheet completely hidden
portion of the contents of the cell do not want observers to access, had it hidden.
1. selected to hide the contents of the cell (area), the implementation of
2. and then alternate apt the
3. the implementation of the
behind this set later the contents of the cell is no longer shown, is to use Excel's traits can not be allowed to clear the sky.
Tip:
eight, so in English and Chinese input method 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 intelligent input method to modify it?
selected range of cells to enter the Chinese, the implementation of tab, reception the After the referendum
range of cells that need to input Chinese characters in anyone cell, Chinese input method (IME list, the first a Chinese input method) automatically open, selected 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, however the rich
Excel function, but it does not encounter all our needs. We can customize a function to perform decisive operations. Here, we define a calculated from the trapezoid area function:
1. The implementation of the
2. In the skylight,GHD Carry Case & Heat Mat, execute
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 normally only used in the workbook.
XI header following pictures
lining additional to the backdrop of the worksheet is the lining in the all 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 tow, 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 aid typography.
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 vacant 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 erased, achievement of the combination work.
Tip: Complete the steps from 1,2 combined effect has been achieved, but at this time if you delete B, C, D series, the formula mistake. And accordingly ought be carried out step 3, the formula is converted to the same


Performance of Students often
Article
friend queried, For this consideration, I give here a simple method used to effect the function.
cached in student fulfilment is spurious here Sheet1 worksheet range of cells A1 to G64,GHD Classic Straighteners, 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 afresh select the cell A1 , with the > At this point, the basic fashion results segment, the following simple modified see.
3. adjust the row altitude and column length, 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 frame all the results section.
press the What more fitting function. Excel box input requirements (such as related aid files, you can speedily resolve the necessitated function.
fifth, while outlooking a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), 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 before editions of Excel 2002 for the operation of a range of cells is also many trouble to add a border, Excel 2002 which features a new evolution.
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 frame, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong skeleton, 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 four digits of the cell was filled with a number, or enter text in the cell Enter the number you have the time,GHD Hair, Excel will automatically determine, immediate thinking and pop-up alarm, then be good ah! To achieve this function, the Excel, is also not difficult.
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 warning dialog box pops up telling you wrong reasons, and until you enter the correct to proceed recording. Amazing? In fact, in Excel's , why not given a free hand, their design of a test standard, so you do Excel show especial polish.
eighth, a group of more than fill the form of firm cells
we know thateach time you open Excel, the software is always turned on by default multiple sheets. In counting to this we can see that Excel has a muscular capability brochure form, more suitable for multiple interrelated tables coordination. To coordinate the union, of course, first need to sync input. Therefore, in many cases, ambition need more than the same time in the same table cell, enter the same content.
So how do a group amend of tables? First we click the 1st worksheet tab name is not related with the form, you can hold 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 chart 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 situation 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 popup up
nineteenth and alteration the text of the case
in Excel, the form processing and data computing support for the maximum powerful formula is not, neither is the database, but the function. Do not think that Excel, the function merely for numbers, in fact, as long as 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 conversion function. They are: into For example, a table 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 absolutely a way to retention time and retention distress, principally fknow next to nothing ofme manner principally alike information, such as staff lists, place 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 heart 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,GHD Deluxe Midnight 2011, into the base ordinal digit words to English words into ordinal pedestal is a extra intricate problem. Because it does no a very nailed pattern: Most of the figures are used into ordinal st Moreover, Therefore, it seems very intricate to implement. In truth, at a time we arrange out fancies, ascertain the feature, equitable write a formula that tin be accessible converted. Do no deem, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII, fraught with special characters and financial dealings with the median
people understand, when filling in the paperback there is a convention of , or in the sum of data preceded by digits) 16-LEN (A2))) (A3))) & A3 ) & A4 & REPT (requirements.
xxiii, create text in addition to repeatedly enter the histogram
appearance, principle is very simple, it is the smart use of special symbols continual, along to a specified compartment showing the results of the comparative effectiveness of another lengths.
example, we first make one yearly balance sheet, and then font also drag the fill deal to the G14. We see that a function does not use Excel designs have been right in front of the histogram in plain text, convenient and intuitive, simple and clear.
round, calculate the aggregate number of words in a cell
Sometimes, we may have the temperament 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 setup 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 vocational, we can also click on the Excel toolbar, the