Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cell paste NIGHTMARE
Hi
I hope someone can help I am trying to paste cells as values - The cells are merged and and underneath the cells that have been merged contain formulas All I want is the top value - the one I can see to be pasted into a new column as one value. Does anyone know how to do this? I'd appreciate your help with this, Thanks Andrea |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cell paste NIGHTMARE
Use Ctrl + C to copy the data and then, to paste, go to Edit - Paste Special
and select 'Values' -- tia Jock " wrote: Hi I hope someone can help I am trying to paste cells as values - The cells are merged and and underneath the cells that have been merged contain formulas All I want is the top value - the one I can see to be pasted into a new column as one value. Does anyone know how to do this? I'd appreciate your help with this, Thanks Andrea |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cell paste NIGHTMARE
If I were you I would remove the merged cells, all people that I know of
with good Excel knowledge always warn about using merged cells because sooner or later you will have problems. For instance if you merge cells A1:D1 to get a header that looks good, you might as well select A1:D1, then do formatcellsalignment and select center across selection instead, then type the header into A1, it will look the same with none of the drawbacks. I can't tell you what to do since I NEVER use merged cells and if I receive a workbook with merged cells I remove the merge -- Regards, Peo Sjoblom wrote in message oups.com... Hi I hope someone can help I am trying to paste cells as values - The cells are merged and and underneath the cells that have been merged contain formulas All I want is the top value - the one I can see to be pasted into a new column as one value. Does anyone know how to do this? I'd appreciate your help with this, Thanks Andrea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I paste a paragraph of text into a merged cell? | Excel Discussion (Misc queries) | |||
How can I paste into a merged cell? | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
con't paste merged cells | Excel Worksheet Functions | |||
paste info into merged cells | Setting up and Configuration of Excel |