May 12 2021 04:12 AM
Hi,
I am wanting some help with a complex formula. I need to extend the formula to cover from 60 columns to 500 and the only way I can think of doing it is typing in the formula cell by cell. Is there another way that's less time consuming?
Appreciate any support!
Thanks, Taylah.
May 12 2021 06:01 AM
We cannot see the complete formula and we cannot see in which cell it is.
Could you attach a sample workbook?
May 12 2021 08:14 PM - edited May 12 2021 08:18 PM
if you can copy formulas down many rows by pulling the fill handle, i am sure that you can do the same for columns
Here's proof: