Donate SIGN UP

Copying a Excel spreadsheet

Avatar Image
Jack Wes | 20:44 Tue 16th Jun 2009 | Technology
3 Answers
Please Help!

How do I copy an excel spreadsheet together with the formulas. I have copied it, it seems fine until you realise no formula has copied. Someone out there could save me a lot of work. Thanks in advance
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by Jack Wes. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Right click on the tab at the bottom of the sheet you want to copy. Click on 'move or copy sheet'. In the dialogue box that comes up, you'll have the option to copy the sheet to a new book (ie file), and you have to click the 'create copy' tick box as well.

If you want to copy an entire workbook, find the file in Windows Explorer, right click on it and choose 'save'. Then just paste it wherever you need it to be. If that's in the same folder, Windows should just create another file called 'copy of xyz', which you can rename as you wish.
Question Author
Thanks Saxy Jag. Just tried it and its worked great. Thanks you have saved my bacon!
Also useful when you have highlighted and copied - go to 'edit' on the top line and 'paste special' this gives the choice of only copying values not formulas and various other useful things.

1 to 3 of 3rss feed

Do you know the answer?

Copying a Excel spreadsheet

Answer Question >>