G
Guest
I want to take all my formulas out the the worksheet and just display the
values
values
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nick Hodge
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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
B
Bernard Liengme
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
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
G
Guest
Have you tried to copy and paste special as values?
HTH,
Barb Reinhardt
HTH,
Barb Reinhardt
G
Guest
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
formatted in a specific way (colour, fonds, highlights). I am loosing all
my formatting this way.
ED
G
Guest
Thank everybody, it worked, I copied the value first, then I copied the
formats thanks again
formats thanks again
P
Peo Sjoblom
It shouldn't change the formats if you copy and paste special as values in
the same cells that held the formulas
the same cells that held the formulas