Take formulas out

  • Thread starter Thread starter Guest
  • Start date Start date
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/
 
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
 
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
 
Thank everybody, it worked, I copied the value first, then I copied the
formats thanks again
 
It shouldn't change the formats if you copy and paste special as values in
the same cells that held the formulas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
just need to display formulas nothing appears 3
Excel Moving data to sheet2 from sheet1 0
Excel Sequential Numbering System 0
Scrabble Value calculation for Welsh words 0
How can I stop a formula from executing based on a cell value? 4
Excel Help to copy information from one row at a time to another sheet 1
Excel Excel Formula OFFSET maybe? 1

Back
Top