Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock the fill color in a cell
I want to fill a cell with a colour but still be able to copy to that cell
without the fill changing. Is this possible. Thank You |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock the fill color in a cell
Use EditPasteSpecial/Values
Regards, Stefi €˛Graham€¯ ezt Ć*rta: I want to fill a cell with a colour but still be able to copy to that cell without the fill changing. Is this possible. Thank You |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock the fill color in a cell
try
Paste Special Under Paste in the dialog box, tick Value HTH -- Pls provide your feedback by clicking the Yes button below if this post have help you. This will help others to search the archives for result better. Thank You cheers, francis "Graham" wrote: I want to fill a cell with a colour but still be able to copy to that cell without the fill changing. Is this possible. Thank You |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock the fill color in a cell
Graham;220515 Wrote: I want to fill a cell with a colour but still be able to copy to that cell without the fill changing. Is this possible. Thank YouSimply copy the cell you want right click the destination cell Paste SpecialValues the format of the cell will remain unchanged. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60700 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I lock the fill color in a cell
If your Show Paste Options Icon is enabled, after you paste, select "Match
destination formatting" Gord Dibben MS Excel MVP On Mon, 9 Feb 2009 02:56:00 -0800, Graham wrote: I want to fill a cell with a colour but still be able to copy to that cell without the fill changing. Is this possible. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I lock the fill color in a cell | Excel Worksheet Functions | |||
How do I fill one cell color with text html/rgb color from another | Excel Discussion (Misc queries) | |||
I need to lock cell color, but allow text - how do I do this? | Excel Discussion (Misc queries) | |||
Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
Lock or Unlock cell references in a formula for auto fill purposes | Excel Discussion (Misc queries) |