You don't know any of these office tips? Don't say you know office

How to Adjust Margins

Click Page Layout > Margins > Customize Margins > Done. 2003 version can be adjusted in Page Setup.

How to set different header for each page

After setting the header of the first page, click "Page Layout" > "Separator" > "Next Page",online pdf conversion free double-click to enter the header of the next page, uncheck the box on the toolbar. "Link to previous page or header" is ok.

How to insert bullets

Click on "Start", in the paragraph symbols click on the small triangle symbol,convert scanned pdf to word text rtf online you can find their own related research projects through the cultural symbols.

How to hide and show text

Find the font section in the "Start" column. Under this section there is a symbol for more settings. Click on "Hide" the selected text. If you want to show the hidden words, click File > Options > Show and check the hidden text column.

How to remove the horizontal line under the header

Double-click the header to select the text, click Design u003E Page Border,convert word to pdf without losing formatting select the border, click to remove the lower border of the paragraph, and then press OK.

How to find the ruler tool

Click View > Ruler to check ~

How to fine-tune table lines

Select the top and bottom cells and specify the same width, or hold down the "Alt key" to fine-tune.

How to auto-generate table of contents

After editing the text, click "View" > "Outline View", and then in the recognized interface you can select the title of each part and change to the enterprise corresponding to different levels of directory, completed by clicking on the "Citation After completion, by clicking on the "Citation" to select an inserted directory management can be.

How to copy Word table format to Powerpoint

Choose to copy all Word tables, open Excel to copy, and then copy all the tables in Excel to PPT.

How to Display Word Annotations and Compare Documents

Show Comments:Click Review u003E Revise u003E to display the markup u003E comment box u003E to display the revisions in the comment box. Compare Documents:Reviewu003E Compare. Select the original document and the revised document in the Tip window and the comparison results will be displayed.

Excel Usage Tips Techniques

How to split cell contents into multiple rows

After selecting all the text content, click the cell, right-click and select Text Paste.

How to add a drop-down list

Click data > column > sets, select the order and then enter the drop down list at the source code, separated by commas. Click OK to generate it.

How to retrieve unsaved forms

Click Fileu003E Optionsu003E Saveu003E Save Workbook, set the time and path for auto-save, enter to go directly to the save location.

How to prevent repeated data entry

Select a column or a line, click "Data" > "Data Analysis and Validation", in the "Settings", select "Customized ", enter the formula = COUNTIF (A: A, A1) = 1, done!

How to set the cell data bar

When we want to more directly see the state of the data in the table, we can select a column of data, click "Conditional Format" > "Data Bar", select the style can be.

How to change the irregular date

Select a column of date data, press the shortcut key "Ctrl+H" to bring up the search and replace window, replace the search content.] With [u002F], replace the two new columns, first enter the formula = DATETString (A2), and then scroll down to modify the year and month format.

How to quickly generate charts

Select all data and press the shortcut Alt F1 to generate a chart.

Batch split text and numbers

Manually separate text and numbers in the first cell, then press Ctrl+E to finish.

Quick Summation

Summation of most of our students will use the form of function, but it is more difficult to remember, in fact, it is possible to select all and then press the key combination Alt + =, you can pass the display information data.

Set the zebra background

select a data list, click the "conditional format", select "new rules", select "use the formula to determine the format of the cell", enter the format field = ISODD ( ROW (a 2)), a 2 indicates from which cell to start, and then click "Format", enter "fill", select the color to determine.

PPT skills collection

Quickly replace the font

Click on "Start " u003E "Replace " u003E "Replace Fonts " to select most of the fonts you are currently using from the fonts in the "Replace ", and then replace them with the uniform fonts.

To hide page animations

Click Slide Show > Settings and select No animation in the projection room. Click OK and you will be able to save the animation settings.

How to save PPT in video format

Click "File" > "Export" > "Create a video", you can choose the resolution of the screen space, whether you need to record the timing and narration, the number of seconds of slide show, etc., and then click "Save". After changing their own settings, click "Create Web Video" can be saved as MP4 format data files.

Change the number of undo times

The default number of undo is 20, we can click "File" > "Options" > "Advanced" to change the maximum number of undo in the editing options bar.

How to take notes during screening

Right-click on the selected page during screening and select "Pointer Options" to bring up the Annotation Brush. If you want to clear your annotations after they are made, you can also clear them by clicking "Clear all ink on slides".

How to add a reference line

Click "View", check the option of reference line, if you want to copy the reference line, just hold down the "Ctrl" key and drag it, if you want to delete the reference line, drag it out of the box to delete it.

How to set an element repeated in PPT

Sometimes we need to add students' own corporate brand logo on each page of the PPT, then teachers can click "View">"Slide Master">"Insert "> select your logo, adjust the different positions and sizes, after insertion, you can directly see the cut off all the active slides for the same target position are inserted into the logo, close a master view technology can be.

How to prevent PPT from being modified

Click on "File" > "Save as" > "Tools" > "General Options" > "Set password to change permissions", confirm the password and save it, the PPT sent to the client will not be modified.

How to record video on PPT

Click Slide Showu003E Record Slide Showu003E to select the area to start recording.

How to create a good looking presentation

Sometimes some steps need to be visualized. We can use the SmartArt feature to select your favorite style. Here are a variety of flowcharts.

Summarize

Utilizing the above function points, you will surely get twice the result with half the effort. The introduction of this issue of word, PPT, excel here. If you find it useful, remember to share it with your friends!