Cut and paste or Copy just cell contents?

  • Thread starter Thread starter Tom Meacham
  • Start date Start date
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
 
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

Locking the background so it's not wiped by cut-n-paste 2
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Cut & Paste in Excel without erasing cell borders? 1
Cut and Paste Stopped Working 2
Pasting Cells in Excel - Not copying all content 1
Formatting cells 2
pasting with filter results into sequentual cells not same row? 1
Cut and Paste issues 4

Back
Top