View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Drag formulas, not formating

Copy the cell with formula.
Selec the range to be copied
Right clickPasteSpecial
Select Formulas
Click OK
--
If this post helps click Yes
---------------
Jacob Skaria


"Wavequation" wrote:

I am trying to drag formulas across rows and columns in a table, but I don't
want the formating to be dragged also. Can I drag only formulas, and not
borders?