Maybe you yet have hundreds of Excel to complete the monetary expressions, maybe you have used Excel functions as complex operations a thousand times, possibly you think that Excel is nobody but this, even nothing new. However, we repeated countless times annual in nearby to use all the skills in Excel is equitable one per cent. Excel in the topic from some little-known tips to start, get a glimpse on the Excel Different customs.
an, so namely assorted types of data using differ colors
in the payroll, if you want more than equal to the absolute compensation of 2,000 yuan to greater than or equal to the aggregate 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, reception the
see it payroll, payroll data is not according to your request that come in different colors.
Second, a Category drop-down catalogue filled with items
name of the affair we often want to enter into the table, the name in mandate to nourish consistency, the use of Function
1. in Sheet2 in the name of the business by category (such as
2. Select A column (
modeled aboard the upon action, the B, C ... ... column labeled such for the C col), the implementation of In the Enterprise
absence to enter the company name and then select the column (eg column D), and then open the C1), OK to exit.
4. Select anybody 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),
Womens Air Max 87 Black/Pilgrim/Birch Nike Shoes, 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 printing a report in the future, if you do not need to print the
Third, create a
1. the space in the toolbar right press, select In the
Click
2. then in the (mutual 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 delivery Hyperlink By urgent 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 record a special sign of the input of other agreeable
2. Open the A work 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 retinue the shortcut list, 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 hidden rows (or columns) are displayed, and repeat the operation,
4. After the need to publish a manner, open the , publishing what, on the toolbar click the
6, so that sort of data on-demand employee
If you want to sort according to your department, the name of either of these departments is not according to the phonetic information approximately the order, nor is it by stroke order, how do? can be self- defined sequence order.
1. execute The group, a workshop, two workshops, three workshops,
2. Select the one of the drop-down clasp, select the just-defined series, by two
seven
the data sheet entirely secret part of the contents of the cell do not want to enabling observers to way, had it secret.
1. selected to hide the contents of the cell (area), the implementation of
2. and then alternate to the
3. the implementation of the
after this set afterward the contents of the cell is not longer shown, is to use Excel's functions can not be granted to clear the sky.
Tip:
eight, so in English and Chinese input method seemed
intelligent editing table, some cells to enter the English,
inexpensive nike atmosphere max 95 China's 4 notable ( hear, see, peruse and enj, 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 scope of cells to enter the Chinese, the implementation of tab, reception the After the co-optation
range of cells that need to input Chinese characters in any cell, Chinese input method (IME list,
Mens Air Max 180 White/Green/Blue Nike Shoes, 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 hereafter, simply enter
ten, a custom function in Excel, nevertheless the wealthy
Excel function, yet it does not meet all our needs. We can customize a function to fulfil definite operations. Here, we define a reckoned 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 ordinarily only used in the workbook.
XI header following pictures
lining added to the backdrop sheet is lining in the all worksheet below, can not merely lined the first in the table below it?
1. execute → Background Worksheet
2. when holding down the Ctrl key, right in the picture without lining cells (area) in haul, 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 printing.
second, with a hyphen obtain it (it is assumed that the B,
nike 3.5 y After 90 damn , a tall class !, C, D columns into one column.)
1. in the D column, insert two empty columns (E, F array), and then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells repeatedly elected, use the
3. Select the E series, the implementation of , press the
4. the B, C, D, E column canceled, completion of the combination work.
Tip: Complete the steps from 1,2 combined efficacy has been achieved, but at this time if you delete B, C, D series, the formula error. And accordingly should be carried out step 3, the formula is converted to the same
Article
students often results friends queried, For this consideration, I give here a simple usage used to effect the function.
stored in student achievement is assumed here Sheet1 worksheet range of cells A1 to G64, which doing 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 again select the cell A1 , with the > At this point, the basic fashion results section, the following simple modified see.
3. modify the row altitude and column length, the same selected range of cells A1 to G2 (No. 1 student finishing bar area), according to The emulating operation).
4. also selected range of cells A1 to G3, click on the To multiplication a border always the results segment.
press the What more appropriate function. Excel box input requirements (such as related help 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 essential View other work sheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
after, 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 much distress to add a border, Excel 2002 which features a new development.
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 drop the frame, you can immediately paint the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame, does not stuff, on the toolbar select Color
seventh, the control input text given the length of the cell
Can you dream when you enter the 4 digits of the cell was filled with a numeral, or enter text in the cell Enter the number you have the time, Excel will automatically resolve, immediate thinking and pop-up omen, then be fine ah! To achieve this function, the Excel, is also not complicated.
example, we register the cursor to a Therefore, we can click the In the Then in the We then come to and
Obviously, while somebody entered the cell is not a four-digit time, Excel ambition display a warning dialog box pops up narrating you bad causes, and until you enter the correct to persist recording. Amazing? In truth, in Excel's Why not self-assertion, their design a testing criteria, so you do Excel show unique polish.
eighth, a group 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 sheets. In addition to this we can see that Excel has a strong capability pamphlet form, more suitable for multiple interrelated tables coordination. To coordinate the federation, of way, 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 team amend of tables? First we click the first worksheet tab name is not associated with the form, you tin clutch down the Ctrl key to click.) At this point, we look 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 location change the format of the uniform how to do? First, we have to change the data format of the first table,
Mens Air Max Skyline Running Red/Blue/White Nike Shoes, 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 maximum mighty formula is not, neither is the database, but the function. Do not think that Excel, the function only for mathematics, in fact, at the peak of 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 fewest 3 of the txt circumstance 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 personas 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 save trouble, principally fall butme style especially similar information, such as staff lists, place of origin and other information.
quickly if we want to extract the cells from A4 title,
Womens Air Max 87 White/Red/Grey Nike Shoes, 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 directly 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, into the found ordinal number words to English words into ordinal found is a more complex problem. Because it does not a very firm pattern: Most of the figures are used into ordinal st Moreover,
Mens Lebron James VII(7th) P.S. White/Black Nike Shoes, Therefore, it seems very perplexing to implement. In fact, by the time we sort out fancies, find the function, just write a formula that can be lightly converted. Do not deem, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII centre filled with special symbols
and financial dealings with the people know,
For a living, when filling in the book there is a convention of symbols. In fact, in Excel, has a similar input method, that is, Its basic format is
example, we have to figure in the A2 cell to the end with a ))) & A3 REPT (A5 ,
xxiii, create text histogram
increase to again enter the outside, Its principle is very simple, it is the smart use of special symbols continual, along to a specified cell showing the results of the relative effectiveness of different lengths.
example, we first make an anniversary balance canvas, and then zone. The results have been based on the table and then Specific treads are consist in ...:
write in the formula in cell E3 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 digit of words in a cell
Sometimes, we may be in a cell are amused in the number of characters, need to calculate the total number of words in a cell. To solve this problem, in addition to using the For example cell A1 immediately enter a
the averaging of the style is to use
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 However, we can first select the We once again finished
open the Excel window with additional functions, we can set the money conversion mouse Is shown in Of course, in order to display the euro is more vocational, we can also click on the Excel toolbar, the
Womens Air Max 87 Black/Pilgrim/Birch Nike Shoes E
Threaded Mode