Is there a way to save the result of a formula in place of the actual formula?
I have a large workbook with many worksheets. Each of these sheets have simple "=" formulas to set each cell equal to a number from one huge master list which is in a separate worksheet. Now I want to replace each "=" formula with the actual value from the master list without manually entering it. Is there a way to do this?
thanks..............................matt
![]() |
|
|||||||
| General Software - [Resolved] Excel formulas posted in the Software forums; Is there a way to save the result of a formula in place of the actual formula? I have a large workbook with many worksheets. Each of these sheets have ... |
|
|
|
#1 |
|
Bronze Member
![]() Join Date: Apr 2006
Location: Connecticut
Posts: 94 PC Experience: Experienced
|
|
|
|
|
| Advertisement - Register to Remove | |
|
|
|
#2 |
|
Moderator
![]() Join Date: Mar 2007
Location: Land of Confusion
Posts: 674 PC Experience: Too Old To Remenber
|
Hello Matt
![]() While you are waiting on someone mor knowledgable than me you might try this sight... Excel Topics: Formulas/Functions (By Category) |
|
|
|
|
|
#3 |
|
Bronze Member
![]() Join Date: Apr 2006
Location: Connecticut
Posts: 94 PC Experience: Experienced
|
Thanks for the link.
I did figure it out. To replace a cell formula with the value, select the cell, click copy on the Standard toolbar, click the arrow next to the Paste button on the Standard toolbar and select Value. The cell formula gets replaced with the result of calculating the formula. Matt |
|
|
|
|
|
#4 |
|
Site Manager
![]() ![]() ![]() Join Date: Jul 2006
Location: /home/upgrader/
Posts: 7,250 PC Experience: Some Experience
|
Cool Bluesmatt
Thanks for posting how you solved the question. Marked as Resolved. Chris |
|
|
|
![]() |
| Bookmarks |
| Tags |
| excel, formulas, Resolved |
| Thread Tools | |
| Display Modes | |
|
|





























Linear Mode

