Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating the color and border of a cell and then copy numbers int
i receive check reports from my customer with certain cells that are shaded
and that have borders around them. then i inspect the part and output the results to throw into their form....i always have to go back and re shade the specific cell back to yellow after cutting and pasting into their form...any way to keep the cell borders and shading on their original form after i cut and paste into it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating the color and border of a cell and then copy numbers int
Use PasteSpecial/Values instead of Paste!
Regards, Stefi €˛CruSTEEL45€¯ ezt Ć*rta: i receive check reports from my customer with certain cells that are shaded and that have borders around them. then i inspect the part and output the results to throw into their form....i always have to go back and re shade the specific cell back to yellow after cutting and pasting into their form...any way to keep the cell borders and shading on their original form after i cut and paste into it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the format/cell/border/automatic color to black | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
color formating ontingenton upon another cell? | Excel Discussion (Misc queries) | |||
How do you change the color of the cell hi-lite border | Excel Worksheet Functions |