Dragging data without changing cell borders

[Colin.Gibson]

Does anyone know how to drag data only from one cell to
others, without dragging borders, colours, etc. so I don't
have to go back and fix up all the borders and colours
again? Is there a simple setting which allows dragging of
data to be done where only the data is dragged?
Colin Gibson

 

[David McRitchie]

Hi Colon,
Assuming you have text values and not formulas.

Rather than dragging you could copy (ctrl+C) or Cut (Ctrl+X)
and then Edit, Paste Special, Values

If you have numbers or formulas you would have to paste formula,
and format separately.

 

[Earl Kiosterud]

David,

I'm not sure I understand what you're saying. Paste Special - Values works
with numbers or text, and leaves the destination formatting intact. For a
formula, similarly, you can use Paste Special - Formulas.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Hi Colon,
Assuming you have text values and not formulas.

Rather than dragging you could copy (ctrl+C) or Cut (Ctrl+X)
and then Edit, Paste Special, Values

If you have numbers or formulas you would have to paste formula,
and format separately.


"(e-mail address removed)" <[email protected]> wrote in

message news:[email protected]...

 

[David McRitchie]

Sorry, I realized that pasting values would not be what was wanted if there
were formulas also involved. The two would have to be done separately
-- paste special constants
-- paste special formulas.