Copy / Paste Merged Cells

  • Thread starter Thread starter LPS
  • Start date Start date
L

LPS

Using Excel 2000, is is possible to copy and paste a range
which has merged cells such that the pasted data displays
only values.

When using paste special and the "formula" option, merged
cells will paste into the destination without problems but
when using paste special with the "value" option, merged
cells will not paste.

Is there a way to do this easily and if so, what is it?

Thx.
 
Maybe you can copy from the formula bar and paste into the formula bar???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
I can't copy and paste equations 0
Copy/Paste into merged cells 2
Pasting into merged cells 1
Paste Special Values 2
Merge Cell Cut & Paste 1
How to merge 2 + contiguous cells without lossing data? 2
copy formulas over merged cells 2

Back
Top