Timeline for How do I copy part of an Excel worksheet to another Excel spreadsheet and retain the formulas rather than just the figures in the cells?
Current License: CC BY-SA 3.0
5 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Dec 10, 2012 at 14:42 | comment | added | user1301428 | You're welcome :) Now you can award me some points :P | |
Dec 10, 2012 at 14:38 | comment | added | Bruce | Useful info too. Thanks user1301428. This is the first time I've used this website and it's been really helpful and the answers far quicker in coming than expected. Thank you. | |
Dec 10, 2012 at 14:28 | comment | added | user1301428 | You could simply select some of the columns to copy, move them to a new sheet inside the same workbook, and then create the new book in the way I explained in my answer. | |
Dec 10, 2012 at 14:23 | comment | added | Bruce | Thanks for that, I've tried it and it works, retaining all of the formatting, comments, everything. However, if anyone knows how you can do the same thing but selecting just part of the spreadsheet to copy, that would be really useful to know as it would save much time in deleting/modifying all the stuff I don't want to copy across. Thanks for your help though; it's really appreciated. | |
Dec 10, 2012 at 14:16 | history | answered | user1301428 | CC BY-SA 3.0 |