Saturday, July 13, 2013

How to Import a Word 2007 File to Excel 2007


1. Open the Microsoft Excel 2007 spreadsheet file that you want to import a Word 2007 file into.
2. Click on the 'Microsoft Office' button, and then click on the 'Open' option. The 'Open' dialog box will appear on your screen.
3. Select the 'Text Files' option, and then double-click on the Word 2007 file that you want to import. The text import wizard dialog box will appear.
4. Click on the 'Delimited' option if your Word 2007 text includes commas or tabs that separate the fields, or click on the 'Fixed width' option if the fields are aligned in columns.
5. Select the number of the row where you want the text to be placed, and then click on the 'Next' button. Click on the 'Next' button again.
6. Select an option below the 'Column data format' heading, such as the 'General,' 'Text,' 'Date' or 'Do not import column' option. Click on the 'Finish' button.
7. Click on the 'Existing worksheet' option, and click on the 'Collapse' button to select a cell range where you want the text to be placed. Click on the 'OK' button, and your text will be imported.

Blogger news