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...

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)

"Suzi-Q" wrote in message
...
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...

To copy just formulas from a range.

Select a range then F5SpecialFormulasOK

CopyPaste SpecialAllOK

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


Gord Dibben MS Excel MVP

"Suzi-Q" wrote in message
...
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...

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
"Gord Dibben" wrote:

To copy just formulas from a range.

Select a range then F5SpecialFormulasOK

CopyPaste SpecialAllOK

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


Gord Dibben MS Excel MVP

"Suzi-Q" wrote in message
...
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...

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

"Chip Pearson" wrote:

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)

"Suzi-Q" wrote in message
...
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...

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

On Jul 31, 3:00 pm, Suzi-Q wrote:
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



"Chip Pearson" wrote:
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)

"Suzi-Q" wrote in message
...
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...- Hide quoted text -

- Show quoted text -

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" wrote:

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

On Jul 31, 3:00 pm, Suzi-Q wrote:
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



"Chip Pearson" wrote:
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)

"Suzi-Q" wrote in message
...
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...- Hide quoted text -

- Show quoted text -

Thanks for feeding back - glad it worked for you.

Pete

On Jul 31, 6:32 pm, Suzi-Q wrote:
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" wrote:
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

On Jul 31, 3:00 pm, Suzi-Q wrote:
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

"Chip Pearson" wrote:
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)

"Suzi-Q" wrote in message
...
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...- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -