Drag formulas, not formating
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? |
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? |
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? |
All times are GMT +1. The time now is 07:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com