Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a file in a work sheet in excel
Using Excel 2003
I want to combine a number of worksheets into one. Like you can i do with docs in Word to produce one document. Is there any other way of doing it rather than copy and paste? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a file in a work sheet in excel
Open the target file and the source files and click on WINDOW, ARRANGE, TILED
to view all of the workbooks. You can then click on one of the source workbooks and click and drag the tab you want to your target. Don't resave the source workbooks as this actually moves the worksheet from the source file to your target. Or, activate one of the source files, right click on the tab you wish to copy and select MOVE OR COPY. From the list in th TO BOOK combo box, select your target. In the BEFORE SHEET list, select the position you want your copied worksheet to occupy in the target and check the CREATE COPY check box. -- Kevin Backmann "ST" wrote: Using Excel 2003 I want to combine a number of worksheets into one. Like you can i do with docs in Word to produce one document. Is there any other way of doing it rather than copy and paste? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
open new microsoft excel sheet and found my last same file all ti. | Excel Worksheet Functions | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |