Copy worksheet

Copy worksheet

Didn't find your answer?

HowdyI sue Excel 2010.

When I copy a worksheet from another excel file into another, it copies the values and not values and formulaes.

Any suggestions to copy the cells like for like please?

Muchos gracias

Replies (5)

Please login or register to join the discussion.

avatar
By tugwilson
13th Sep 2013 15:28

Not only do I sue, but I use it as well.

Thanks (0)
avatar
By Cathy R
13th Sep 2013 15:31

Click on 'Paste Special', then  'formulas'.

That should do the trick.

Thanks (0)
avatar
By ver1tate
13th Sep 2013 19:21

Click on 'Paste Special',

Click on paste special '123    value and source formatting' You may have to reset numbers to decimal places required, and column widths.

Thanks (0)
avatar
By Cantona1
16th Sep 2013 15:44

It may be overkilling, but it is easy to do it with macro as you can apply more than two options in one step.

Thanks (0)
By redman7
16th Sep 2013 16:49

re

it sounds like you have two instances of excel open to me. Close down oneof the files and re-open through the excel instance that is left. Then try again...I might be wrong but it sounds like that...

Thanks (0)