| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL SHEETS
I have two Excel files containing several sheets each. How do I move a sheet
from one file / workbook to the other, but the column widths are differeant and row heights for the sheets i need to add to the other sheets, i need to retain the formatting on the sheets that i will be adding to the other sheets. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL SHEETS
Samantha,
Select all the cells in the source sheet and copy then select A1 in the recieving sheet and Edit|Paste Special - select ALL OK Mike "Samantha" wrote: I have two Excel files containing several sheets each. How do I move a sheet from one file / workbook to the other, but the column widths are differeant and row heights for the sheets i need to add to the other sheets, i need to retain the formatting on the sheets that i will be adding to the other sheets. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL SHEETS
Hi
Rightclick the sheet tab(s), select "Move or copy" and follow the wizard. (You lost me on the formatting problem, sorry :-) HTH. Best wishes Harald "Samantha" wrote in message ... I have two Excel files containing several sheets each. How do I move a sheet from one file / workbook to the other, but the column widths are differeant and row heights for the sheets i need to add to the other sheets, i need to retain the formatting on the sheets that i will be adding to the other sheets. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL SHEETS
Hi
Right click on the sheet tab you want to copy, select "Move or Copy" Select the book to move to. Check "Create a copy" if you want to copy the sheet. Hopes this helps. --- Per "Samantha" skrev i meddelelsen ... I have two Excel files containing several sheets each. How do I move a sheet from one file / workbook to the other, but the column widths are differeant and row heights for the sheets i need to add to the other sheets, i need to retain the formatting on the sheets that i will be adding to the other sheets. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
