ExcelBanter - Can I fix a format so it doesn't change when I drag or copy/paste

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

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

- - Can I fix a format so it doesn't change when I drag or copy/paste (https://www.excelbanter.com/excel-worksheet-functions/130889-can-i-fix-format-so-doesnt-change-when-i-drag-copy-paste.html)

Blah-blah

Can I fix a format so it doesn't change when I drag or copy/paste

Gord Dibben

Can I fix a format so it doesn't change when I drag or copy/paste

Excel's default is to retain formats when drag or copy/paste.

Is your Excel not doing this?

Or do you mean you want formulas to not change when drag copy/paste?

Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 07:26:27 -0800, Blah-blah
wrote:

All times are GMT +1. The time now is 07:17 PM.