Locking the background so it's not wiped by cut-n-paste

  • Thread starter Thread starter Mike Halsey
  • Start date Start date
M

Mike Halsey

Hiya,

Does anybody know how to lock a background design (grid, colours etc) so
it's not moved when you cut and paste the contents of the cells, leaving
plain white blank cells behind?

Thanks in advance,

Mike
 
Not without using some code to store the formats then replace after the
cutting.

I have no code off the top of my head to do that.

Perhaps just copy and paste then come back and delete the contents.


Gord Dibben MS Excel MVP
 

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

How do I fix the background shading by position? 2
Copy/paste question 3
Why does "cut and paste" cause #REF! errors? 4
Cut and paste or Copy just cell contents? 1
I copied Visible Cells Only, but it pastes only the first cell 1
WORD 2007 CUT N PASTE NOT WORKING SAME PIC ALWAYS 2
Cut from one sheet, paste in another 2
Graph cutting - Excel cannot paste the data. 4

Back
Top