Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. : : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Numbering sheets in workbook | Excel Worksheet Functions | |||
Importing data from several sheets, to one chart | Charts and Charting in Excel | |||
Multiple sheets selected | Excel Discussion (Misc queries) |