Skills in word and execl

1. How to use a duplicate number in Word

In word, we can place a duplicate number on the toolbar. Open the "tool-custom" Command Option and open the "Custom" dialog box. Select "All commands" in the "category" column under the "command" tab.
. All commands listed in ascending alphabetical order will appear in the "command" column on the right. We can find the "dotaccent" command on ABC, select the command, and press the left mouse button, drag it to the tool
To release the mouse. After you select the text to be highlighted in the word, click the "DUPLICATE" command.

2. Split Word tables into two quickly

Position the cursor in a separate table and press Ctrl + Shift + enter. At this time, you will find that an empty row is automatically inserted in the middle of the table, thus achieving the goal of dividing a table into two.

 

3. Use the Alt key in Word

Press the Alt key and drag the left and right (up and down) margins to make precise adjustments. The specific values are displayed on the ruler.

 

4. Use location to select a conditional Cell

Some fields in an Excel worksheet are often given the conditional format. If you modify them, you must first select them. However, in a worksheet, they are often not in a continuous position. Press and hold
Pressing CTRL to select columns one by one may be a little troublesome. In fact, we can use the positioning function to quickly find and select them. Click the "edit-locate" menu command. In the displayed "locate" dialog box, select
"Condition format" option. The "all" and "same" option below are optional. If "same" is selected, all cells with the same condition format will be selected.

 

5. quickly enter the same content in different cells

In an Excel table, select the cell area where the same content is to be entered, enter the content, and press Ctrl + enter to enter the same content at a time in the selected cell area.

 

6. Return to the last edit point quickly

When editing a document, if you want to quickly return the cursor back to the last editing point, press SHIFT + F5.

 

7. Multiple cell data coincidence and

After editing an Excel worksheet, if you need to merge the data in some cells, we can ask "&" for help, for example, to merge the data in columns A, B, and C into the data in column D, type the formula "= a2 & B2 & C2" in cell D2 ".

 

8. Use double-click to locate in Excel

When using Excel, when you want to locate the first row or the first column, point the cursor to the upper border of any cell, and double-click the left mouse button.

 

 

9. accurately move text by word

Select the text to be moved, and then press the "F2" key. The cursor turns gray automatically, and the input cursor is directed to the destination. Press the Enter key to move the text accurately.

 

10. "phase" vertical text block

To select a vertical block in a Word document, press ALT and drag the mouse over the text to be selected.

 

11. Avoid calculation errors in Excel

When using EXCEL to prepare financial reports, complicated operations are often required. The data results obtained by using the Excel Formula are inconsistent with those calculated by the calculator.
As a result, data is automatically rounded in. To solve the error problem more easily, we can perform the following operations: click "tool-Option-re-calculation" in the Excel menu bar in sequence ", set "work thin option"
Select the "display value" check box in, and click OK to exit.

You can also use the function, method: round (calculation formula), 2), where "round" is a rounding function, where "calculation formula" is used to enter your calculation formula, for example, A1 * A2, where "2" represents the number of decimal places after rounding. Here is two digits.

 

12. automatically sort word printing in order

When printing a file, click "file-print". In the displayed "print" window, click "option" in the lower left corner, and select "print in reverse order ", in this way, the first page is printed first, and then the last page is printed. In addition, you can set the odd/Even page printing to print the front and back of the paper in batches.

 

13. Quick text box drawing in Excel

The text box is usually used in Excel to annotate the table content. If you press and hold the Alt key and draw a text box, the text box and the cell edge can be overlapped, thus reducing the workload of adjusting the text box position.

 

14. Quick Change of English case

Select the letter or word to change the size, press shift and then press F3, each press F3, letters or words will switch between all uppercase, first and all lowercase letters.

Click "format/change case" to change the case sensitivity.

 

15. Make the window so fixed

When editing an Excel worksheet that is too long or too wide in Excel, You Need To scroll down or to the right of the screen, and the top line of the title or left line also scroll accordingly, cannot be displayed on the screen, we don't know what to do.
The edited data corresponds to the title information. You can select the title to be locked first. If we want to fix the first row at the top of the table and the first column on the left, click cell B2, click
"Split" command. After the split, click the "Freeze pane" command to fix the title.

 

16. Enter a ellipsis quickly

Enter "Shift + 6" in the five-stroke font state, and press "CTRL + ALT +." To enter the value in any input mode.

17. easily arrange cells and data in diagonal lines

Open "tool-custom-command-category-format" in Excel ", in the "command" list, drag the "Clockwise oblique" and "counterclockwise oblique" command buttons to the appropriate positions on the toolbar, select the cells to be oblique, and execute the command.

In addition, you can also select "format/cell/align/Direction" to rotate the red pointer or directly enter the degree.

 

18. Quickly remove the horizontal line of the header

After using word to insert a header, there will always be a horizontal line under the header information. If you want to remove it, you can open "format-border and shading ", in the displayed dialog box, set the border to "NONE" and change it to "section" under "Apply", and then click the "OK" button.

Another way is to select "body" in the "title" on the left of the font.

The last method is to select the "format/style" command, pop up the "style" dialog box, select "Header" in the "style" item, and then click "change. Click the "format" button and select the "border" command in the pop-up menu. The "border and shading" dialog box is displayed. On the "border" tab, select "NONE.

 

19. Make Different watermarks for the even page

First, run the "file-page settings" command to open the "page settings" dialog box, click the "layout" tab, and select the check box before "different parity pages, click OK to close the dialog box. Then
Then run the "View-header and footer" command. Enter the edit status of the header and footer, edit the watermark of the odd page in the edit area of an odd page, and edit the watermark of the even page in the edit area of an even page.

 

20. Quick drawing

In the drawing, if you want to use a tool button to draw multiple images, you just need to double-click the icon with the left mouse button.

 

21. Quickly remove hyperlinks

To cancel the underline Of a hyperlink, press Ctrl + Z or Alt + backspace to cancel the underline.

 

22. How to Avoid titles falling at the bottom of a page

Sometimes a title appears at the bottom of a page, and its body appears on a new page. You can move the cursor to the title so that the title can be placed together with its body.
In the section, select the "section" command in the "format" menu, and the section dialog box appears. In the section dialog box, click the "line feed and paging" tab, and select the "Same as the next section" check box, click OK and then press
Button.

In addition, to prevent the last line of text of a specific segment from appearing at the top of a page, or to show the first line of text of a specific segment at the bottom of a page, you can also see the first line of text in a segment at the bottom of a page. You just need to move the cursor to the segment and select the "lone row control" check box in the window, the system automatically moves a line of text to the next page.

 

 

23. How to change a page in the document to horizontal

To insert a wide table into a document during formatting, you need to change the paper to landscape. To ensure that the content before and after the table is still vertical, you can move the cursor to the table and select "Page
Area setting command, click the "paper size" tab, select the "horizontal" radio button in the "direction" area, and select the "after insertion point" option from the "apply to" drop-down list box, click OK.

 

24. How to vertically split a table into two tables

Select the column to be split, select the "border and shading" command in the "format" menu, right-click the "border and shading", and click the "border" label, in the preview area, click the top border, middle border, and bottom border to delete the border lines, retain the left and right borders, and click OK.

 

25. Use Word to expand the Selection Function

Position the cursor at the beginning of the part you want to select, and press "F8" to start "extension". Now you will see that the "extension" in the bottom status bar changes from Gray to black, click "F8" to select a word or
Press "F8" under "2", select a sentence, press "F8" under "3", and select a paragraph. Press "F8" under "4" to select all. Press ESC or F6 to disable the extension function.

 

26. Excel cells with more than 15 digits

Select the cell for which you want to enter a number, click the "cell" command in the "format" menu, and find the "Custom" command in the "Number" item, select the "@" option in the "type" box on the right, and enter "OK.

 

27. Conversion of pound and centimeter in Word

1 lb is about 0.03527 cm, and 1 cm is about 28.35.

 

28. Conversion of capacity units in the computer

1 GB = 1024 MB, 1 MB = 1024 KB; 1 kb = bytes.

 

29. Copy the previous cell in Excel

In an Excel cell, press Ctrl and then
'(Single quotes) to copy the content of the previous cell.

 

30. Clear spelling

When we use word, there are often a few words that appear below the individual words, sometimes it will affect the visual. To completely solve this problem, click "tools-Options" and select "spelling and Syntax" to cancel all the options. Click "OK.

 

31. Processing of blank pages after word tables

In word, if the last page of a document is a table that is filled with a full page, a blank page is generated. Although this page only contains one paragraph mark, it cannot be deleted.
. During printing, this page will still make the printer take a page of paper, which will cause unnecessary waste. The solution to this problem is actually very simple: place the cursor in the last segment, and then set the row spacing to "1"
(The minimum value allowed by word.

 

32. Change the image shape

To edit an image irregularly, open the drawing tool, select any custom image, right-click the image, and select "set custom image format ", in "fill color", click the drop-down list
Arrow, select "fill effect", select the "image" tab, and click "select image. Select any image you like in the hard disk folder, and click OK. The image shape is the custom image.
.

 

33. Edit the vertex of a line segment

You can edit the vertex for a graph generated by the line tool. Select the line, right-click the line, select "Edit vertex", right-click the area to be changed, and select "add vertex ",

Select this point, right-click and select "smooth vertex", and drag the mouse to the desired image. Click CTRL to delete the vertex.

 

34. Switch gridlines

In Excel, to remove the gridlines, find the "form" in the "tools-custom-commands" category ", find "Grid line switch" on the right (in Excel, "Switch grid"), drag it to the toolbar, close the dialog box, and click it to restore the grid line, click again.

 

35. Quickly change the line spacing in Word

Select the text section you want to change the line spacing. Press Ctrl + 1 to set this section to single-factor line spacing. Press Ctrl + 2 to set this section to double line spacing; press Ctrl + 3 to set the paragraph to 1.5 times the line spacing.

 

36. Quickly select a paragraph in Word

Place the cursor in the left blank area of a row in the section to be selected, click the left button once, select the row, click the left button twice, select the paragraph, and click the left button three times to select the full text.

 

37. Automatic line feed in Excel

Select "format-cell-alignment" in the menu bar, and then select the "Automatic line feed" check box under the "text control" title (tick ). If you want to segment text in a cell, press Alt + enter to enable the line break operation by pressing the hard carriage return key.

 

38. Tips on Chinese Character Input Methods

A person who uses a certain Chinese Character Input Method is expected to have this input method on the computer. To achieve this, you only need to open the "keyboard" in the "control panel", bring up the "language" page, and select the required Chinese Character Input Method in the "language" column, click "set to default" and "OK", and then restart the instance.

You can use the CTRL + Shift key combination to perform cyclic switching in English and all Chinese character input methods. In order to obtain the required Chinese character input method, we often need to press Ctrl + shift several times, which is very
Inconvenient. In fact, we can define frequently used Chinese character input methods as hotkeys. Just click it if necessary. For example, if you want to define "five input methods for King code 86" As ctrl + Shift + 8, you can
Open "Input Method" in "Control Panel", bring up the "hotkey" page, and find "switch to five Input Methods 86" in "project ", then select "Ctrl", "Left click", and "right" in "key combination ".
Key, select 8 in the "Basic Key", and then press "OK.

 

39. double-sided printing with Word2000 symmetric margin

In order to save printing paper, word dual-sided printing documents are often used, but it is difficult to align the front and back margins of printed documents. Countermeasure: first, select the "file/page settings/margins" option
Card, select the "symmetric margin" check box, clear the "page" check box, in the "Inside" and "outside" box, enter the symmetric margin value, for example, 3.17 cm. Then, insert the page number. Finally, print
The odd page prints the even page.

 

40. Play "transpose" in Excel"

For data in an Excel worksheet, you sometimes need to convert the original columns into rows and the original rows into columns. Method: select the cell to be operated, click "copy", then determine the target location for the "transpose" operation, and click "Edit/select Paste" in the menu ", select "transpose" and click "OK.

 

41. Easy sorting in Excel

When we need to sort the personnel data in an Excel worksheet by the size or title, click "Data/sort/option ", click "add" in "Custom sequence", and enter it in the sequence of Ta, Lecturer, Associate Professor, and Professor.

 

42. Duplicate table titles in Word

Sometimes the title of a table is very difficult, and many pages use the same title. in word, select the table row to be repeated, and then execute "Duplicate table/title row ", after each page of data is entered, the title line will automatically appear on the next page.

43. display table titles by page in Excel

In Excel, select "file/page settings/worksheet/Print Title/top title line" and enter the position of the top title line, for example: the first three rows are the titles of the table that need to be repeated on each page.
Enter $1: $3 or A1: A3. When previewing and printing, the title is displayed and printed on each page. If you need to print the row number and column label, you can select "row column label ".

 

45. Word Reading Tips to eliminate fatigue

Open the document to be read in the word. If it appears on the screen as if it is not very good for your eyes, select "tools/options/regular ", in "general options", select "blue-white" to eliminate eye fatigue. In addition, to facilitate reading, click "grid lines" in the "View" menu ", on the screen, there will be a horizontal line of paper.

 

46. Show the color of cells with formulas

Select "Edit/locate", open "positioning condition", select "formula", and press "OK" to exit. In this way, all cells with formulas are selected, select the background or font color on the toolbar.

 

 

47. The trailing points in the first column of the row follow

In Excel, when a cell becomes an active cell, it is surrounded by a rough box. Place the cursor over the top border and double-click the left mouse button. The active cell quickly locates the beginning of the row, similarly, the trailing points in the first column of the row follow.

48. delete a table at a time

When editing a table in word, select the part to be deleted and press the "delete" key to delete the text content. The table part still exists. Press the "backspace" key, delete all selected items, including cells, table rows, and the entire table.

 

49. Quick search of Word documents

In a document, when you need to find the document content, you often use the "Search" command in the "edit" menu. In fact, you can use another easier method: below the vertical scroll bar, there is a small dot button ("Select Browse object"
), Click to browse by object.

 

Automatic directory generation in 50 or several seconds

Set Title 2 to Title 3, open the "insert" menu, select "index and directory", and click the "directory" tab, tick "√" before "display page number" and "right-aligned page number ",
Select "tab prefix" as a vertex, "format" as the default "from template", "display level" as "2", and click "option, in the "DIRECTORY Options" window
After question 3, enter "1" and "2" respectively. Then, "√" appears in front of "title 2" and "Title 3". At the same time, delete the number following the title and press "OK" twice. The directory is generated!

51. Quickly input chemical equations in Word

A major feature of the chemical equation is that it contains a large number of Shift + @"

You can.

 

79. use special symbols to draw separation lines

Enter more than three consecutive "*", "=", and "~" , "_", "#", "-", And so on, different types of separation lines will appear. Try it!

 

 

80. Use "Alt + enter" to quickly re-import

When you use word to edit a document, you will often encounter text or picture content that you just entered and then enter it again. At this time, the copy method is feasible, but not fast enough. In fact, if you press "Alt + enter" at the same time, the entered content will be automatically re-entered, if you press it again, it will repeat again.

 

81. Easy text Rotation

In word, you can use the "text direction" command to change the direction of the text, but I found that if you want to rotate the text 90 degrees counter-clockwise, you can also use the following simple method. To select the text content, you only need to set the font to "@ font" or "@ "to rotate the text 90 degrees counter-clockwise.

 

82. Set the hybrid layout with the delimiter

There is a Word document. You only want to set a vertical line for one page of text, and the rest will be in the original format. If you select this part of text and then execute the "text direction" command under the "format" menu, the result is the entire document.
All are in the vertical bar. In this case, we can add a "subscriber" to achieve our goal. Move the cursor to the beginning of the text on this page, execute the "separator" command under the "insert" menu, and select "partition type" in the pop-up window"
Next "next page" or "continuous", insert a subscriber at the end of the page in the same way, and then select the text on this page (the subscriber at the end cannot be selected) to the vertical bar.

 

83. Insert consecutive blank rows in Excel

If you want to insert a few blank lines on a row, you can drag the line and select the corresponding number of lines, right-click and select insert, if a blank row is inserted on each row, press Ctrl, click the row icon to Insert a new row, right-click, and select insert.

 

84. Quick input of uppercase Chinese numbers in Excel

Move the cursor to the cell where an upper-case number is required. Use the keypad to enter lowercase numbers (such as 123.45) in cells ). Right-click the cell and click "set cell format ".
Select the "Numbers" tab, and then select the "Chinese uppercase numbers" option from the "category" list box. Click the "OK" button, and the 123.45 entered by the user will automatically change to "one click
Wu ".

 

85. Set the header and footer of multiple worksheets at the same time

Sometimes we need to set multiple worksheets in an Excel file to the same header and footer. It is very cumbersome to set one worksheet separately, if the following method is used, you can
Set both the header and footer. Specifically, move the mouse to the worksheet name, right-click the worksheet, select the "select all worksheets" menu item in the pop-up menu, and then set the header and footer
All worksheets.

 

86. Determine the score level and count the number of people in each score segment

In H5: h24, enter a number ranging from 50 to 100, click the I5 cell, and enter the formula = If (H5> = 85, "excellent", if (H5 <60, "fail ",
If (H5> = 70, "good", if (H5 <70, "pass") ", the nested function of the IF () function is used in this formula, the first layer of the IF () function will be greater than 85
The Student Score is defined as "excellent"; the second-level if () function defines the student score less than 60 as "fail"; the third-level if () in the function, a student with a score greater than or equal to 70 is defined as "good", but note that
It means that this is a nested function, which is defined earlier than 85. Therefore, this layer of function is defined as "good" for a value greater than or equal to 70 and less than 85. In the same way, the layer-4 If () function defines
Is the scope of pass.

Enter the "Exam count" text in cell c28, click cell d28, enter the formula "= count (D5: d24)", and press enter to count the exam count.

Select cell d28 and drag the fill handle to cell f28.

In cell i29, enter the formula "= countif (I5: I24," excellent ")" to calculate the scores of students with excellent overall evaluation. In cell C29, enter the formula "= countif (I5:
I24, "> = 85") "to count the number of students greater than 85. In cell D29, enter the formula" = countif (I5: I24, "> = 70 ")-
D29 ", this formula is to count the number of students greater than 70, minus the number of students greater than or equal to 85, so as to get the number of students with scores between 70 and 85.

 

87. quick access to frequently used documents

Recently used documents in Word appear in the "file" menu, but they are only saved in the last four, in fact, we can use "work" to customize documents that need to be opened frequently.

First, add the "work" menu to the menu bar or toolbar: click "Custom" in the "Tools" menu, and then click the "command" tab, in the "category" box, click "built-in menu", click "work" in the "command" box, and drag it to the menu bar or toolbar.

If you want to add the current document to the "work" menu, click the "work" menu and select the "add to work" menu, if you want to delete a document from the "work" menu, press CTRL + ALT +-(Break Key). In this case, the pointer becomes a bold underline. In the "work" menu, click the document you want to delete.

 

88. Create a neat word Formula

After using the formula editor of word to create a formula, if you feel that the formula is not neat (especially the formula in matrix form), you can fine-tune it in the following ways: double-click the formula to enter the editing form.
And then select the item to be adjusted. Press the ctrl key and use the cursor to move up, down, and left to fine-tune the item. Repeat the above steps until the formula is adjusted to a satisfactory position.

 

89. quickly and accurately adjust the table width

In a Word document, draw a table. To adjust the cell width, move the mouse to the cell gap and press the left button. When the two-way cursor appears, adjust the cell width, but sometimes it is always a little worse.
Points cannot be aligned with other cells. You can right-click them at the same time to easily adjust them accurately! (After you remember the correct position, you should loosen the left mouse button and then right-click it); of course, you can also press Alt + LEFT MOUSE
The key must be precisely adjusted, but the left mouse button should be removed first, and then the Alt key should be relaxed.

 

90. Change the text box shape

You can insert a custom image and right-click it and select "Add text". In this case, the custom image is like a text box. It can be connected to other text boxes.

 

91. prohibit the movement of images in word with paragraphs

Select the picture to be moved in the document, right-click it to open the shortcut menu, select the "set image format" command, and then click the "advanced" button on the "layout" tab, open the "Image Location" tab in the "advanced layout" dialog box. Remove the check box before the "object moving with text" option. Click OK.

 

92. Three useful EXCEL function applications

1) randomly orchestrate the exam number: when the school organizes the exam, it is often necessary to disrupt the order of student numbers (registration numbers), and randomly orchestrate the exam number, using the random function (RAND. Method: First input data in column B and column C.
Enter the formula "= rand ()" in cell D2 and fill it down. In this way, each cell in column D generates a value ranging from 0 ~ Random number between 1, and then place the cursor in D
Column, click the "sort in ascending order" button on the toolbar or the "sort in descending order" button, all of which will be randomly arranged. Finally, enter the first exam number in cell A2, and fill down by sequence, and then delete column D or data
Clear it.

2) Eliminate calculation errors

When using EXCEL to prepare a payroll for a school, enter the formula "= (C3 + D3) * 3%" in cell E3 and fill it down, the total result "125.04" in E7 is compared with the actual result.
"125.05" does not match. The reason is that the displayed value in the cell is inconsistent with the stored value. For example, the displayed value in the E4 cell is "32.06", while the actually stored value is
"32.55", the calculation uses the storage value instead of the display value, resulting in calculation error. To solve the problem above, you only need to use the rounding function (round) to change the formula in cells E3
"= Round (C3 + D3) * 3%, 2)" And fill it down.

3) ranking of test scores

When calculating students' scores, you generally need to rank the total score, as long as you use the rank function to enter the formula "= rank (F2, $ F $2: $ F $6, 0.

 

93. Accept the formula sign and simplify the formula Input

The common formulas are "C2 = a2 + B2" and so on. The average person cannot understand them immediately. Can he write the formula as "Total = salary + Capital "? Method: set the first row of the table to the field name, select "Accept formula sign" in "tools/options/recalculation", and enter the above formula.

 

94. Adjust the font size

There are several methods in word to change the size of the text at will. Gradually ZOOM: After selecting the text to be adjusted, press Ctrl +] to gradually zoom in the text, and press Ctrl + [to zoom out
Text; quick ZOOM: After selecting the text to be adjusted, press Ctrl + Shift +> to quickly zoom in the text, and press Ctrl + Shift + <to quickly zoom out the text
Character; arbitrary scaling: After selecting the text to be adjusted, enter the text size in the font size column.

 

95. Copy the Word Format again

You can use the format to copy text and paragraphs. However, when a paragraph is large, this method is not convenient. Another method is as follows: select the source paragraph, press Ctrl + Shift + C to copy the format, select the target section, and press Ctrl + Shift + V to paste the format.

 

96. Page number arrangement of large documents

When using word to create a comprehensive large document, you will often encounter page number arrangement problems. If a file contains a cover, a directory, or a body, how to make the cover have no page number, what are the independent page numbers of directories and texts?

Some people divide the file into several files, which can solve the problem, but it is not convenient to edit and manage. In fact, you only need to insert a segmentation character between the cover, directory and body before inserting the page number, the method is "insert/delimiter/next page". Different sections can have different page number la S.

Original article address