G Graham Feb 9, 2009 #1 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
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
X xlmate Feb 9, 2009 #3 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
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
G Gord Dibben Feb 9, 2009 #4 If your Show Paste Options Icon is enabled, after you paste, select "Match destination formatting" Gord Dibben MS Excel MVP
If your Show Paste Options Icon is enabled, after you paste, select "Match destination formatting" Gord Dibben MS Excel MVP