Original cell formatting clears when I move contents

  • Thread starter Thread starter LarryN
  • Start date Start date
L

LarryN

Whenever I move the contents of a cell, the formatting (e.g., borders) of the
original cell clears. How do I stop this from happening? I'm using Excel 2007
but it also happens in 2003.

Thanks
 
If I'm assuming correctly that you are copying and pasting values from a
preformatted sheet and don't want the formatting to move with the values, you
can copy and instead of pasting, select "paste as . .", and paste as "value".
If you are dragging for an auto fill effect, you will get a little box near
the bottom of your destination cells. select that and you can choose "fill
without formatting" to transfer only the values.
 
Thanks for the reply, but it's the formatting in the call that I'm cutting
values FROM that is getting changed. e.g., if I have a border around a cell
and then move the content of that cell somewhere else, the border on the
original cell goes away. I'd like it to stay.

- Larry
 

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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Formatting cells 2
Excel 2007 - A Conditional Formatting ?'s 1
combine cells with different formats 4
Excel Data pastes into 2 cells not 1 1
Clear a cell's contents when document is saved 2
Printing with cell borders 1
Locking Excel cell formating and editing, copying and pasting cont 3

Back
Top