Dragging Down to Automatically Update

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

Hi. I have a spreadsheet with about 10 columns and many varied
formulas. If I want all of the formulas to automatically update when
data is inputted elsewhere, I have to drag down the formulas for 500
or 1000 cells so I won't have to mess with it for a while.

Is there another way to do this without having to drag down every
column?

Just curious, thanks.

Junior
 
Hi
you may change the formulas to something like
=IF($A1="","",your_existing formula)
 
Hi. What will this formula do? I have similar formulas in my
existing ones, but I still have to drag the cells down so they'll
automatically update. Thanks.
 
Hi
best way: post examples of your existing formulas. Easier to provide
specific answers for you. The formula I provided to you was just a
general approach how to hide a formula if an adjacent column has no
entries
 
Back
Top