ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Locking in" a cell color (https://www.excelbanter.com/excel-discussion-misc-queries/142788-locking-cell-color.html)

Sam

"Locking in" a cell color
 
Hello:

Whenever I cut and paste a colored cell to another location, it always takes
the cut cell color with it, and leaves a barren white hole where there once
was color. Drives me crazy.

Search didnt turn up any posts on how to prevent this. Is there a solution?

Thx to anyone who takes the time to respond!

sam

Jim Rech

"Locking in" a cell color
 
Cut & Paste is being true to its name. Your other option is Copy & Paste &
clear the source cell.

--
Jim
"sam" wrote in message
...
| Hello:
|
| Whenever I cut and paste a colored cell to another location, it always
takes
| the cut cell color with it, and leaves a barren white hole where there
once
| was color. Drives me crazy.
|
| Search didn't turn up any posts on how to prevent this. Is there a
solution?
|
| Thx to anyone who takes the time to respond!
|
| sam




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com