ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   IMPORTING SHEETS (https://www.excelbanter.com/new-users-excel/32793-importing-sheets.html)

Rebecca

IMPORTING SHEETS
 
Hi, again. I am using EXCEL 2003. I need to import several specific sheets
from a certain xls file into another xls file. I can't find the information
on how to do this. Could an expert please explain in easy English how this
can be done? Thanks.

Bill Ridgeway

The simple answer is Cut (or Copy) and Paste.

Either
Click on the box above the vertical cell number and to the left of the
horizontal cell letter to highlight the whole of the spread sheet.
Click on <Edit<Copy
Open a new spreadsheet
Click on <Edit<Paste to import the spreadsheet

Or
Highlight the area to be exported
Click on <Edit<Copy
Place the screen cursor on the (top-left) cell at which you want to
import information
Click on <Edit<Paste to import information

Regards.

Bill Ridgeway
Computer Solutions

"Rebecca" wrote in message
...
Hi, again. I am using EXCEL 2003. I need to import several specific
sheets
from a certain xls file into another xls file. I can't find the
information
on how to do this. Could an expert please explain in easy English how
this
can be done? Thanks.




gls858

Rebecca wrote:
Hi, again. I am using EXCEL 2003. I need to import several specific sheets
from a certain xls file into another xls file. I can't find the information
on how to do this. Could an expert please explain in easy English how this
can be done? Thanks.


One way is to open both workbooks at the same time. Then right click on the
tab of the sheet you wnat to move and select move or copy. In the box that
pops up select the workbook you want to move the sheet to.

gls858

Lady Layla

Simpler answer is to use the Move/Copy feature of the sheet.

"Bill Ridgeway" wrote in message
...
: The simple answer is Cut (or Copy) and Paste.
:
: Either
: Click on the box above the vertical cell number and to the left of the
: horizontal cell letter to highlight the whole of the spread sheet.
: Click on <Edit<Copy
: Open a new spreadsheet
: Click on <Edit<Paste to import the spreadsheet
:
: Or
: Highlight the area to be exported
: Click on <Edit<Copy
: Place the screen cursor on the (top-left) cell at which you want to
: import information
: Click on <Edit<Paste to import information
:
: Regards.
:
: Bill Ridgeway
: Computer Solutions
:
: "Rebecca" wrote in message
: ...
: Hi, again. I am using EXCEL 2003. I need to import several specific
: sheets
: from a certain xls file into another xls file. I can't find the
: information
: on how to do this. Could an expert please explain in easy English how
: this
: can be done? Thanks.
:
:




All times are GMT +1. The time now is 01:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com