how do i copy just the data and not the formula in a cell?

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

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

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.

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.

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 Caulfield@discussions.microsoft.com> wrote in
message news:660C6A36-92B2-4F10-934F-48986D469EFC@microsoft.com...
>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 Caulfield@discussions.microsoft.com> wrote in
> message news:660C6A36-92B2-4F10-934F-48986D469EFC@microsoft.com...
> >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.

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.

"Holden Caulfield" <Holden Caulfield@discussions.microsoft.com> wrote in
message news:660C6A36-92B2-4F10-934F-48986D469EFC@microsoft.com...
>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 Doug. HC

"Doug Kanter" wrote:

>
> "Holden Caulfield" <Holden Caulfield@discussions.microsoft.com> wrote in
> message news:660C6A36-92B2-4F10-934F-48986D469EFC@microsoft.com...
> >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.