|
Where do
you want to put the imported data? When you click on Get
External Data you will be prompted to choose a worksheet. 3. This
This: Choose a Worksheet Go to the
new, blank worksheet. Select Cell $A$1. What
Else Do You See? The other options include adding the data to an
existing worksheet. This option would append the data: add to
the existing rows. You can also
put the data in a new worksheet. Click
OK. Keep
going...
Exam 77-888: Microsoft Excel Expert
2010
1. Sharing and Maintaining Workbooks
1.1. Apply workbook settings,
properties, and data options: Import XML data
Data ->Get External Data->From Other
Sources |
|
| |
