accidentally deleted data resumption
accidentally, delete the wrong, and also blank the Recycle Bin, the supposed ah?
by the time 3 steps, you can delete and empty the Recycle Bin back your stuff
steps:
1, click the Enter regedit (open registry)
2, expand: HEKEY--LOCAL--MACHIME/SOFTWARE/microsoft/WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE outdoor the left margin click on
, select: Recycle Bin .
Perhaps you have had hundreds of Excel to complete the fiscal expressions, perhaps you have used Excel functions for complicated operations a thousand times, perhaps you think that Excel also many, or even naught new. However, we repeated innumerable times journal 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 peep on the Excel Different customs.
one, so that different types of data using different colors
in the payroll, if you want more than equal to the total wages of 2,000 yuan to greater than or equal to the total 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. setup is complete, press the
see it payroll, payroll data is not according to your apply that come in different colors.
Second, a category drop-down list filled with items
name of the business we often want to enter into the table, the name in order to retain consistency, the use of
1. in Sheet2 in the name of the affair along classification (such as
2. Select A column (
modeled on the above action,
GHD Deluxe Midnight 2011, the B, C ... ... column named such as the C column), the implementation of In the Enterprise
need apt enter the undertaking appoint and then choose the column (eg column D), and then open the C1), OK apt exit.
4. Select whichever 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,
GHD Diamond Flag 2011, select the name of the enterprise need to fill the cell.
Tip: When typography a report in the future, if you do not need to print the
Third, 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 operations, multi-document list to add a few names.
3. Select the distribution Hyperlink By urgent 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
four, making
1. the implementation of the Select the .
modeled on the above operation, one by one to disc a special sign of the input of other good
2. Open the A work area in the toolbar.
switch to the How many buttons).
3. Select 1 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) apparent 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 , promulgating what, on the toolbar click the
six, so that data on claim if you want to arrange
ministries where workers are sorted according to these sectors is not the name of the pertinent information by either the Pinyin order, not by stroke order, how do? can be self- defined series order.
1. execute The group, 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 entirely hidden portion of the contents of the cell do not want to enabling guests to way,
GHD IV Black Straighteners, had it hidden.
1. selected to conceal 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 granted to clear the sky.
Tip:
eight, so in English and Chinese input usage seemed
intelligent editing table, some cells to enter the English, 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, 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, picked 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, nevertheless the rich
Excel function, merely it does not encounter always our needs. We can customize a feature to perform certain operations. Here, we define a reckoned from the trapezoid district function:
1. The implementation of the
2. In the skylight, 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 backdrop sheet is lining in the entire worksheet below, can not only lined the first in the table below it?
1. execute → Background Worksheet
2. meantime 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 under, and the selected cell (area) not lining the picture beneath (in fact, is the picture to be
Tip? lining the image beabsent from the cell does not support typography.
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, achievement of the combination work.
Tip: Complete the steps from 1,2 combined effect has been achieved, but by this time if you delete B, C, D array, the formula misdeed. And accordingly ought be carried out step 3, the formula is converted to the same Performance of Students
article
friends often query, For this consideration, I give here a simple method used to accomplish the function.
stored in student accomplishment is presumed here Sheet1 worksheet range of cells A1 to G64, which deed 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 retinue simple modified look.
3. adjust the row altitude and column length, 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 fitting function. Excel box input requirements (such as related assist 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 needful 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 editions of Excel 2002 for the operation of a range of cells is also much difficulty to add a border, Excel 2002 which traits a new development.
Click the drag button, pop-up in the subsequent drop-down catalogue, choose drop-down clasp, select a border neatness, and then in the range of cells you need to increase drag and drip the frame, you can rapidly draw the corresponding range of cells on the border.
Tip: ① If you draw the erroneous frame, does not matter, on the toolbar select Color >
XVII Enter the text in specific cells controlling the length of
Can you imagine when you enter the 4 digits of the cell was filled with a number, or entering text in the cell number you have entered time, Excel will automatically determine, immediate analysis and pop-up advising, then be fine ah! To achieve this function, the Excel, is also not tough.
example, we register the cursor to a the cell in order to enter the measurement of the unified and effortless, we wish that the Card warning annual. style time distance,
We know thateach time you open Excel, the software is all cornered on by default multiple sheets. Thus we can see that Excel has a muscular increase to the processing power of single forms, more appropriate for multiple interrelated coordination table . to coordinate the coalition, of way, 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 do you edit a group of tables? First We click the first worksheet tab name ). At this point, we see the name of the title bar of Excel, a What,
GHD Hair Straightener, we found that change the format of how to do? First, we must change the data format of the first table, and then click the time, Excel will popup up IX, alteration the text in the case of
in Excel because manner processing and data computing support is not the maximum powerful formula, nor is the database, but function. Do not consider namely Excel, the function only as numbers, in fact, at the peak of written into the contents of the chart, 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), case, such as getting the first letter of every word is capitalized. For example,
GHD Hair Straightener NZ, we have a form of cell A1 enter the lowercase the outcome the car will be will be the method save trouble, particularly fjust aboutme of the information principally similar style, such as staff lists, place of origin and other information.
quickly if we want to extract the cells from A4 caption, it is best to use to extract the number of characters) grid, the number of characters extracted) words, only in the target cell to enter and 5 words.
the twenty-first, into the base ordinal number words to English words into ordinal bottom is a more complex problem. because it is not a very nailed pattern: Most of the figures into ordinal number is used in the Moreover, function, just jot a formula that can be easily converted. do not deem, see: IF (OR (VALUE (RIGHT (A2)) = 1,2,3,, CHOOSE (RIGHT (A2), Despite the long list, but the meaning is very clear: ① If the number is to bishop and ordinal conversion words so easy and fast implementation.
XXII, filled with special symbols and financial dealings with the centre
people know, when filling in the writing there is a accustomed Safety Fill Law The basic format is the formula to should be changed to REPT (pate paired with # # 0.00 worksheet created by the histogram composed of plain text. It is also very simple principle, is the intelligent use of special symbols continual according to a specified cell showing the results of the relative effectiveness of another widths.
example,
GHD Green Straighteners, we first Annual creation of a equilibrium sheet, and then The results have been ROUND (D3 * 100,0 )),> round to calculate the absolute digit of words in the 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, in addition to using the SUBSTITUTE > is to use Finally, the number of spaces +1 to draw the number of characters in the cell was.
XXV, the euro transition
This is a current tool in Excel 2002. If you choose to install the Excel 2002 is the default, then it may not be in the . with the Excel window, the other functions, we can set the money conversion mouse parity EU list of other currencies. Of course, in order to exhibit the euro is more vocational, we can also click on the Excel toolbar, the p>
to redo the computer system, study their own, can cost 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, and press the Enter key to enter setup. Select First Boot Device option, then press the keyboard Page Up or Page Down key to set the CD-ROM, so you can start the system to the disc.
Second, the return to the main menu, save the BIOS settings. (Preservation method is to press F10, then press Y button)
1. Prepared to simplified Chinese version of Windows XP Professional installation CD, and check the drive is supported from the start.
2. possible, before running the installer with all the hard disk to scan the hard disk error checking and repair, or install the program is running, such as checking that there is an error that will be hard very troublesome.
3. file with the periodical records the production key to install (installation serial number).
4. feasible, with the driver export tool (such as: Driver Genius 2004 V1.9 Beta.exe) all under the original Windows XP driver backup to disk ( such as: F: Drive). Best to note the motherboard, network card, movie card type and other important hardware manufacturers, pre-download the driver for use.
5. If you absence to format the C drive during the installation or the D drive (recommended format the C drive during installation), back up the C drive or D drive useful data.
Second, start the system with a CD-ROM:
(if you already understand the way, go to the next tread), reboot the system and the CD-ROM set First boot disk, save the settings and reboot. The XP installation CD into the steer, restart the microcomputer. Just started, as shown while there namely press the Enter key when the quick, otherwise the system can not boot XP CD. If you do not know the characteristic practices, please refer to the same with this -> how to obtain into pure DOS system:
CD-ROM from the start, if no event to see the installation screen will appear as shown in Figure 1
;
View Original
prompted all Chinese, View original
copyright accession, there is not choice, according to partition, format the C drive if you have select the C partition, select a agreeable partition and press format, which convert the file system format, or save one existing file system, a diversity of alternative, but memorandum that the NTFS format to save disk space, enhance security and reduce disk fragmentation but there are many problems and MacOS 98/Me can not see the NTFS partition, here, choose Figure
formatted C drive warning, press F key will be prepared to format the c drive, there is shown in Figure 6 under the original
outlook of the selected partition C space than 2048M ( or 2G), FAT document system does not advocate more than 2048M of the disk partition, so the installer will use the FAT32 file system format to format C drive, reception the br> View original image in Figure 7 is formatted C partition; merely start with the CD or install XP Setup boot floppy disks to provide during the installation process format the partition option; If you use MS-DOS boot disk into DOS, sprint i386 winnt to install XP, install the XP partition without formatting options. Format C partition is completed, there is shown in Figure 8 below the native
look Figure 8 to start copying file, copy the file after the installation program begins to initialize Windows configuration. and then the system will automatically restart in 15 seconds. restarts, there is shown in Figure 9 under the original
View 9
View Original
than 5 minutes later, when the prompt appears when needed 33 minutes following diagram 10
View Original
regional and language settings to use the default worth can be a straight point of the Next step this password, Administrator System Administrator has the highest authorization in the system, usually landing system does not require the account. Then click , choose Beijing, click Original
allows you to choose the manner used by the network installation, select a typical set point
View Original
persist the installation, here after do not you participate in, the installation program will automatically complete the entire process. automatically restart after the installation is complete, the splash screen appears, as Figure 19
View Original
first start takes a long time, please be patient, emulated by the salute shade, set the system hint, as shown 20
View Original
press the base right turn of the
View Original
here to create a broadband dial-up connection, not dial-up connection on the desktop shortcut, and dial-up connection the default name Wizard to create a broadband dial-up connection, dial-up connection on the desktop shortcut, and the default dial-up connection named button.
here I premier create a broadband connection, select the first
View Original
Telecom or China Unicom are currently using (ADSL) Residential consumers have accounts and passwords, so I chose , as shown in Figure 23
View Original
Telecom or China Unicom to provide input account and password in the The name of the list, and if left empty the system will automatically create a file phoned the dial-up connection, Microsoft surely want you to stimulate XP you, but even now there does not activate the 30-day trial duration, why the hurry? prefer Figure 25 shows
View Original
you normally enter a user name to login the computer, click the Next button appears as shown below 26
View Original
Click Finish to complete the installation. the system will log off and log a new user. landing desktop as below 27
View Original
six, and find common icons
; aboard the desktop start -> interlock to -> broadband linkage, as shown 32
View original
left point Office on the desktop can be seen more than a the open display the bottom left of the plot click on the My Network Places
Computer perception namely complete ( premier rete
Linear Mode
