ExcelBanter - How to maintain merged cell format when cutting the content away

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

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

- - How to maintain merged cell format when cutting the content away (https://www.excelbanter.com/excel-worksheet-functions/124221-how-maintain-merged-cell-format-when-cutting-content-away.html)

ifjoe

How to maintain merged cell format when cutting the content away

Gord Dibben

How to maintain merged cell format when cutting the content away

This is not possible when cutting AFAIK.

Use Copy and paste then go back to original and Clear Contents to preserve the
formatting.

Gord Dibben MS Excel MVP

On Sun, 31 Dec 2006 09:07:00 -0800, ifjoe
wrote:

ifjoe

How to maintain merged cell format when cutting the content aw

Thanks for the reply. Shame though, doubles your work.

ifjoe

"Gord Dibben" wrote:

This is not possible when cutting AFAIK.

Use Copy and paste then go back to original and Clear Contents to preserve the
formatting.

Gord Dibben MS Excel MVP

On Sun, 31 Dec 2006 09:07:00 -0800, ifjoe
wrote:

All times are GMT +1. The time now is 05:56 PM.