Import - Worksheet

The Data | Edit | Import command loads the contents of a data file into the existing worksheet. Select the file to merge with the existing file in the Import Data dialog. The contents of the new file are merged into the worksheet at the active cell so be sure to position the cell at the edge of the existing data. Any cells in the existing worksheet that lie to the right of and below the active cell are overwritten with the contents of the merging file.

 

Multiple files can be opened at one time into the same worksheet with Data | Edit | Import using the SHIFT or CTRL keys while selecting files in the dialog.

 

 

See Also

Data Tab Commands

Print - Worksheet

Page Setup - Worksheet