Excel35 recruit {have to} {study} Cheats

Perhaps you have had hundreds of Excel to complete the fiscal expressions, perhaps you have been using Excel functions to achieve thousands of complex measurements, but perhaps you think that Excel is so, even nought new. However, we repeated countless times journal in nearby to use Excel only one percentage of all skills. From Excel, the topic of some little-known tips to begin a junket on the Excel Different customs.
one, so that different types of data using different colors
in payroll, whether you want more than equal to the total wages of 2,GHD Hair,000 yuan to greater than or equal to total wages of 1,500 yuan,
1. open the Click the second drop-down carton on the right clasp, choose the Click the
2. Click the
3. After setting, press the
see it payroll, payroll data is not according to your apply to display a different color.

Second, a category drop-down list items
we often want to fill the company name into the table, the name in order to maintain consistency, use of
1. on Sheet2 in the name of the affair by species (such as
2. Select A column (
follow the above operation, the B, C ... ... column named If column C), the implementation of In the undertaking
then selected to enter the enterprise name column (eg column D), then open the C1), OK to exit.
4. Select any cell in column C (eg, C4), right-click the drop-down button, select the proper Then select the corresponding cell in column D cell (eg D4), click the drop-down button to the proper category business name from the list, select the lusted company name enter the cell.
Tip: When typography a report in the hereafter, if you do not need to publish
Third, create a
1. the space in the toolbar, right-click, choose In the
Click
2. and then in the (mutual document), and follow the on operation it a appoint (such for
repeat the above operation, the document list to add a few more names.
3. Select the distribution Hyperlink By urgent the
repeat the above operation, the list item and its corresponding workbook hyperlink documents together.
4. After the need to open the
Tip: Although we will
Fourth, the production of
1. execute Select .
follow the above operation, one by one to record other special symbols of good input
2. open the A work area in the toolbar.
switch to the How many buttons).
3. Select an of the
4. named afterward right-clicking a button pops up the shortcut menu, select exit.
Repeat this tread, the macro buttons and the corresponding correlate.
5. close the
five, with
1. Open the need to print the worksheet, use the mouse in the need to print the row (or column) marked drag, select them and then right click on the shortcut menu that appears, select will need to print the row (or column) hidden.
2. implement the
3. the secluded rows (alternatively columns) are displayed, and reiterate the operation,
4. After the need to print a form, open the , promulgating what, press the toolbar's
six, so that data on claim
If you want to sort according to department where employees arrange the names both of these departments are not in alphabetical mandate of the information, nor is it by stroke order, how do? can be self- define the sequence order.
1. appliance the the crew, a workshop, 2 workshops, three workshops,
2. Select the one of the drop-down button, select the just-defined series, according to two

7, the data sheet completely hidden
some cell contents do not ambition guests to access, had it hidden.
1. selected to hide the contents of the cell (area), the implementation of the
2. and then alternate to the
3. execute
After this setting later, the cell contents are no longer shown, is to use Excel's functions can not be granted to borrow transparent.
Tip:
eight, so namely in the English input method appeared
smart editing table, some cells to enter the English, and some cells to enter the Chinese, it is inconvenient to again switch the input method, why not set and let the input method intelligently adjust it?
selected range of cells need to enter the Chinese, the implementation of tab, reception the
later picked to enter the Chinese in the range of cells in anybody one cell, the Chinese input method (IME list of the first Chinese input method) automatically open,GHD Hair NZ, elected in the other cell, Chinese input method automatically Close.
nine, so that
1. execute
2. In the then press
3. If you need to enter the text later, just enter
ten, a custom function in Excel, however the rich
Excel functions, but it does not meet all our needs. We can customize a function to act decisive operations. Here, we define a calculation from the area of ​​trapezoid function:
1. Execute
2. In the window, execute the
3. the right of the defined function to complete.
can later use the built-in functions favor the same using a custom function.
Tip: Use the above method to customize the function is normally only secondhand in the corresponding workbook.
XI header following pictures
lining to multiplication a backdrop for the worksheet, the worksheet is the lining in the following, can not merely lined in the table header below it?
1. execute Worksheet → Background
2. prop down the Ctrl key meantime using the mouse in the picture without lining cells (area) in drag, and select those cells (area).
3. Click After this setting after, leaving the cell lining on the picture below, and the selected cell (area) below not contrast pictures (in fact, is the picture to be
Tip? lining cells in the picture below does not support printing.
XII with a hyphen get it (here assumed that the B,GHD MK4 Pink Straighteners, C, D columns into one column).
1. in the D column, insert two empty columns (E, F column), then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select column E, the implementation of , press the
4. the B, C, D, E column canceled to complete the merger work.
Tip: Complete Steps 1 and 2 operation, the combined achieve has been achieved, but at this time if you delete B, C, D line, the formula error. Therefore, to carry out step 3, the formula is converted to the same

student achievement of
friends often ask, For this attention,GHD Leopard Grain Straighteners, I use the function here gives a simple direction to effect. This assumes that student finishing
stored in Sheet1 worksheet range of cells A1 to G64, which deed heading 1,GHD Blue Styler Straighteners, 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. anew select cell A1 , with the > So distant, the results of the basic shape, the following easy modification see.
3. accommodate the row elevation and column width, the same selected scope of compartments A1 apt G2 (the 1st rendition of a student's place), according apt The emulating operation).
4. likewise selected range of cells A1 to G3, click on the To add a siteline always the results of.
press the What function is more appropriate. Excel's Please enter requirements (such as related assist file, you can quickly determine the desired function.
fifth, while outlooking a different worksheet among multiple cells of data
Sometimes we amend a worksheet (Sheet1), the need View other worksheet (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, add a border for the operation of a range of cells is also many distress, Excel 2002 which features a new expansion.
Click the pull button, then the pop-up drop-down list, choose drop-down button, select a border style, then you need to add a border range of cells in shuffle, you can rapidly paint the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame, does not stuff, Select the toolbar's Color to control specific cell type text length
Can you assume while you enter the 4 digits of the cell was filled with a digit, or enter text in the cell number you have entered time, Excel will automatically make sure, instant analysis and pop-up warning that pleasing ah! To achieve this function, for Excel, it is not laborious.
instance, we enrol the cursor to a error advising few years. We kas long aseach time frame
open Excel, the software is forever turned on by default multiple sheets. In addition to this we can penetrate that Excel has a strong unattached form of processing power, more appropriate for multiple interrelated tables coordination work to coordinate the union, of course, first you need to synchronize the input, so in many cases, will need more than one table simultaneously in the same cell type the same content.
then how to form the group-edit it? First, we click the first worksheet tab name election). At this point, we see the name of the Excel title bar to a someone, we ascertain that change the format of the uniform how to do it? First, we must change the data format of the first table, and then click the At this time, Excel will pop up, ninth, to change text case in Excel
for form processing and data computing advocate to invest the most powerful formula is not, nor is the database, but the function do not consider the function in Excel only for numbers, in fact, as long as comprised in the contents of the table, Excel has its special editing functions such as changing the text of the case.
in Excel 2002, provide at least three functions to convert the text of the case and they are: = UPPER (source data grid), case, as to the first letter of every word to uppercase, etc. For example, in a form of cell A1 enter the lowercase Enter the results got will be will be and more handy approximate, especially fall butme of the alike style is principally true of message, such as hireling lists, place of origin and other information.
quickly if we want to extract the cells from A4 title,GHD Purple Styler Straighteners, it is best to use grid, the number of characters to extract) data grid, the number of characters to extract) words, you only need to enter the target cell 4 and 5 of the word.

twenty-first, to convert the ordinal pedestal word to the English words into ordinal base is a more complex problem because it does not have a very nailed pattern: Most of the diagrams into ordinal are using fancies, nail the function, just jot a formula that can be easily converted. do not trust, see: . Check the last digit to . kind of accustomed you only need to change the formula 16, it is needful to changed to cell mathematics of pate with that can be established instantly in the sheet formed from the pure txt of the histogram. Its rule is very simple, is to use special symbols natty Zhongfu, according to a specified cell results show the comparative effectiveness of different lengths.
For example, we first make one annual equilibrium sheet, and then the Then according to the results yet in the table clear.
XXIV calculate the total number of words in the cell
Sometimes, we may have a number of roles in a cell of interest, the cells absence to reckon the total digit of words To solve this problem, In appending to using the help:
The style is the averaging of first use Excel 2002, select the default, then it may not be in the skylight ambition arise with the additional functions of Excel window, we can set the money transition by the mouse the.