Show All

Hide All

1. Click the arrow next to the Name box on the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), and select the name of the external data range (external data range: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.) that you want to copy.

   If you want to include column labels or formulas that are not part of the external data range, select the cells that contain the column labels or formulas that you want to copy. Click the arrow next to the Name box on the formula bar, and click the name of the external data range you want to copy.

2. Click Copy .
3. Switch to the workbook where you want to paste the external data range.
4. Click the upper-left cell of the paste area (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.).

   To ensure that the external data (external data: Data that is stored outside of Excel. Examples include databases created in Access, dBASE, SQL Server, or on a Web server.) does not replace existing data, make sure that the worksheet has no data below or to the right of the cell you click.

5. Click Paste .

Note  If you copy only part of an external data range, the underlying query (query: In Query or Access, a means of finding the records that answer a particular question you ask about the data stored in a database.) is not copied and the copied data can't be refreshed (refresh: To update data from an external data source. Each time you refresh data, you see the most recent version of the information in the database, including any changes that were made to the data.).