Make Border Lines Stay during Cut & Paste of Cell Contents
 

Hi Experts,

Is there a way to make borderlines stay when cutting one or more cells
and pasting the selection in another part of the formatted sheet?

All cells in the range are filled white and have a border (automatic
width, black) around all sides. Currently, when cutting and pasting--
or simply dragging one or more selected cells--the destination cells
are formatted fine, but where the cells came from lack the
borderlines.

Thanks,
Eric

Make Border Lines Stay during Cut & Paste of Cell Contents
 

Hi Eric,

Not if you are doing this manually (no VBA). Using Cut removes all aspects
of the original cell. Your only option to leave the borders is to use
PasteSpecial Values and/or Formats, then select the original cells and
press the Delete key.

Alan

"The only dumb question is the question left unasked."


"Arnold" wrote in message
ups.com...
Hi Experts,

Is there a way to make borderlines stay when cutting one or more cells
and pasting the selection in another part of the formatted sheet?

All cells in the range are filled white and have a border (automatic
width, black) around all sides. Currently, when cutting and pasting--
or simply dragging one or more selected cells--the destination cells
are formatted fine, but where the cells came from lack the
borderlines.

Thanks,
Eric

Make Border Lines Stay during Cut & Paste of Cell Contents
 

I kind of thought so, but was hoping not. Bummer.

Any chance that the Ctrl X key command could be changed on a
particular worksheet to instead of cut---copy and then delete?

Thanks.

Make Border Lines Stay during Cut & Paste of Cell Contents
 

I don't believe there is a way to reassign Ctrl X. If the cell assignments
are repetitious, you could use a macro with a shortcut key assigned.



"Arnold" wrote in message
ups.com...
I kind of thought so, but was hoping not. Bummer.

Any chance that the Ctrl X key command could be changed on a
particular worksheet to instead of cut---copy and then delete?

Thanks.