Bruce

Unregistered less info
11 reputation
12
bio website
location Evesham, United Kingdom
age
visits member for 1 year, 7 months
seen Jan 16 '13 at 10:37

Jul
15
awarded  Notable Question
Apr
8
awarded  Popular Question
Dec
10
comment 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?
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
comment 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?
Thank you Joseph. Yes, that was the dialogue box I was getting as i was trying to copy selected cells from one spreadsheet I've used for a long time to another one I've recently created this past week. The formulas and comments don't then get copied across for some reason. But when I did what you stated and clicked to create a brand new workbook and then clicked Paste Special, lo and behold the normal "Paste Special" dialogue box opens up giving the option to select, All, or just values or formats or comments etc. I've no idea why that works though and doing it the other way doesn't. Thank you
Dec
10
awarded  Student
Dec
10
comment 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?
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
comment 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?
Sorry, I probably didn't explain myself quite well enough. What I meant is that whereas if I copy a section of my spreadsheet and then right click elsewhere in the same spreadsheet and select "Paste Special", I get the "Paste Special" dialogue box open up where I can select from the radio buttons what I want to paste; everything, or individually select whatever I want from the list, i.e. just formulas, values, formats, comments etc. This option doesn't exist though when copying a group of cells from one spreadsheet to another brand new one as all i get is the option to select the file type.
Dec
10
asked 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?