You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

ekirt5 Author

Level 1

5 points

Sheet name in a cell

How can I put the name of the sheet in a cell automatically?

Thank you!

iMac 27″ 5K, macOS 10.15

Posted on Jun 25, 2022 8:16 AM

Top-ranking reply

SGIII

Level 8

35,990 points

Posted on Jun 25, 2022 8:36 AM

If by "automatically" you mean by formula, then, yes, you can put a name in a cell that will change automatically when you change the name of the table or sheet.

For a sheet name in cell A2:

=TEXTBEFORE(REFERENCE.NAME(A2,2,reference-style),"::")

For a table name in cell A3:

=TEXTBETWEEN(REFERENCE.NAME(A3,2,reference-style),"::","::")

(use ; instead of , in the formulas if your region uses , as a decimal separator)

View in context

Sheet name in a cell

Similar questions