All Value, No Formatting

12.05.2007 07:33
All Value, No Formatting


Excel is particularly adept at handling formulas for calculating complex formula but if you need to copy a particular result, you just want the value without the equation. If you have a cell that contains a formula, copy the cell with CTRL-C after it computes the value and paste it into your target cell.



Click the Paste Options smart tag associated with the target cell and click the Values Only radio button. This will display the value of the copied cell in the target cell.

Add your comment Send Print Report

Add your comment
  Anonymous comment
Nickname:
Password:
  Remember me on this computer

Title:
Send me by email any answer to my comment
Send me by email every new comment to this article

Home Page | Tip of the day
Latest
The state of the world Future peace Dear Mr. President, the three terrors Pod sweet pod: capsule rooms hit Hong Kong There Are Still Protesters Outside Dolce & Gabbana's Hong Kong Boutique Hong Kong Issues Advice On RMB Investment Products Hong Kong Leads Euromonitor's Top City Destinations Ranking London in HK link-up to trade in yuan China to Encourage More Yuan Listings in Hong Kong Girls' Generation wraps up successful solo concert in Hong Kong Hong Kong post goes to Dutch conductor Hong Kong health department recalls Teva drug Mainlanders heading for Hong Kong in droves this New Year Thousands of workers protest at Sanyo's China plant
Eric's Latest
One of the cresults...Time to Reboot AmericaInt'l Arts Carnival to launch July 11L'Empereur du ChantBruce Lee to hit BroadwayArchives to reopen after floodCultural NomadKama Sutra For IT PeopleTan Yuanyuan accepts guest principal dancer position at Hong Kong BalletArt HK 08 Draws Huge Audiences
Embed in your website
Nasa
NASA Hosts Its First Google+ Hangout Connecting with Space Station NASA Casts A Wide Net For STEM Education Partners Reporters Invited to International Space Station Social Media Event NASA Experts Discuss Russia Meteor in Media Teleconference Today NASA Awards Final Space Launch System Advanced Booster Contract NASA'S Fermi Proves Supernova Remnants Produce Cosmic Rays NASA Targets March 1 Launch for Next SpaceX Station Resupply Mission; Media Accreditation Open NASA to Chronicle Close Earth Flyby of Asteroid NASA Spinoff 2012 Features New Space Tech Bettering Your Life Today NASA's Chandra Suggests Rare Explosion Created Our Galaxy's Youngest Black Hole
Google Blog
RISE Awards 2013: A global effort Fireside Hangouts: Join President Obama on Google+ after the State of the Union Solve for X: Celebrating moonshot thinking—join us and declare your X! Zagat: Who’s serving up the best service? A Chrome Experiment made with some friends from Oz Safer Internet Day: How we help you stay secure online Google and Brazil celebrate Carnival 2013 M&M’s, Beyonce and Ravens dominate game day searches on Google Google creates €60m Digital Publishing Innovation Fund to support transformative French digital publishing initiatives Exploring the Grand Canyon on Google Maps