Thanks for the clarification Mike - I was pretty sure that was the answer but need to check (works like a dream on my Office 365 desktop version).
To be honest, I was asking for a friend who's recently upgraded from Excel 2010 to v2017-ish. He's tried this and it still doesn't work in his version. Could there be something else he needs to do?