Cut and paste or Copy just cell contents?

T

Tom Meacham

I want to be able to cut and paste or move just the cell contents without
moving or erasing the cell lines and colors. I have a worksheet that from
time to time a whole row of data is deleted and I would like to then move
the rest of the data up but then the cell borders and colors move and leave
behind dlanks that need to be reformatted. Thanks
 
D

Dave O

After you copy a cell to the clipboard, move the pointer to an open
cell and right-click. Choose >Paste Special and select >Values only.
This will paste the value only with no formatting. Note the other
Paste Special options- they may be useful for you too, either now or
later.
 

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

Cut & Paste in Excel without erasing cell borders? 1
Merge Cell Cut & Paste 1
Cut and Paste issues 4
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Find Cut and paste 4
Excel 2007 - Macro to do a simple cut/paste operation. 2
Disappearing cell contents 1
Move cell contents with macro 4

Top