View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default Drag formulas, not formating

Right-mouse drag the fill handle, then select "Fill without formatting" when
you let go of the right-mouse
Bob Umlas
Excel MVP

"Wavequation" wrote in message
...
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?