# Formula Extension

Occasional Visitor

# Formula Extension

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.

2 Replies

# Re: Formula Extension

We cannot see the complete formula and we cannot see in which cell it is.

Could you attach a sample workbook?

# Re: Formula Extension

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: