| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Take formulas out
I want to take all my formulas out the the worksheet and just display the
values |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Using Formulas | New Users to Excel | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
