Forum Discussion

Taylah's avatar
Taylah
Copper Contributor
May 12, 2021

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.

BI & Data Analysis
excel
Formulas and Functions

2 Replies

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    May 12, 2021

    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:

     

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 12, 2021

    Taylah 

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

    Could you attach a sample workbook?