Excel will push the table 35 Cheats study Excel, you may have had hundreds of complete financial statements, maybe you have used Excel functions for complex operations a thousand times, possibly you think that Excel is naught but that, even nothing new. However, we repeated innumerable times annual in convenient to use all the skills in Excel is just one per penny. Excel in the topic from some little-known tips to start, get a glance 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
look it payroll, payroll data is not according to your request that come in differ colors.
Second, a species drop-down catalogue filled with items
name of the commerce 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 ... ... col 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 fitting Then select the cell corresponding to the D column cell (eg D4), click the drop-down button to the proper 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 upon 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,
PULSERA AZUL CON BANDERA, the hyperlink documents together.
4. After the absence 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 agreeable
2. Open the A go space in the toolbar.
alternate to the How numerous buttons).
3. Select one of the
4. Right-click the button after a name, in the following the shortcut list, select exit.
Repeat this step, the button 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 shuffle, select them and then right click in the shortcut menu that appears, select , will not need to publish the row (or column) hidden.
2. implementation
3. the secret rows (or columns) are exhibited, and reiterate the operation,
4. After the need to print a form, open the , publishing what, on the toolbar click the
6, so that data aboard demand whether you absence to sort
departments where workers 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? tin be self- defined sequence array.
1. execute The group, a workshop, two workshops, three workshops,
2. Select the 1 of the drop-down clasp, elect the just-defined series, by two
seven
the data sheet completely hidden part of the cell those who do not want to browse 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
later this set after the contents of the cell is not longer shown, is to use Excel's features can not be allowed to explicit the sky.
Tip:
eight, so in English and Chinese input method arose
intelligent 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 intelligent input method to adjust 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 whichever 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, a custom function in Excel, notwithstanding the wealthy
Excel function, but it does not meet all our needs. We can customize a function to perform definite 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 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 usually only used in the workbook.
XI header following pictures
lining added to the backdrop sheet is lining in the plenary worksheet below, can not only lined the first in the table below it?
1. perform → Background Worksheet
2. when 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 under in the compartment does not support publishing.
second, with a hyphen obtain it (it is imagined 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 ,
PULSERA TRANSPARENTE CON LOGO XB, press the
4. the B, C, D, E column deleted, achievement of the merger work.
Tip: Complete the steps from 1,2 combined efficacy has been achieved,
PULSERA BLANCA CON NETHERLANDS, but at this time if you delete B, C, D series, the formula error. And accordingly ought be carried out step 3, the formula is converted to the same
Performance of Students often
Article
friend inquired, For this consideration, I give here a uncomplicated method secondhand to fulfill the function.
cached in student finishing is pretended here Sheet1 worksheet range of cells A1 to G64, which perform caption 1, 2 acts subject name.
1. Switch to Sheet2 worksheet, select cell A1, enter the formula: = IF (MOD (ROW (), 3) = 0, , sheet1,
PULSERA BLANCA CON ITALIA! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. once anew select the cell A1 , with the > At this point, the elementary shape results section, the following simple modified see.
3. modify the row elevation and column width, 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 increase a border entire the results partition.
press the What more appropriate function. Excel box input requirements (such as narrated assist files, you can quickly determine the necessitated function.
fifth, while viewing 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 stuff in which the worksheet, simply open the > In before versions of Excel 2002 for the operation of a range of cells is also much trouble to add a border, Excel 2002 which features a current evolution.
Click the pull 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 drop the frame, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you paint the wrong border,
Xtreme Balance, 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 number, or enter text in the cell Enter the number you have the time, Excel will automatically determine, immediate analysis and pop-up advising, then be pleasing ah! To achieve this function, the Excel, is too 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 somebody entered the cell is not a four-digit time, Excel will display a warning dialog carton pops up telling you wrong causes, 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 criterion, so you do Excel show distinctive gloss.
eighth, a team of extra than fill the form of fixed cells
we kas long aseach time you open Excel, the software is all cornered on by default multiple sheets. In addition to this we can see that Excel has a lusty capability pamphlet form, more suitable for multiple interrelated tables coordination. To coordinate the union, 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 first 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 table of contents casually write something, we find that
But just sync input is not enough. 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 popup up
nineteenth and change the text of the case
in Excel, the manner processing and file computing patronize as the most powerful formula is no, nor namely the database, but the function. Do not calculate namely Excel, the feature merely because numbers, in truth, at a time the content is written into the chart, Excel has a special function to edit it. Such for changing the txt of the case.
in Excel 2002, cater at least three of the text case conversion function. They are: into For sample, a table in cells A1 enter lower case Similarly, if we enter the cell A3
twenty, extract specific characters in a string
In adding to straight input, from one existing cell to extract the contents of a characteristic character input, is absolutely a path to save period and retention difficulty, primarily fknow next to nothing ofme neatness particularly similar information, such as staff lists, area 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 have to use the In variant case, we do not start from the left and right ends, but instantly extracted from the data centre 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 bottom is a more complicated problem. Because it does not a very firm pattern: Most of the figures are used into ordinal st Moreover, Therefore, it seems very perplexing to appliance. In fact, at the peak of we sort out ideas, find the function, equitable write a formula that can be lightly converted. Do not deem, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII, filled with special symbols and fiscal dealings with the centre
folk know, 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, create text in addition to again enter the histogram
outside, rule is very simple, it is the smart use of special symbols continual, according to a specified cell showing the results of the comparative effectiveness of different lengths.
example, we first make an annual poise sheet, and then font also drag the fill handle 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.
circular,
PULSERA TRANSPARENTE VENEZUELA, calculate the total number of words in a cell
Sometimes, we may have the character of a cell in the number of amused need to calculate the aggregate number of words in the cell. To solve this problem, in addition to using the function to remove spaces. For example cell A1 now 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 currency conversion display more professional, we can also click on the Excel toolbar, the
Excel chart Cheats
Linear Mode
