Take formulas out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take all my formulas out the the worksheet and just display the
values
 
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
 
Have you tried to copy and paste special as values?

HTH,
Barb Reinhardt
 
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
 
You must log in or register to reply here.

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