ExcelBanter - Special Paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Special Paste (https://www.excelbanter.com/excel-worksheet-functions/247469-special-paste.html)

David

Special Paste

How do I paste a workksheet that has merged cells & formulas into a new
worksheet to have just values and the same merged cells

David Biddulph[_2_]

Special Paste

In general the advice is to avoid using merged cells. There is usually a
better solution.
--
David Biddulph

"David" wrote in message
...
How do I paste a workksheet that has merged cells & formulas into a new
worksheet to have just values and the same merged cells

Gary''s Student

Special Paste

Copy the worksheet and not the values.
--
Gary''s Student - gsnu200908

All times are GMT +1. The time now is 06:59 AM.