+ Reply to Thread
Results 1 to 4 of 4

Paste Just Values in Excel

  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    111

    Paste Just Values in Excel

    Hi
    In a sheet i have a formula in Cell A11 where it adds from Cell A1 to A10.
    In Cell A12 i need to have a formula where it can just paste the values of the Cell A11 Automatic.
    Is it possible.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Paste Just Values in Excel

    Use Paste Special / Values
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    05-19-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    111

    Re: Paste Just Values in Excel

    I need a formula to do so because this values to to be linked with same sheet and it goes as cell reference.
    So any formula which can directly just give the cell falues whenever it changes

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Paste Just Values in Excel

    All formulas give a value

    Sounds like a job for VBA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel to open file, copy paste as values and save as excel
    By Adelin in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-10-2017, 06:18 AM
  2. Replies: 3
    Last Post: 11-29-2014, 01:14 PM
  3. Vba to get values from XML and paste it in excel.
    By Abinaya in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 02:07 AM
  4. Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  5. [SOLVED] Excel 2010 - Paste Values with Paste Transpose at the same time
    By phillyfilly in forum Excel General
    Replies: 3
    Last Post: 11-05-2013, 04:23 AM
  6. Replies: 1
    Last Post: 12-05-2012, 11:37 AM
  7. [SOLVED] Excel 2002 - Can only paste values, wont let me paste special
    By MK_Chopper_P in forum Excel General
    Replies: 2
    Last Post: 07-12-2012, 02:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1