Main Profile

At A Glance

Excel Tips 11 - Paste Values in Excel - Replace Formulas with Values

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to replace formulas, functions, and links to other workbooks with the displayed values. This is called pasting values and allows you to turn dynamic formulas into static values. This is a great feature of Excel which allows you to better analyze data since it won't be able to change after you copy and paste the values. This is a must for anyone who analyzes data regularly. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Length: 04:42

Contact

Questions about Excel Tips 11 - Paste Values in Excel - Replace Formulas with Values

Want more info about Excel Tips 11 - Paste Values in Excel - Replace Formulas with Values? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question