Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make the cursor stay in the cell when entering data. | Excel Discussion (Misc queries) | |||
how to inset a picture in a cell and make it stay in that cell | Excel Discussion (Misc queries) | |||
How to offset cell value from thick border lines? | Excel Discussion (Misc queries) | |||
How do I make the border of an active cell in Excel darker? | Excel Discussion (Misc queries) | |||
How do I make a picture stay inside a cell? | Excel Discussion (Misc queries) |