Paste Special Values to MERGED cells
Paste Special Values to MERGED cells
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Paste Special Values to MERGED cells

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Scotland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am copying a group of cells and want to paste the values into another excel worksheet. If I do paste then this works, unfortunately giving me #REF (they are referenced cells). I only want the values copied. Trying Paste Special Values results in an error - cells must be identically sized. I have resized the target to no avail, Any thoughts? All other Paste Special options (formulas, formats, comments etc.) work fine, i just want the values!

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you try just selecting one cell when your pasting (versus the same range of cells)?

    Regards,
    Nate

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Scotland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yep - same result, it won't paste only the values.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi AWH
    Try a normal paste from a single cell to a merged cell, this seems to convert a formula to a value when I do it. If you need the formula, do a paste special formula.

    Going the other way (merged cell to single) seems trickier. I would type = in the single cell then select the merged cell and press Enter. Then select the formula in the single cell, copy and paste it back special values.
    Hope this helps
    Derek

    [ This Message was edited by: Derek on 2002-02-20 01:10 ]

    [ This Message was edited by: Derek on 2002-02-20 01:27 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com