Member Panel


Sponsors and Ads

Join the Team

Live Tag Cloud

PC Forum PC Help Forum » Software » General Software » [Resolved] Excel formulas

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 ...

JOIN US NOW to remove these Ads

Post New Thread  Reply
  #1  
Old 03-28-2007
BluesMatt's Avatar
Bronze Member
 
Join Date: Apr 2006
Location: Connecticut
Posts: 94
PC Experience: Experienced
BluesMatt - See this Members User comments on their Profile page
Question [Resolved] Excel formulas

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


  #2  
Old 03-28-2007
Lord Chance's Avatar
Elite Member
 
Join Date: Mar 2007
Posts: 489
PC Experience: Experienced
Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page Lord Chance - See this Members User comments on their Profile page
Default

Hello Matt

While you are waiting on someone mor knowledgable than me you might try this sight...

Excel Topics: Formulas/Functions (By Category)


  #3  
Old 03-28-2007
BluesMatt's Avatar
Bronze Member
 
Join Date: Apr 2006
Location: Connecticut
Posts: 94
PC Experience: Experienced
BluesMatt - See this Members User comments on their Profile page
Default

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  
Old 03-28-2007
upgrader's Avatar
Site Manager
My PC
 
Join Date: Jul 2006
Location: C:\ UK
Posts: 6,299
PC Experience: Some Experience
upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page upgrader - See this Members User comments on their Profile page
Send a message via MSN to upgrader Send a message via Skype™ to upgrader
Default

Cool Bluesmatt

Thanks for posting how you solved the question. Marked as Resolved.

Chris


__________________
PCHF Rules--PCHF Prework--PCHF Downloads

Reply
Satellite TV on your PC - over 3000 Channels! Click Here!

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On


All times are GMT +1. The time now is 01:51 PM.
Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 RC7
All Graphics & Content Copyright © 2004-2008 - PC Help Forum.com


Back to Top