Limitation in fast-filling (replenish)?

Copper Contributor



I use Excel both on my laptop (Office 365) and on my Android phone (official Excel app).
I have this file with a long list of items. For example item 1 to item 175. Below this list I can type just the first 1 or 2 letters and Excel will come up with a list I can choose from (fast-fill).

Now on my phone, this also works, but partially. Excel only look at the 100 rows just above the cell I'm typing in. So item 1-74 is not taken in account.
When I insert items 1-74 below the list, I get results from those items and items 149-175. The items 75-148 are not included in the fast-fill (replenish?) list in Excel.

Is this a limitation in the Excel app?



0 Replies