Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel, it contains about 20 sheets.
Every sheet has formula in it. I want another excel , it is the copy of the above excel, While in it there is no formula , only the value of the above excel. Because the sheets are too many , I dont want to do it manually, How to automatic realize it ? Thanks. Dawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
Paste Values in Number of rows as count in other sheet | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Paste range of values into filtered sheet | Excel Discussion (Misc queries) |