Take formulas out
 

I want to take all my formulas out the the worksheet and just display the
values

Take formulas out
 

Ed

Highlight the data and then copy it, now immediately right click and select
paste special+Values, or Values and number formats

This will kill the formulas for you

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"ED" wrote in message
...
I want to take all my formulas out the the worksheet and just display the
values

Take formulas out
 

Select all the cells
Use the Copy command
With all cells still selected, use Edit |Print Special and specify Values

Suggest you save the file fist under a new name in case you change your
mind!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ED" wrote in message
...
I want to take all my formulas out the the worksheet and just display the
values

Take formulas out
 

Have you tried to copy and paste special as values?

HTH,
Barb Reinhardt

"ED" wrote:

I want to take all my formulas out the the worksheet and just display the
values

Take formulas out
 

Yes, this works, however I have about 20 different price sheet that are
formatted in a specific way (colour, fonds, highlights). I am loosing all
my formatting this way.
ED

"Nick Hodge" wrote:

Ed

Highlight the data and then copy it, now immediately right click and select
paste special+Values, or Values and number formats

This will kill the formulas for you

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"ED" wrote in message
...
I want to take all my formulas out the the worksheet and just display the
values

Take formulas out
 

Thank everybody, it worked, I copied the value first, then I copied the
formats thanks again

"Nick Hodge" wrote:

Ed

Highlight the data and then copy it, now immediately right click and select
paste special+Values, or Values and number formats

This will kill the formulas for you

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"ED" wrote in message
...
I want to take all my formulas out the the worksheet and just display the
values

Take formulas out
 

It shouldn't change the formats if you copy and paste special as values in
the same cells that held the formulas


--
Regards,

Peo Sjoblom



"ED" wrote in message
...
Yes, this works, however I have about 20 different price sheet that are
formatted in a specific way (colour, fonds, highlights). I am loosing
all
my formatting this way.
ED

"Nick Hodge" wrote:

Ed

Highlight the data and then copy it, now immediately right click and
select
paste special+Values, or Values and number formats

This will kill the formulas for you

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"ED" wrote in message
...
I want to take all my formulas out the the worksheet and just display
the
values