Group: microsoft.public.excel.misc · Group Profile · Search for Larryn in microsoft.public.excel.misc
Author: LarryN
Date: Apr 9, 2008 14:54
If I'm assuming correctly that you are copying and pasting values from a preformatted sheet and don't want the formatting to move with the values, you can copy and instead of pasting, select "paste as . .", and paste as "value". If you are dragging for an auto fill effect, you will get a little box near the bottom of your destination cells. select that and you can choose "fill without formatting"
|