| Back to logs list
Reprinted from 574442788 at 13:05 on December 24 2009 Reading (loading. ..) Comments (0) Category: Personal Diary First, the establishment of categories 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), the implementation of In the Enterprise Need to enter the enterprise name and then select the column (eg column D), and then open the 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 printing a report in the future, if you do not print
Second, to establish a 1. The space in the toolbar right click, choose In the Click
2. then in the (common document), and modeled it for the operation of the above named (such as Repeat the above operation, 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 together.
4. After the need to open the Tip: Although we will function.
three, so that different types of data using different colors
in the payroll, if you want more than equal to the total wage of 2,000 yuan to
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 Look it payroll, payroll data is not according to your request that come in different colors.
four, making
1. the implementation of the to start recording. Select the. Modeled on the above operation, one by one to record other special symbol input good
2. Open the A work area in the toolbar. Switch to the.)
3. Select one of the
4. Right-click the button after a name, in the following 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 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 print a form, open the, publishing what, on the toolbar click the
six, so that sort of data on-demand employee
If you want to sort according to your department, the name of both of these departments is not according to the phonetic information about the order, nor is it 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, by two
seven
the data sheet completely hidden part of the contents of the cell do not want visitors to access, 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 no longer shown, is to use Excel's features can not be allowed to clear the sky. Tip: In the
eight, so in English and Chinese input method appeared
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 adjust it? selected range of cells to enter the Chinese , the implementation of Press Elected in the future the Chinese will need to enter an arbitrary range of cells a cell, the Chinese input method (IME list, the first a Chinese input method) automatically open, was elected the other cell, Chinese input method automatically shut down.
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, although the rich
Excel function, but it does not meet all our needs. We can customize a function to perform certain 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.
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 background of the worksheet is the lining in the entire worksheet below, can not only lined the first in the table below it?
1. execute → Background Worksheet 2. While holding down the Ctrl key while using the mouse 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 Tips? Lining in the cell below the picture is not supported by print.
second, with a hyphen get it (it is assumed that the B, C, D columns into one column.)
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, use the
3. Select the E series, the implementation of, press the
4. the B, C , D, E column deleted, completion of the merger 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 error. And thus should be carried out step 3, the formula is converted to the same
XIII Quick Print Article
student achievement are often friends asked, difficult. For this consideration, I give here a simple method used to achieve the function. Here assume that student performance stored in Sheet1 worksheet range of cells A1 to G64, 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 $ 2, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1),
让人吐血的脑筋急转弯, COLUMN ())))。 2 . once again selected the cells A1, with the basic shape, the following simple modification of it. 3. adjust the row height and column width, the same selected range of cells A1 to G2 (No. 1 student achievement bar area), press the the drop-down button, the border followed the list, select the selected range of cells A1 to G3, click on the you narrow down the scope to choose appropriate function. implementation of the to fifth, while viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), you need to view the other worksheet (Sheet2, Sheet3 ... ...) to a cell content,
A Dying Man's Favorite Cookies, you can use Excel's with the mouse to select the cell you want to view, then click All monitoring points within the cell data and related information.
XVI quickly draw the border for a cell in Excel 2002
previous versions, add a border for the operation of a range of cells is too much trouble, Excel 2002 对 This function of a new expansion. Click bar → border Quick draw border grid area. Tip: ① If the draw the wrong frame, does not matter, on the toolbar select need to draw the borders of different colors, you can press the toolbar on the right of the lattice diagonal slashes on the painting.
seventh, the control input text in a particular cell can you imagine the length of
when you enter the four digits of the cell was filled with a double-digit or enter text in the cell number you have entered the time, Excel will automatically determine the instant analysis and pop-up warning, then be nice ah! To achieve this function, the Excel, it does not difficult. For example, we register the cursor to a menu wrong reasons, and until you enter the correct a group of more than fill the form of fixed cells
we know that each time you open Excel, the software is always turned on by default multiple sheets. Thus we can see that Excel has a strong single table in addition to processing power, more suitable In the multiple interrelated tables coordination. to coordinate related, of course, first need to sync input. Therefore, in many cases, will need more than one table simultaneously in the same cell type the same content. So how to form to edit it in groups? First, we click the first worksheet tab name Ctrl + to select). At this point, we see the name of the title bar of Excel, a casually write something in the cell, we found that change the format of location data uniform how to do? First, we have to change the data format of the first table, and then click the Table.
nineteenth and change the text of the case
in Excel, the form processing and data computing support for the most powerful formula is not, nor is the database, but the function. Do not think that Excel, the function only for the number 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, provide at least three of the text case conversion function. They are: = UPPER (source data grid), the case, as to the first letter of each word is capitalized. For example, we have a form of cell A1 enter the lowercase Enter the results obtained will be will be less to deal with the method, especially for some of the information especially similar style, such as staff lists, place of origin and other information. If we want to quickly extract the cells from A4 title, it is best to use The number of characters) number of characters extracted) to simply enter the target cell 5 words.
the twenty-first, the base word into the English ordinal base
into ordinal word is a more complex problem. because it is not a very fixed pattern: most into ordinal numbers are used in the. Moreover, quasi-function, only the preparation of a formula, you can easily convert the. do not believe, see:, IF (OR (VALUE (RIGHT (A2)) = {1,2,3,}, CHOOSE (RIGHT (A2), Despite the long list of formulas, but the meaning is very clear: ① If the number is figures to, base words and conversion of ordinal so easy and fast implementation.
XXII, filled with a special symbol digit
and financial dealings with the people know, when filling in a book kind of conventional the formula to should read = REPT (the head with, # # 0.00 in the worksheet created by the histogram in plain text form. It is also very simple principle, that is, the intelligent use of special symbols repeated according to a specified cell showing the results of the comparative effectiveness of different lengths. For example, we first make a Zhang annual balance sheet, and then Results D3 * 100,0)), the formula histogram has been right in front of the text, convenient and intuitive, simple and clear.
round, calculate the total number of words in the cell
Sometimes, we may have the character of a cell in the number of interested need to calculate the unit The total number of words in the grid. To solve this problem, in addition to using the, then we can help with the following expression:) +1) come to. If you choose to install the Excel 2002 is the default, then it may not be in the Check the States currency conversion window to appear. and the Excel window, the other functions, we can set the currency conversion by the mouse is is the style of the euro.
XXVI, to the table to be a super search engine
we know, Excel spreadsheets and Word tables in Excel is the biggest difference is that the table will be filled all content (including static text) are included within the scope of the database. We can use the Enter the number of cells in the subject grade students. and in cells A8 to A13, we will set up a that is, cell C8, enter the name of any one of the students after the cell below it will automatically appear in the student achievement in various subjects. concrete implementation of the method is as follows: position the cursor to cell C9, and then click Insert The first column in the search for value) for the that is not. If it is, as, A2: B6, 2, FALSE) C8, A2: D6, 4, FALSE) Like, not repeat them). Next,
A Dying Man's Favorite Cookies, we have to test the The bottom of the cell in each subject will automatically show the results of the student enrollment.
twenty-seven, Excel worksheets and Word outline to establish the outline view
as, Excel this function is mainly used for treatment particularly the work of the table, it is difficult to key entries are displayed in the same screen problem. If a form numerous, but the data type but have some comparability, then we can first use the mouse to select the data area, Then click on the? Of course, if you want to view the details, then click the form on the left of the menu the flow of the process, you can select the Right-click the icon to bring up
This is an eye-catching in Excel 2002's new features. It is to let the Office software not only can write, count, but also to see, said. Although there have been many software dedicated to the machine reading the text, but Microsoft Office, whether from the softness of voice and tone of the cadence are other similar software match. in accordance with the Office of the default installation, you may not find it in Excel's menu, we confirm the installation of the bar on the Then read this and other software that is completely different, I think this deal is more natural. Another point to note is that Excel 2002 if you want to adjust the reading speed of speech can be in the icon, and then in the because of its role turned out to be features is not easy, and we click on Excel drag the toolbar anywhere. If we want to form a part of the. Of course, and Note: this is not just photos! You can try to change the original by our br> XXXI between the two forms in the realization of multiple public data links and references
We may wonder why every time you open Excel, the software always opens a blank form by the three documents comprising group? If you are a professional accountant, statistician or expert familiar with this form, we will certainly understand that, due to the numerous computing projects, the data loss as to how complex the information, one is often a form * can not solve all the problems multiple forms of data links, an interactive multi-file data is pit one against ten of the holy grail. For example, we first make , to the box, using the data list on the right of the × cell window
Excel 2002 has greatly improved the old version of the clipboard functions are relatively weak, the maximum capacity of 24 projects to support (and Excel 2000 can only accommodate 12). Moreover, the Clipboard can at any Office copy back and forth between applications, so often need to copy and paste for the users, really more convenient. but every time you use two consecutive, and you compete for limited document display space , is disgusting. Fortunately, the the Office Clipboard icon
沈阳回应毒芽菜“不归我管”事件 由农委牵头处置
Linear Mode
