Paste Special Values to MERGED cells

awh · Feb 19th, 2002, 08:06 AM

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!

NateO · Feb 19th, 2002, 10:38 AM

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

Regards,
Nate

awh · Feb 20th, 2002, 01:40 AM

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

Derek · Feb 20th, 2002, 02:01 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 08:06 AM	#1
awh New Member Join Date: Feb 2002 Location: Scotland Posts: 3	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!

Feb 19th, 2002, 10:38 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Did you try just selecting one cell when your pasting (versus the same range of cells)? Regards, Nate

Feb 20th, 2002, 01:40 AM	#3
awh New Member Join Date: Feb 2002 Location: Scotland Posts: 3	Yep - same result, it won't paste only the values.

Feb 20th, 2002, 02:01 AM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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 ]