| Back to logs list
Reprinted from alumni of the user at 15:55 on January 30th, 2010 Read (loading. ..) Comments (0) Categories: Love Life
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:
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 tab, press 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 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 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 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, 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 image below in the cell does not support printing.
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
Performance of Students often
Article
friend asked, For this consideration, I give here a simple method used to achieve the function.
stored in student achievement is assumed here 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ū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. once again select the cell A1 , with the > At this point, the basic shape results section, the following simple modified look.
3. adjust the row height 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 add a border all the results section.
press the What more appropriate function. Excel box input requirements (such as related help files, you can quickly determine the required function.
fifth, while viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), it is necessary 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 previous versions of Excel 2002 for the operation of a range of cells is too much trouble to add a border, Excel 2002 which features a new development.
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 draw the wrong frame, 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 digit, or enter text in the cell Enter the number you have the time, Excel will automatically determine, instant analysis and pop-up warning, then be nice ah! To achieve this function, the Excel, is also not difficult.
example, we register the cursor to a Therefore, we can click the In the Then in the We then come to and
Obviously, when someone 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 continue recording. Amazing? In fact,
gucci bags, in Excel's , why not given a free hand, their design of a test standard, so you do Excel show distinctive luster.
eighth, 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. In addition to this we can see that Excel has a strong capacity leaflet form,
mulberry handbags, more suitable 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 group edit of tables? First we click the first worksheet tab name is not associated 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 pop up
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 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, provide at least three 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 direct input, from an existing cell to extract the contents of a specific character input, is absolutely a way to save time and save trouble, especially for some 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, it is best to use characters Of course, if you want to extract the name, then, will have to use the In another case, we do not start from the left and right ends, but directly extracted from the data center 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 number words to English words into ordinal base is a more complex problem. Because it does not a very fixed pattern: Most of the figures are used into ordinal st Moreover, Therefore, it seems very complicated to implement. In fact, as long as we sort out ideas,
mulberry handbag, find the function, just write a formula that can be easily converted. Do not believe, see: , 2,3,}, CHOOSE (RIGHT (A2), is
XXII, filled with special symbols and financial dealings with the median
people 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 repeatedly enter the histogram
outside, principle is very simple, it is the intelligent use of special symbols repeated, according to a specified cell showing the results of the comparative effectiveness of different lengths.
example, we first make an annual balance sheet, and then font also drag the fill handle to the G14. We see that a function does not use Excel charts 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 calculate the total number of words in the cell. To solve this problem,
designer handbags, in addition to using the function to remove spaces. For example cell A1 now enter a LEN (TRIM (A1))-LEN (SUBSTITUTE (TRIM (A1 ),
paul smith handbags,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 currency conversion display more professional, we can also click on the Excel toolbar,
tory burch bags, the
Office 2007 Key Novell makes ODF-OOXML translator
Linear Mode
