Cut and Paste without taking borders


J

Jack G

This has driven me nuts for years, and it seems so basic: I have a
spreadsheet with some borders around the outside of an area, and all I want
to do is say move a value from the upper right corner of the area to
somewhere in the middle. If I cut and paste, it not only takes the value,
but also removes the borders from the upper right cell and pastes them in
the middle cell, too. I don't want that! I just want to move the values.

So over and over I have to copy the cell, paste special, pick value only, go
back to the first cell and delete the contents. So many steps to do
something so basic!

Surely there's a simple way to do this that I've missed.

Thanks for any help.

Jack
 
Ad

Advertisements

G

Guest

Actually, you can click on the cell(s) that you want to move the contents,
right-click drag to receiving cell and drop, choose "Copy here as values
only" then go back to your original cell(s) to clear contents. I don't know
what to do about that last part but the drag/drop copy does speed things up.
 
G

Guest

A little less painful way is to left-click on the cell you wish to copy, then
go to the Formula Bar and highlight the value and Right-click > Cut. Then
Right-click and Paste to the cell you wish to receive te value.......

Vaya con Dios,
Chuck, CABGx3
 
J

Jack G

Thanks, that really is less painful - and it allows me to use plain old
ctl-x, ctl-c and ctl-v for editing.

Jack
 
J

Jack G

Thanks for your quick response. But I can't seem to get right-click drag to
work for me. I just get a shortcut menu as soon as I right-click.

Jack
 
G

Gord Dibben

Right-click on the edge of the cell, not on the cell.

You will see a four-headed arrow when you right-click on the edge. Drag that to
where you want.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

J

Jack G

Thanks, I get it now. This would be my complete answer if only it gave me
the choice of "Move Here with Values Only."

Jack
 

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 1
Cut & Paste 6
Cut and Paste 7
Cutting and Pasting 3
Automatic cut and paste 4
Cutting and pasting annoyance 3
Cut and paste issue 3
Cut and paste macro 1

Top