Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rebecca
 
Posts: n/a
Default 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   Report Post  
Bill Ridgeway
 
Posts: n/a
Default

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   Report Post  
gls858
 
Posts: n/a
Default

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   Report Post  
Lady Layla
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
Numbering sheets in workbook Red Excel Worksheet Functions 3 March 2nd 05 08:10 PM
Importing data from several sheets, to one chart Martin Thorgaard Charts and Charting in Excel 2 January 6th 05 03:07 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM


All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"