| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shading behavior not understood.
I have a worksheet I inherited from someone that I am modifying. They took
this format from somewhere and don't understand the nuances of it. The area that is being used for data is white surrounded by the rest of the sheet that is dark green. When I cut cells and paste them somehere else, the cut cells become green. I need to use the format painter to restore them to white. What is causing the cut cells to take on the color that is the same as the surrounding cells. I'm thinking that this sheet has some 'background' color set or something but I can't find out how. Thanks for any pointers, John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell shading behavior not understood.
Hi,
Copy and paste will copy the background colour so use copy (CTRL+c) then edit|Paste special select either values or formulas OK Mike "DocBrown" wrote: I have a worksheet I inherited from someone that I am modifying. They took this format from somewhere and don't understand the nuances of it. The area that is being used for data is white surrounded by the rest of the sheet that is dark green. When I cut cells and paste them somehere else, the cut cells become green. I need to use the format painter to restore them to white. What is causing the cut cells to take on the color that is the same as the surrounding cells. I'm thinking that this sheet has some 'background' color set or something but I can't find out how. Thanks for any pointers, John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell shading behavior not understood.
Or copy from the formula wiindow instead of the cell. When you copy from the
formula bar/window you only get the cell contents, not the format. "Mike H" wrote: Hi, Copy and paste will copy the background colour so use copy (CTRL+c) then edit|Paste special select either values or formulas OK Mike "DocBrown" wrote: I have a worksheet I inherited from someone that I am modifying. They took this format from somewhere and don't understand the nuances of it. The area that is being used for data is white surrounded by the rest of the sheet that is dark green. When I cut cells and paste them somehere else, the cut cells become green. I need to use the format painter to restore them to white. What is causing the cut cells to take on the color that is the same as the surrounding cells. I'm thinking that this sheet has some 'background' color set or something but I can't find out how. Thanks for any pointers, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange Cell Format Behavior | Excel Discussion (Misc queries) | |||
| odd behavior when referencing a cell on another sheet | Excel Discussion (Misc queries) | |||
| is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
Linear Mode
