I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.

Select the cells, edit copy. Go to the destination choose edit, paste
special and choose values

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=517473

Copy PasteSpecial Values..........

Vaya con Dios,
Chuck, CABGx3



"Holden Caulfield" wrote:

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.

Holden, copy the cells, right click where you want the results and paste
special, valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Holden Caulfield" <Holden wrote in
message ...
I want to copy just the results of formulas in a series of cells and not
the
formulas. that is i want to copy the values in cells.

Use "Paste Special" instead of "Paste". You'll then have an option to select
just "Values".

HTH,
Elkar


"Holden Caulfield" wrote:

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.

"Holden Caulfield" <Holden wrote in
message ...
I want to copy just the results of formulas in a series of cells and not
the
formulas. that is i want to copy the values in cells.

Instead of Paste, go to the menu & click Edit, Paste Special, and select
Values. Lots of other interesting options there, too, like Formats, which is
especially handy sometimes.

thank you. HC

"CLR" wrote:

Copy PasteSpecial Values..........

Vaya con Dios,
Chuck, CABGx3



"Holden Caulfield" wrote:

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.

thanks Dav. HC

"Dav" wrote:


Select the cells, edit copy. Go to the destination choose edit, paste
special and choose values

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=517473

thanks HC

"Elkar" wrote:

Use "Paste Special" instead of "Paste". You'll then have an option to select
just "Values".

HTH,
Elkar


"Holden Caulfield" wrote:

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.

thanks paul. HC

"Paul B" wrote:

Holden, copy the cells, right click where you want the results and paste
special, valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Holden Caulfield" <Holden wrote in
message ...
I want to copy just the results of formulas in a series of cells and not
the
formulas. that is i want to copy the values in cells.

thank you Doug. HC

"Doug Kanter" wrote:


"Holden Caulfield" <Holden wrote in
message ...
I want to copy just the results of formulas in a series of cells and not
the
formulas. that is i want to copy the values in cells.

Instead of Paste, go to the menu & click Edit, Paste Special, and select
Values. Lots of other interesting options there, too, like Formats, which is
especially handy sometimes.

There is an Excel command button (Paste Values) that will do this for you in
one keystoke. It looks like a clipboard with "12" on it. To put it on your
toolbar, right click next to your toolbars - Customize - Commands tab - Edit
category - pull down the Commands to the Paste Values icon. Drag this icon
up and into your toolbar. Viola.

"Holden Caulfield" wrote:

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.