Make Border Lines Stay during Cut & Paste of Cell Contents

[Arnold]

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

 

[Alan]

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]

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.

 

[Alan]

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.