Edit Paste Special Formulas

[Guest]

If Edit, Paste Special values strips the formulas from a range and leaves the
values, I would expect Edit, Paste Special, Formulas to do the opposite. But,
it doesn't. So, I have two questions: 1) Is there anyway to copy a range and
paste just the formulas in the result? 2) What exactly is Edit Paste Special
Formulas supposed to do? (to me, it looks just like copy, paste but maybe I'm
missing something) Any assistance would be greatly appreciated...

 

[Chip Pearson]

Paste Special Formulas strips formatting and pastes the unformatted results.
Try it with dates and times and you'll get the serial values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Gord Dibben]

To copy just formulas from a range.

Select a range then F5>Special>Formulas>OK

Copy>Paste Special>All>OK

Note: non-contiguous formulas will be paste into a contiguous range.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks. However, I guess I wasn't clear as to what I am trying to do. I want
to copy a worksheet and paste it to a new one, only keeping the formulas
where they are so that I can use the worksheet 'from scratch' without having
to recreate the formulas. I want them to be in the same place, doing the same
thing as before - only starting out with zeroes as answers.

/ss

 

[Guest]

Hi - I was not clear in my question (on me, not on you nice folks who
answered). I have a worksheet that I would like to reuse, without the data. I
can't find a way to copy the formulas, where they are, and have the new sheet
just have them, with zeroes. Since they are all over the place, I thought
there would be an easier way to just keep them and lose the data rather than
copy the sheet and then remove the data manual. Maybe not...

/s

 

[Pete_UK]

Select the sheet you want this to happen to and press F5 (or Edit |
GoTo) then select Special and click on Constants then OK. You will see
all your data (not the formulae) highlighted, and you can just press
the <delete> key to erase them. Then use File | Save As to save your
file with a different name.

Hope this helps.

Pete

 

[Guest]

Thanks - that's what I need. Oh, and sorry about the double posting; I didn't
thnk the first one went thru.

Suzan

 

[Pete_UK]

Thanks for feeding back - glad it worked for you.

Pete