Search code examples
excelarray-formulas

'arrayformula' in Google Sheets vs. in Excel: autofill column

My old question: auto-fill one column without dragging - Google sheet and the formula =Arrayformula(if(row(A1:A5000), "ABC DEF",)) used good in Google Sheets.

Now, I use this formula in Excel, but it doesn’t work.

How can I fix this Excel formula?

Solution

  • It works exactly the same way in Excel 365 if you remove the Arrayformula wrapper:

    =if(row(A1:A5000), "ABC DEF",)

    You need to array-enter it in previous versions of Excel using CtrlShiftEnter