Link to home
Start Free TrialLog in
Avatar of PawloA
PawloAFlag for Canada

asked on

copying excel worksheets from one file to another

I use ms office excel 2007 and I would like to be able to combine some of my existing worksheets into a single worksheet (Lets call it "A". How do I copy a worksheet from one file onto a page in the worksheet "A" keeping all formatting including height and width, formats, formulas and fonts. I don't want to have to recreate the worksheets.
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PawloA
PawloA
Flag of Canada image

ASKER

I spent some time doing this and to copy a worksheet from one file to "A" you go to the original sheet and rightclick on the sheet name at the bottom of the worksheet and select "Move or Copy" then right click "Create a copy" box otherwise the result will move the file instead of copying it. From the "To Book" choose the file you want to copy it too. In my case it would be "A". and hit "OK" and you are done.
Avatar of PawloA
PawloA
Flag of Canada image

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for PawloA's comment #a38782806

for the following reason:

I figured it out before someone commented on here.
Avatar of PawloA
PawloA
Flag of Canada image

ASKER

Thanks. It was the same as my solution.