Copying a Excel spreadsheet

[Jack Wes]

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

[saxy_jag]

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.

[Jack Wes]

Thanks Saxy Jag. Just tried it and its worked great. Thanks you have saved my bacon!

[BillyBB]

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.