ExcelBanter - Cut and paste line filled with colour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cut and paste line filled with colour (https://www.excelbanter.com/excel-discussion-misc-queries/186320-cut-paste-line-filled-colour.html)

slavenp

Cut and paste line filled with colour

How do you cut and paste information into a line that has been filled with
colour.

I would like the background colour to remain rather than turn white when I
past in information.

Thanks.

Max

Cut and paste line filled with colour

Use Paste special as values
Click Edit Paste special Values OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"slavenp" wrote:
How do you cut and paste information into a line that has been filled with
colour.

I would like the background colour to remain rather than turn white when I
past in information.

Thanks.

All times are GMT +1. The time now is 05:21 PM.