Copying cells

[michael.collins22]

Is there a way to copy cell values and not the formulas within those cells?

I have a table of cells with formulas in each. The formulas return and display numbers. I am trying to copy and paste the numbers that the formulas return and display. I can type in the numbers myself, but looking for a way to save some time. Any ideas?

 

[villy]

Hi there..
Without the code you can do Copy then On edit menu click paste special then tick values then OK
it should paste only values not formulas

 

[GTO]

What year Excel are yo u in?

 

[michael.collins22]

2008

 

[GTO]

Mac?

 

[michael.collins22]

Yes

 

[GTO]

Sorry, I know nothing about what the commandbars (or ribbon?) or context menus look like in Mac. I PM'd someone who is familiar.

 

[michael.collins22]

villy's instructions from above work well. I had to practice it a few times, but I got it down. Thanks for the help!

 

[GTO]

Glad you got it