Forum Discussion
Excel formulas starting to include current sheet name
Hi I recently noticed that formulas in excel starting to automatically include the "current" sheet name after leaving and coming back to the sheet (example below). I don't remember this used to be ...
I see no link between your answer and NoEggsInBasket's question. I think there is confusion with another question.
You’re absolutely right regarding Excel’s behavior — and thank you for pointing that out.
I realize my previous reply mixed in content from a different discussion (about Text to Columns), which is unrelated to this question. Apologies for the confusion there.
Your explanation about selection order and sheet switching is correct and aligns with how Excel builds formulas:
If you start on the current sheet → Excel omits the sheet name
If you return to it after selecting another sheet → Excel includes it
Thanks again for the clarification.