[Oufs Office Partner Mall] Computer office has been deeply rooted in the hearts of the people, but for many entry-level office friends, such as improving the efficiency of computer work is indeed a long-term accumulation of learning process, the following editors for everyone to share some office experts for office users Carefully organized 25 computer office skills, interested friends also come to learn. First, accidentally deleted data recovery I accidentally deleted the mistake and emptied the recycle bin. What should I do? In just three steps, you can retrieve what you deleted and emptyed the recycle bin. 1. Click "Start - Run, then enter regedit (open the registry) First, let different types of data be displayed in different colors In the salary list, if you want the total amount of wages greater than or equal to 2,000 yuan to be displayed in "red", the total amount of wages greater than or equal to 1,500 yuan is shown in "blue", and the total amount of wages below 1,000 yuan is shown in "brown". "Black" shows that we can set this up. 1. Open the “Payroll Table†workbook, select the “Wage Total†column, and execute the “Format → Conditional Format†command to open the “Conditional Format†dialog box. Click the drop-down button to the right of the second box, select the "greater than or equal to" option, and enter the value "2000" in the box that follows. Click the Format button to open the Cell Format dialog box and set the Color of the Font to Red. Second, create a classification drop-down list fills We often want to enter the name of the enterprise into the form. In order to maintain the consistency of the name, we use the "data validity" function to build a category drop-down list fill. Third, the establishment of a "common document" new menu Create a new "Common Documents" menu on the menu bar, and add common workbook documents to it, so you can call them at any time. 1. Right-click in the empty space of the toolbar and select the "Custom" option to open the "Customize" dialog box. In the "Commands" tab, select the "New Menu" item under "Category", and then drag the "New Menu" under "Command" to the menu bar. Press the "Change Selection" button and enter a name (such as "Common Documents") in the "Name" box of the pop-up menu. 2. Select one of the following categories (such as the "Insert" option), and select one of the "Commands" on the right (such as the "Hyperlink" option), drag it to the new menu (common documents) And name it according to the above operation (such as "payroll", etc.), and create the first workbook document list name. Repeat the above operation to add a few more document list names. 3. Select a menu item in the “Common Documents†menu (such as “Payroll Tableâ€, etc.), right click the mouse, in the pop-up shortcut menu, select the “Assign Hyperlink → Open†option to open the “Assign Hyperlink†dialog. frame. Locate the appropriate workbook (such as "Wage.xls", etc.) by pressing the drop-down button to the right of "Look in" and select the workbook document. Repeat the above to hyperlink the menu item to its corresponding workbook document. 4. When you need to open a workbook document in the "Common Documents" menu in the future, just expand the "Common Documents" menu and click the corresponding option. Fourth, the "professional symbols" toolbar When editing a professional form, it is often necessary to enter some special professional symbols. For the convenience of input, we can make a "professional symbol" toolbar of our own. 1. Execute the "Tools → Macro → Record New Macro" command, open the "Record New Macro" dialog box, enter the macro name such as "fuhao1"? and save the macro in the "Personal Macro Workbook", then "OK" to start recording . Complete the recording of the macro by selecting the Relative Reference button on the Record Macro toolbar, entering the desired special symbol into a cell, and clicking the Stop button on the Record Macro toolbar. 2. Open the "Customize" dialog box, in the "Toolbar" tab, click the "New" button, the "New Toolbar" dialog box will pop up, enter the name - "Professional Symbol", after confirming, that is, in the work area A toolbar appears in the middle. 3. Select one of the "custom buttons" and name them according to point 1 of the second cheat. 4. Right-click a named button, and in the shortcut menu that pops up, select the “Specify Macro†option, open the “Specify Macro†dialog box, select the corresponding macro (such as fuhao1, etc.), and confirm the exit. 5. Close the "Customize" dialog box, and later use the "Professional Symbols" toolbar to quickly enter professional symbols into the cells, just like using the normal toolbar. 5. Use the “View Manager†to save multiple work pages of printed pages. You often need to print different areas, use “View Managerâ€. 1. Open the worksheet that needs to be printed, use the mouse to drag on the lines (or columns) that do not need to be printed, select them and right click the mouse. In the shortcut menu that appears, select the “Hide†option and you will not need to print. The rows (or columns) are hidden. 2. Execute the "View → View Manager" command, open the "View Manager" dialog box, click the "Add" button, the "Add View" dialog box will pop up, enter a name (such as "Up Report") , click the "OK" button. 3. Display the hidden lines (or columns) and repeat the above steps to "add" other print views. 4. When you need to print a certain form in the future, open the “View Managerâ€, select the name of the form you want to print, click the “Show†button, and the worksheet will be displayed immediately according to the preset interface. Simply set up and typeset. Press the "Print" button on the toolbar and everything will be OK. Sixth, let the data sorted as needed If you want to sort employees by their department, the information about these department names is not in pinyin order or in stroke order. What should you do? You can use a custom sequence to sort. 1. Execute the "Format → Options" command, open the "Options" dialog box, enter the "Custom Sequence" tab, enter the sequence of department sorting in the box below the "Input Sequence" (eg "Organization, Fleet, Workshop" , two workshops, three workshops, etc., click the "Add" and "OK" buttons to exit. 2. Select any cell in the "Department" column, execute the "Data → Sort" command, open the "Sort" dialog box, click the "Options" button, pop-up "Sort Options" dialog box, press the drop-down button, select Just customize the sequence, press the "OK" button twice to return, all data is sorted as required. Seven, completely hide the data The contents of the worksheet section of the cell do not want to be viewed by the viewer, so I have to hide it. 1. Select the cell (area) where you want to hide the content, execute the "Format → Cell" command, open the "Cell Format" dialog box, select the "Customize" option under "Classification" in the "Number" tab, and then Enter ";;;" (the semicolon in three English states) in the box below "Type" on the right. 2. Switch to the "Protect" tab, select the "Hide" option, and press the "OK" button to exit. 3. Execute the "Tools → Protection → Protect Worksheet" command, open the "Protect Worksheet" dialog box, set the password, and then "OK" to return. After such a setting, the contents of the above cells are no longer displayed, and the use of Excel's transparent function does not allow it to appear. Special note: Under the "Protection" tab, please do not clear the "∨" in the check box in front of "Lock", this will prevent others from deleting the data you have hidden. Eight, let the Chinese and English input methods appear intelligently When editing a table, some cells must be entered in English. In some cells, you need to input Chinese. It is inconvenient to switch the input method repeatedly. Why not set it up so that the input method can be intelligently adjusted? Select the unit that needs to input Chinese. In the grid area, execute the “Data→Validity†command, open the “Data Validity†dialog box, switch to the “Input Method Mode†tab, press the drop-down button to the right of “Modeâ€, select the “Open†option, and then “OK†"drop out. In the future, when any cell in the cell area where Chinese needs to be input is selected, the Chinese input method (the first Chinese input method in the input method list) is automatically turned on. When other cells are selected, the Chinese input method is automatically turned off. Nine, let "automatic correction" enter a unified text Are you often worried about entering some fixed text, such as "Computer State"? Then look down. 1. Execute the "Tools → AutoCorrect" command to open the "AutoCorrect" dialog. Ten, custom functions in Excel Although the Excel function is rich, it does not meet all our needs. We can customize a function to perform some specific operations. Below, we come from defining a function that calculates the trapezoidal area: 1. Execute the "Tools → Macro → Visual Basic Editor" menu command (or press the "Alt + F11" shortcut) to open the Visual Basic Edit window. 4. Close the window and the custom function is complete. You can use custom functions like you would with built-in functions later. XI, under the head of the picture The background added to the worksheet is lining the entire worksheet. Can it be lined under the head? 12. Combine text with the hyphen "&" If we want to merge the contents of multiple columns into one column, we don't need to use the function, a small hyphen "&" can get it (here assuming B) , columns C and D are merged into one column). Source: Internet Kaiping Yufa Sanitary Ware Co., ltd, a professional of manufacturing shower heads for more than 20 years. Yufa offers shower heads for every style and budge. For example, fixed shower heads, rainfall shower head, handheld shower heads, dual-function shower heads, save water and save energy to heat it. Regarding the finish, Yufa offers brushed nickel, black, chrome, bronze, gold, brass, etc. These shower heads deliver a steady flow of water, from gentle to high-pressure, with the special design, with innovative operating and jet technology. Come to us, you can get the best valued, best durable shower heads. Shower Head,shower nozzle,rain shower head,shower spray nozzle Kaiping Yufa Sanitary Ware Co.,ltd , https://www.yufabathroom.com
step:
2, in turn: HEKEY - LOCAL - MACHIME / SOFTWARE / microsoft / WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE Click "New" outside the left margin, select: "primary key", name it "645FFO40 - 5081 ——101B——9F08——00AA002F954E†Set the key value of the “default†primary key on the right to “Recycle Bin†and exit the registry. It’s OK.
3. Restart your computer.
As long as the machine has not run through the defragmentation. The system is in good condition. Anytime the files can be retrieved. Maybe you have already done hundreds of financial statements in Excel. Maybe you have used Excel functions to implement thousands of complex operations. Maybe you think Excel is just like this, even if it is not new. But the handy use of our repeated repetitions on weekdays is only one percent of all Excel skills. This topic starts with some little-known skills in Excel and gives you a taste of Excel.
2. Press the "Add" button and set the other conditions according to the above operation (more than or equal to 1500, the font is set to "blue"; less than 1000, the font is set to "brown").
3. When the setup is complete, press the "OK" button.
Look at the payroll, and the data on the total salary is displayed in different colors according to your requirements.
1. In Sheet2, enter the enterprise name into different columns by category (such as “industrial enterpriseâ€, “commercial enterpriseâ€, “individual enterpriseâ€, etc.) to establish a database of enterprise names.
2. Select column A (the column of "Industrial Enterprise" name), in the "Name" column, enter the "Industrial Enterprise" character and press the "Enter" button to confirm. Following the above operation, the columns B, C... are named "commercial enterprises" and "individual enterprises"...
3. Switch to Sheet1, select the column (such as column C) that needs to enter the "enterprise category", execute the "Data → Validity" command, and open the "Data Validity" dialog box. In the "Settings" tab, click the drop-down button to the right of "Allow", select the "Sequence" option, in the "Source" box below, enter "Industrial Enterprise", "Commercial Enterprise", "Individual Enterprise"... ... sequence (separated by commas between elements), OK to exit.
Then select the column that needs to enter the enterprise name (such as column D), and then open the "Data Validity" dialog box. After selecting the "Sequence" option, enter the formula: =INDIRECT(C1) in the "Source" box to confirm the exit.
4. Select any cell in column C (such as C4), click the drop-down button on the right, and select the corresponding "enterprise category" to fill in the cell. Then select the cell of column D corresponding to the cell (such as D4), click the drop-down button, and you can fill in the cell by selecting the desired company name from the list of enterprise names in the corresponding category.
Tip: If you do not need to print the "Enterprise Category" column when printing the report later, you can select the column, right click the mouse, select the "Hide" option, and hide the column.
Tip: Although we dragged the Hyperlink option to the Common Documents menu, it does not affect the functionality of the Hyperlink menu item in the Insert menu and the Insert Hyperlink button on the Standard toolbar. .
Following the above operation, record the input "macro" of other special symbols one by one.
Switch to the "Commands" tab, select "Macros" under "Category", and drag the "Custom Buttons" item under "Commands" to the "Professional Symbols" column (how many special symbols are dragging the number of buttons) .
Repeat this step to link the button to the corresponding macro.
2. In the box under "Replace", enter "pcw" (may be other characters, "pcw" in lowercase), enter "Computer Newspaper" in the box under "Replace with", and then click "Add" and "OK" buttons.
3. If you need to enter the above text, just enter the "pcw" character? You can ignore the case of "pcw" at this time, and then confirm it.
2. In the window, execute the "Insert → Module" menu command to insert a new module - Module 1.
3. Enter the following code in the "Code Window" on the right:
Function V(a,b,h)V = h*(a+b)/2End Function
Tip: Functions that are customized with the above methods are usually only available in the corresponding workbook.
1. Execute the "Format → Worksheet → Background" command, open the "Worksheet Background" dialog box, select the image that needs to be the background, press the "Insert" button, and lining the image below the entire worksheet.
2. While holding down the Ctrl key, use the mouse to drag and drop cells (areas) that do not need to line the image, and select those cells (areas).
3. Press the drop-down button to the right of Fill Color on the Formatting toolbar, and in the subsequent Color Palette, check White. After such a setting, the remaining cells are lined with pictures, and the selected cells (areas) are not lined with images (in fact, the pictures are covered by "white").
Tip? The image underneath the cell is not supported for printing.
1. Insert two empty columns (columns E, F) after the D column, and enter the formula in the D1 cell: =B1&C1&D1.
2. Select the D1 cell again, copy the above formula to the cell below the D column with the "fill handle", and the contents of the B, C, and D columns are merged into the corresponding cell of the E column.
3. Select the E column, perform the "Copy" operation, then select the F column, execute the "Edit → Paste Special" command, open the "Paste Special" dialog box, select the "Value" option, and press the "OK" button. The contents of the E column (not the formula) are copied to the F column.
4. Delete the columns B, C, D, and E to complete the merge.
Hint: After completing the operations in steps 1 and 2, the merge effect has been achieved, but if you delete the B, C, and D columns, the formula will have an error. Therefore, step 3 must be performed to convert the formula to a constant "value".