Office Tips 100 Strokes: Word and Excel

Source: Internet
Author: User
Tags sort split first row blank page wubi

1, Word How to use the emphasis number

In Word we can put the emphasis number on the toolbar. Open the Tools-Customize command option to open the Customize dialog box. Under the Commands tab, in the Categories column, select the All Commands option. At this point in the right "command" column will appear in alphabetical order all the commands, we find the ABC head has three points of the "dotaccent" command, select and press the left mouse button, drag it to the toolbar, release the mouse. When you select the text you want to highlight in Word, click on the "Accent Mark" command.

2, let the Word table in split quickly

Position the cursor at a separate table and press the "Ctrl+shift+enter" key combination. At this point you will find that a blank line is automatically inserted in the middle of the table, thus achieving the goal of splitting a table into one.

3, Word skillfully with the ALT key

Hold down the ALT key and drag the left and right margins to make an exact adjustment and display the specific values on the ruler.

4, skillfully use the positioning of the selection of conditions cell

There are often fields in Excel tables that are given conditional formatting. If you modify them, you first have to select them. However, in worksheets, they are often not in a contiguous position. Holding down the CTRL key to select Columns I'm afraid it's a bit of a hassle, actually, we can use the positioning function to quickly find and select them. The method is to click the Edit-position menu command, in the pop-up "positioning" dialog box, select the "Conditional format" single option, at this point, the bottom of the "all" and "the same" single option becomes optional. Select same to have all cells assigned the same conditional format selected.

5. Quickly enter the same content in different cells

Excel table, first select the range of cells you want to enter the same content, then enter the content, and then press CTRL + ENTER to achieve a one-time entry in the selected range of cells.

6, quickly return to the last edit point

When editing a document, if you want to achieve a quick return of the cursor to the last edit point, we can press the "SHIFT+F5" key combination.

7. Multiple cell data coincidence and

After you have edited an Excel worksheet, if you need to merge the data in some cells, then we can ask "&" to help, such as the need to merge data A, B, and C three into the data in column D, type the formula "=a2&b2&c2" in the D2 cell.

8, Excel in the use of double click positioning

When you are using Excel, when you want to navigate to the beginning or top of a column, point to the top border of any cell, and then double-click the left mouse button.

9. Word moves text exactly

Select the text you want to move, and then press the "F2" key, at which point the cursor will automatically turn gray, positioning the input cursor to the destination, and pressing ENTER to move the text exactly.

10, "phase" vertical text block

When we want to select a vertical block in a Word document, you can press the ALT key and then drag the mouse over the text you want to select.

11. Excel avoids calculation error

The use of Excel to make financial statements, often to carry out a number of complex operations, can often be derived from the Excel formula data results and calculator to calculate the inconsistency, this is mainly because Excel itself can not automatically into the data rounding caused, in order to more easily solve the error problem, We can do the following: Click "Tools-Options-Recalculate" in the Excel menu bar, select the "Show Value as" check box in the workbook options and make sure you exit.

You can also use a function, method: Round ((Formula), 2), where the "round" is a rounded function, where the "formula" in which you enter your calculation, such as A1*A2, where "2" is the number of digits that represent the decimal point after you rounded, here are two digits.

12, let Word print automatically arranged in order

When printing the file, click "File-print", in the pop-up "print" window to the lower left click the "Options" button, selected on the above "reverse page print", so that the first page, and then print the last page, there is no need to start paging. In addition, you can set up odd and even page printing, to achieve the paper on the reverse side of the batch printing.

13. Quickly draw text boxes in Excel

You usually use a text box in Excel to make table content comments, and if you hold down the ALT key and then draw the text box, you can overlap the text box to the edge of the cell, reducing the amount of work that adjusts the position of the text box.

14. Quickly change the English case

Select the letters or words you want to change, press SHIFT and press F3, and each time you press F3, the letters or words will switch between all caps, caps, and all lowercase characters.

Click Format/Change case to make a more complex case replacement.

15, let the window so fixed

When you edit an Excel worksheet that is too long or too wide in Excel, you need to scroll the screen down or to the right, and the top header row or left End header row scrolls, not on the screen, so that we don't know what to edit the data corresponds to the title, you can first select the title to lock, If we're going to fix the first row and the first column on the top of the table, click the B2 cell, click Split on the Window menu, and then click the Freeze Pane command to finish fixing the title.

16. Fast input ellipsis

Enter "Shift+6" in the Wubi font state, and press "ctrl+alt+." Key combinations can be entered in any input method state.

17, easy to handle cell data diagonal row

Open Tools-Custom-command-category-format in Excel, find the clockwise and counter-clockwise two command buttons in the Commands list, drag to the appropriate location in the toolbar, and then select the cells that you want to skew, and then execute the command.

Alternatively, you can choose Format/cell/alignment/orientation, rotate the red pointer, or enter a degree directly.

18, quickly remove the horizontal line of the header

After you use Word to insert a header, there is always a horizontal line under the header information, if you want to remove it, you can open formatting-borders and shading, set the border to none in the pop-up dialog box, change to paragraph under Apply to, and then click OK to An Shu.

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

The last option is to select the Format/Style command, pop the Style dialog box, select Header in the style item, and then click the Change button. Then click on the "Format" button, the pop-up menu, select the "Border" command, pop-up "Border and Shading" dialog box, the "Border" tab selected "None" can be.

19. Make different watermarks for odd and even pages

First, execute the File-page Setup command, open the Page Setup dialog box, click the Layout tab, select the check box in the front of the different odd and even pages, and click OK to close the dialog box. Then execute the view-headers and footers command. Enter the header and footer editing status, edit the watermark for odd-numbered pages in an odd-numbered page edit area, and edit the even-numbered watermark on an even page edit area.

20. Quick Drawing

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

21. Quickly remove hyperlinks

To remove an underscore from a hyperlink, you can remove the underline by pressing the key combination "Ctrl+z" or "Alt+backspace".

22, how to avoid the title at the bottom of a page

When typesetting a document, it is sometimes found that a title appears at the bottom of a page, and its body appears on a new page, which is very unattractive. In order for the title to be lined up with its body, you can move the cursor to the paragraph in which the heading is located. Select the paragraph command on the Format menu, the Paragraph dialog box, click the Line and Page Break tab in the Paragraph dialog box, select the With next paragraph check box, and then click OK.

In addition, to prevent a single page from appearing at the top of the last line of text, or the first line of text in a paragraph at the bottom of a page, or the first line of text at the bottom of a page, as long as you move the cursor over the paragraph, and then select the Widow/Orphan Control checkbox in the window, the system automatically moves the page down one line of text.

23. How to change a page in a document to landscape

When you're writing some documents, insert a wide table in the document, and you need to change the paper to landscape. To ensure that the contents of the table are still portrait-oriented, you can move the cursor to the table before the Select the page Setup command in the File menu, click the Paper Size tab, select the Landscape radio button in the Orientation area, select the After insertion point option from the Apply to Drop-down list box, and then click OK.

24. How to split a table vertically into two tables

Select the columns you want to split, select borders and Shading on the Format menu, or select borders and Shading in the right-click menu. Click the Borders tab, click the top border, the middle border, and the bottom border in the preview area to remove its border lines, leave the left and right borders, and click OK to complete.

25, skillfully use Word to expand the selection of features

Position the cursor at the top of the section you want to select, press "F8" to start "extension", and you will see the "extension" in the bottom status bar change from gray to black. Click "F8" again, will select a word or a word, press two "F8", will select a sentence, press three "F8", will select a paragraph; by "F8", Select All Press the ESC key or press F6 to turn off the extension feature.

26, Excel cell more than 15 digits of input

Select the cell that you want to enter a number for, and then click Cells on the Format menu, locate the custom command in the number item, and then select the @ item in the Type box to the right, and then enter again.

27, word in the pounds and centimeters of conversion

1 pounds is about 0.03527 centimeters, and 1 centimeters equals 28.35 pounds.

28. Conversion of capacity units in computer

1gb=1024mb,1mb=1024kb;1kb=1024 bytes.

29, copy the previous cell in Excel

In a cell in Excel, press the CTRL key while pressing the "'" (single quote) key to copy the contents of the previous cell.

30, clear the spelling function

When we use Word, often appear in the word after a few words of a wavy line under the situation, sometimes it will affect the visual. To solve this problem, click Tools-Options, and then select spelling and grammar to cancel all of the options, and the point is complete.

31, Word form after the blank page processing

In Word, if the last page of a document is a table, and the table is filled with a whole page, a blank page of snow will be generated thereafter. Although the page contains only one paragraph mark, there is no way to delete it. When printed, the page will still cause the printer to walk a page, resulting in unnecessary waste. The solution to this problem is simple: Place the cursor at the end of the paragraph and set the line spacing to "1" (the minimum allowed by word).

32, change the shape of the picture

To make irregular edits to a picture, you can open the Drawing tool, select any AutoShape, then right-click on the graphic, choose Format AutoShape, click the drop-down arrow in Fill color, select Fill effect, and select the Picture tab, and click on the Select Picture button on the. Then select any image you like in your hard disk folder, and then click OK and the shape of the picture is the AutoShape.

33. Edit segment Vertices

If you are using a line tool to generate a graphic, you can edit the vertices. The method is to select the line, click the right mouse button, select "Edit vertices", and then click the right mouse button to select "Add vertices",

Select the point, click the right mouse button to choose "Smooth vertex" and so on the way you want, drag the mouse to their own needs of graphics. You can delete the vertex by pressing CTRL and clicking the vertex.

34. Switch Grid line

In Excel, to remove the gridlines, in the tools-Custom-command category, find form. On the right, locate the gridline switch (Excel is "toggle Grid"), drag it onto the toolbar, close the dialog box, and then, when you need to remove the gridlines, click, want to recover, and then click.

35. Quickly change line spacing in Word

Select all text paragraphs you want to change the line spacing, press ctrl+1 to set the paragraph to single spacing, press CTRL+2 to set the paragraph to double spacing, and press CTRL+3 to set the paragraph to 1.5 times-line spacing.

36. Quickly select a paragraph in Word

Place the cursor in the left margin of a line in the paragraph that you want to select, click once, select the row, click the left two times, select the paragraph, click the left three times, and select the full text.

37. Implement automatic line wrapping in Excel

Select Format-cell-align in the menu bar, and then select the Wrap text check box under the control title (tick). If you want to fragment the text in the cell, press the Alt+enter key to implement the hard return line break operation.

38. Some know-how of Chinese character input method

Fixed use of a certain type of Chinese character input method, hope that the first computer to open the input method in service. To do this, simply open the keyboard in Control Panel, bring up the language page, select the Chinese character input method you want in the Language bar, and then click the "set as Default" and "OK" button, and finally reboot.

Use the Ctrl+shift key combination to cycle through the English and all Chinese character input methods. In order to get the Chinese character input method we need, it is very inconvenient to even press a few ctrl+shift. In fact, we can often use the Chinese character input method defined as a hot key, need to click it. For example, want to "Wang code Wubi Input Method 86 version" defined as CTRL+SHIFT+8, you can open the Input method in Control Panel, bring up the Hot Key page, find "switch to Wang Wubi Input method version 86" In the project, and select "Ctrl", "left" and "right" in "key combinations". , select 8 in the "Basic Key" and press "OK" at the end.

39, with Word2000 symmetrical margins for double-sided printing

In order to save paper, you often use Word to print the document on both sides, but it is hard to align the front and back margins of the printed text. Countermeasures: First, select the File/Page Setup/Margins tab, select the Symmetric margins check box, clear the Spelling check box, and in the inside and outside boxes, enter a symmetric margin value, such as 3.17 cm. Then, insert the page number. Finally, print odd pages and print even pages.

40, Excel Play "transpose"

For data in an Excel worksheet, it is sometimes necessary to convert the column to a row, and the original row becomes a column. Method: Select the cell that you want to manipulate, click Copy, and then determine where you want the transpose action to be, clicking Edit/Paste on the menu, and then check the transpose, and then click OK.

41, Excel easy to sort

When we need to sort the personnel data in an Excel worksheet by the size of the person's position or the level of the title, click Data/Sort/options, click Add in the custom sequence, and then type in the order of the TA, lecturer, associate Professor, and professor.

42, Word in the implementation of the table title repeat

Sometimes the title of the table is very difficult to do, and a lot of page data use the same title, in Word, select the table row that you want to repeat, and then do "Table/header row Repeat", after each input page of data, the next page will automatically appear the header row.

43, excel in the implementation of the table title pagination printing

In Excel, select File/page setup/worksheet/print title/top header row, enter the position of the top header row, for example: the first three lines are the table's need to repeat each page of the title, then enter $1:$3 or A1:A3, when previewing and printing, each page will display and print out the title. If you also need to print line numbers and column labels, you can check the row number column.

45, word reading to eliminate fatigue tips

Open the document that you want to read in Word, black and white on the screen as if it's not good for your eyes, then select "Tools/Options/General", in the "General Options" in the "Blue background white" election, this way can eliminate some eye fatigue; In addition, click Gridlines on the View menu to make it easier to read. ", the screen will appear in a manuscript-like horizontal line."

46, give the cell with the formula dot color see

Select Edit/position, open positioning criteria, select formula, press OK to exit, so that all cells with formulas are selected, and select a background or font color on the toolbar.

47, the beginning of the row followed by the following point

In Excel, when a cell becomes the active cell, it is surrounded by a thick wireframe, the mouse is pointed to the top border, and then the left mouse button is clicked, and the active cell is quickly positioned at the beginning of the line, followed by the trailing point of the header column.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.