Forum Discussion
Excel automatically filling in formulae
Hi, I am using Office 2021 on a new 2023 iMac running Sonoma (OS 14.1.2), having just transferred from using Office 2011 on a 2012 iMac. Office seems to be working OK on the Mac except for a very i...
Hi,
No one has replied to this, maybe I haven't made myself clear, so here is a procedure to reproduce what I'm on about:
1. Open a new spreadsheet
2. In cells A1 to A5 enter some numbers (any values will do)
3. In cell B2 enter =A1+A2
4. Drag the contents of B2 to fill down through to B5 using the cross handle on the lower-right corner of B2
5. Enter a number in cell A6
In Office 2011 for Mac, the formula =A5+A6 appears in cell B6, and it displays the result
In Office 2021 for Mac, cell B6 remains blank.
Note that the "auto-fill" doesn't work with fewer than 5 cells (e.g. A1 to A4).
I can't believe that such a useful facility has been discontinued - can anyone else reproduce this effect?
No one has replied to this, maybe I haven't made myself clear, so here is a procedure to reproduce what I'm on about:
1. Open a new spreadsheet
2. In cells A1 to A5 enter some numbers (any values will do)
3. In cell B2 enter =A1+A2
4. Drag the contents of B2 to fill down through to B5 using the cross handle on the lower-right corner of B2
5. Enter a number in cell A6
In Office 2011 for Mac, the formula =A5+A6 appears in cell B6, and it displays the result
In Office 2021 for Mac, cell B6 remains blank.
Note that the "auto-fill" doesn't work with fewer than 5 cells (e.g. A1 to A4).
I can't believe that such a useful facility has been discontinued - can anyone else reproduce this effect?