Dragging data without changing cell borders

C

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
 
D

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.
 
E

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
-------------------------------------------

David McRitchie said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"[email protected]" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
D

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Earl Kiosterud said:
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
-------------------------------------------

David McRitchie said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"[email protected]" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
Click to expand...
 
Top