Saturday, April 21, 2012

How to Get Data From Excel Into Word


1. Click Excel's Office button, then click the 'Open' command. Navigate to and double-click a file you'd like to open to Word. Click the 'Save as' command after the file loads, then click the 'Excel 97-2003' format from the 'type' dropdown list. This format lets Word read the Excel data. Click the Office button's 'Close' command to close the workbook.
2. Click Word's Office button, then click the 'Open' command. Click the 'Excel' type from the 'Type' dropdown list, then navigate to the folder in which you saved the Excel workbook in the previous step.
3. Double-click the workbook to begin loading it. Word will display a warning message indicating the possible presence of malicious content. Click 'Yes' to continue opening the workbook.
4. Click the 'Entire' option from the dropdown control labeled 'Open document,' if you want to load the entire Excel workbook into Word. Otherwise, click one of the sheets listed in the dropdown to select just that sheet for importing to Word. For example, if your Excel data is only on 'Sheet1,' click that sheet in the 'Open document' dropdown.
5. Click the 'Name range' dropdown list if you chose to import only a particular spreadsheet in the previous step. Skip this step if you're importing the entire workbook. Otherwise, click a named range of cells in the workbook to import just that named range. For example, if the workbook contains a blocked of cells named 'ArtPatrons,' you can click that name in the 'Name range' dropdown to import just that block of cells.
6. Click 'OK' to import the Excel data into Word. Word will format the imported data as a table in a new Word document.

Blogger news