freeze layout
 

is there any way to just freeze layout of cells etc (border shading) while
you can still drag down (copy) formulas etc

Thanks,

W

freeze layout
 

Instead of dragging (which causes a complete copy), do a normal copy, select
the destination cell(s), then right-click, paste special, formulas only.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"willem" wrote:

is there any way to just freeze layout of cells etc (border shading) while
you can still drag down (copy) formulas etc

Thanks,

W