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...