First, the PPT method of transfer WORD form
1. Using the content, and then use
Tip: This method will mark the rows in the original slide, copy down all the symbols intact.
2. Using the Then select the
Tip: Convert WORD will find a lot of blank lines. Replace the function in use in WORD to delete all blank lines may be more than a few clicks, (Use Now open with WORD RTF file you just saved,ray ban sunglass, then the appropriate six, PDF transfer method
HTM HTM pages is a common format, but PDFTools convert HTM file, the formation of the HTM file does not contain PDF documents text, but the contents of a PDF document into JPG image file, then use the HTML language pictures embedded in Web pages. Generated HTM file is a frames page that links to the left of the page window on the right is the content of JPG pictures. If you're using IE6, so that when the mouse moves to the right window, it will leak out a row of shortcut toolbar.
first select the menu Then open the file with a variety of actions: the menu . Converted files are saved in the source file, but also the name of the corresponding sub-folder, which is the number of JPG pictures and other resources. Finally, a prompt window pops up, click
one, mistakenly deleted data recovery
accidentally, delete the wrong, also empty the Recycle Bin, supposed ah?
as long as three steps, you can delete and empty the Recycle Bin back your stuff
steps:
1, click Enter regedit (open registry)
2, expand: HEKEY--LOCAL--MACHIME/SOFTWARE/microsoft/WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE outside the left margin click on
, select: Recycle Bin .
Perhaps you have had hundreds of Excel to complete the financial statements, perhaps you have been using Excel functions to achieve thousands of complex calculations, but perhaps you think that Excel is the case, even the nothing new, but we repeated countless times daily in handy to use Excel is only one per cent of all the techniques in this topic from Excel, some of the little-known tips to start a trip on the Excel Different customs.
one, so that different types of data using different colors
in payroll, if you want more than equal to the total wages of 2,000 yuan to greater than or equal to total wages of 1,500 yuan, workbook, select the Press , press the 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 business by category (such as in column A (... column named , open the Enterprise C4), right-click the drop-down button, select the appropriate appropriate category business name list, select the desired company name enter the cell.
Tip: When printing a report in the future, if you do not need to print Select Among them, at any time convenient to call.
1. the space in the toolbar right-click, choose Document onto the new menu (common document), and follow the above operation it a name (such as list name.
3. select the , open the br> repeat the above operation, the menu item and its corresponding workbook hyperlink documents together.
4. After the need to open the menu, click one of the option can be.
Tip: Although we will and We can make one of their own and save the macro in the Click the
switch to the How many buttons).
3. Select one of the the shortcut menu, select link.
5. Close the Custom Views need to print the row (or column) marked drag, select them and then right click on the shortcut menu that appears, select br> 2. implement the ), click kind of form, open the not by stroke order, how do? sequence can be customized to sort.
1. implement the sequence in just a custom sequence, according to two seven, the data sheet completely hidden
some cell contents do not want visitors to access, had it hidden.
1. selected to hide the contents of the cell (area), the implementation of the Enter
3. execute Content is no longer displayed, is to use Excel's features can not be allowed to borrow transparent.
Tip: others delete your hidden data.
eight, so in English appeared
intelligent input method editing table, some cells to enter the English, and some cells to enter the Chinese, repeated switch the input method is inconvenient, why not set up a bit and let the input method to intelligently adjust it?
selected range of cells need to enter the Chinese, the implementation of , switch to any one cell, the Chinese input method (IME list of the 1st Chinese input method) automatically open, elected in the other cell, Chinese input method automatically shut down.
nine, so that text
you are not often enter some fixed text, such as Correction Computer News and then confirm it has become.
ten, a custom function in Excel, although the rich
Excel functions, but it does not meet all our needs, we can customize a function to perform certain operations. The following , we define a calculation from the area of trapezoid function:
1. execute br> 2. In the window, execute the a, b, h) V = h * (a + b) / 2End Function
4. Close the window, a custom function to complete.
can later be the same as using the built-in functions to use a custom function.
Tip: Use the above method to customize the functions usually only in the corresponding workbook used.
XI header following pictures
lining to add a background for the worksheet, the worksheet is the lining in the following can not only lined in the table header below it?
1. execute the button, the picture contrast on the worksheet below.
2. hold down the Ctrl key while using the mouse in the picture without lining cells (area) in drag, and select those cells (area).
3. Click cell lining on the picture below, and the selected cell (area) below no contrast pictures (in fact, is the picture to be does not support printing.
XII with a hyphen ;, enter the formula: = B1 & C1 & D1.
2. D1 cells again selected, use the be incorporated into the corresponding column E cells.
3. Select column E, the implementation of box, select one of the to complete the merger work.
Tip: Complete Steps 1 and 2 operation, the combined effect has been achieved, but at this time if you delete B, C, D line, the formula error. it must be step 3, the formula into the same
student achievement of
friends often ask, on such considerations, I am here gives a simple way to use the function to achieve.
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, (= 1, sheet1! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. again selected cell A1, use the .
So far, the results of the basic shape, the following simple modified look.
3. adjust the row height and column width, the same selected range of cells A1 to G2 (the first a student performance of the area), Click this step and following the operation).
4. also selected range of cells A1 to G3, click on the cell area, add all the results of the border.
press the do not know what function to use more appropriate. Excel's combined view of the help file, you can quickly determine the desired function.
fifth, while viewing a different worksheet within multiple cells of data
Sometimes we edit a worksheet (Sheet1) , the need to see other worksheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's monitoring point border
In previous versions of Excel 2002, add a border for the operation of a range of cells is too much trouble, Excel 2002 which features a new expansion.
Click the side of the drop-down button, then the pop-up drop-down list, choose the left drop-down button,christian louboutin red pumps, select a border style, then you need to add a range of cells in the border drag, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame , it does not matter, select the toolbar's the >
XVII control specific cell type text length
Can you imagine when you enter the four digits of the cell was filled with a digit, or enter text in the cell you have entered the number of times, Excel will automatically determine, instant analysis and pop-up warning that nice ah! To achieve this function, Excel, is also not difficult.
example, we position the cursor to a registration to the four-digit year. the right ah, Fixed cells
we know 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 single form of processing power, more suitable for multiple interrelated tables in coordination. to coordinate the association, 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 edit tables in groups ? First we click the first worksheet tab name the click). At this point, we see the name of the Excel title bar to a just write something, we find that change the format of the data uniform how to do it? First, we have to change the data format of the first table, and then click the . br> ninth,
change text case in Excel, for form processing and data computing support to provide the most powerful formula is not, nor is the database, but the function do not think the function in Excel only for numbers, in fact, As long as the content is written into 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 : appropriate The result will be The easy way to save time, especially for some of the similar style is especially true of information, such as employee lists, place of origin and other information.
quickly if we want to extract the cells from A4 title, it is best to use source data grid, the number of characters to extract) (source data grid, the number of characters to extract) 4 and 5 is the word.
twenty-first, to convert the ordinal base word to the English words into ordinal base is a more complex problem because it does not have a very fixed pattern: a large Most figures are used into ordinal end, and, , identify the function, just write a formula that can be easily converted. do not believe, see: th The formula despite the long list, but the meaning is very clear: ① If the number is Finally, a number Therefore, the base word and ordinal conversion was so easy and quick to achieve.
XXII, filled with a special symbol digit
and financial dealings of people know, the book fills in when there is a convention function and its basic format is only the formula to bit, it is necessary to as cell numbers head with $#,## 0.00 can be created directly in the worksheet in the histogram formed by the plain text it is also very simple principle, that is, the smart use of special symbols repeated according to the specified cell showing the results of the comparative effectiveness of different lengths.
For example, we first make an annual balance sheet, and then According to the results already in the table n .
XXIV calculate the total number of words in the cell
Sometimes, we may have a number of characters in a cell of interest, the cells need to calculate the total number of words To solve this problem, in addition to use the :
The meaning of style is to use number, and finally the number of spaces + 1, we arrive at the number of characters in the cell has.
XXV, the euro conversion
This is a new tool in Excel 2002 If you have Excel installed 2002 is the default mode when selected, then it may not be in the option, appeared with the other functions of Excel window, we can set the currency conversion by the mouse EU member states were converted into other currencies, a list of the parity of course, in order to display the euro is more professional, we can also click on the Excel toolbar, the .
to redo the computer system, they learn, can spend less money, ha ha [map]
one, ready to work:
how to reinstall the computer system
First, start the computer while holding down the DELETE key to enter BIOS, select Advanced BIOS Features option,Versace Sunglasses shop, press the Enter key to enter Setup Select First Boot Device option, then press the keyboard's Page Up or Page Down key to the Set CD-ROM, so that you can boot the system to CD.
Second, return to the main menu, save the BIOS settings (to save is to press F10, then press the Y key)
No comments:
Post a Comment