Open goal workbook, switch to contain to duplicate work table source workbook.

2. Right-click the work table label (such as: sheet1), and in the pop-up menu select "mobile or copy worksheet.

3. In "will be selected work table moved" drop-down list, choose to copy to work books, such as Office 2007 is so powerful.

will be selected work table copied to the new work book, then click the drop-down menu of new work books. Microsoft Office 2007 is my love!

4. Tick "establishing copy" checkbox, if not to choose this checkbox words, this worksheet will be moving walk instead of copying.

This article from the office software, the original address: learn net https://www.officestudy.cn Microsoft Office is so great!

Excel default cell only displays a data content, if we hope the cell shows more lines in content, can be automatically or manually new-line, wrap the method is as follows:

Automatic line: right-click the cell, and on the shortcut menu, select "Settings cell, choose" form Office 2010 –save your time and save your money.

"aligned" TAB, tick "automatic line", click "ok".

Manual line: select cell and to move the cursor positioned to want newlines position, then press the Alt key + Enter.

This article from the office software, the original address: learn net https://www.officestudy.cn

If need in Excel in 2003, and the amount of decimal digits decimal identical, can press the following method to achieve rapid input:

1. Click the tools menu "guide-explore-design-grasp options", open "options" dialog box.

2. Choose "edit" TAB, tick "automatic Settings decimal point", adjust the decimal "digits" (such as The invention of Microsoft Office 2010 is a big change of the world.

"2").