Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to extend a formula a loooong way down

Best of Excel

How to extend a formula a loooong way down

by  PepeLeMokko  Posted    (Edited  )
When you have to copy the same formula to a lot of contiguous cells, you can either drag the cell with the handle or paste the formula in a selected region.
An easy way ( if your region is very long) is to double-click the handle of the cell containing the formula.
It will extend automatically as long as ther aer values in the adjacent cells.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top