Formula to Insert Sheet Name in Excel

How to insert the Sheet Name into cell in Excel, using a formula is explained in this video.

Subscribe to the channel for more

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

#ExcelTrick #ExcelTip #InsertSheetName

[arunkhanal]

Ajay,
My formula for the same purpose doesn't contain any Cell Reference

=RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]", CELL("filename")))

Analysis:
LEN(CELL("filename") Gives the entire length of File Path, File name and Sheet name
FIND("]", CELL("filename")) Gives the position of "]" from the very first Position
LEN(CELL("filename"))-FIND("]", CELL("filename")) Gives the Length of Sheet Name situated in the extreme right
Finally the RIGHT function extract the Sheet name only

[adriellowe]

Thanks this is exactly what I was looking for and worked perfectly first time.

[subhasisg]

very interesting video. Tried and worked. Very lucidly explained. I have a query can I create a power query or something similarly easier (not a big macro or vb code) while will add the firt column in every sheet with the sheet name?

[DhruvGoswamiOfficial]

Cell formala giving blank cell in excel 2013

[msaikat]

Use Right instead of mid... Don't need to worry about maximum sheet name character

[pallaviagnihotri]

Good work. but my point is how do to you display name of all sheets in various cells like in your case Tony in A1, Hana in A2 and so on

[sweetmask]

Hey how about if it's vice versa?

Like the name of the sheet can be changed through cell data

[morrisonka]

Excellent explanation, Sir !
You are the Champion !!!💜💜💜

[erikguzik]

Thanks so much. I forgot how to do this procedure. Great demo. You would think with all the new functions in Office 365 there would be a function =WorkSheetName(). yes i know you can write a macro to do that, but if you don't want a macro on a project, then you have to do all this.

[prathu]

Hi, i need a help here. i want to change the names of the sheets, when i type the name in a specific column from another sheet.

[jokerstudio]

Can we enter a name in specific field in 1sheet (I, e table of contents) and which is turned to name of subsequent sheets possible??🙏

[NaveenKumar-sclq]

Hello Sir can you please help me out ? Same in Google spreadsheet? Can we take sheet names from cell reference using vlookup importrange function?

[micha-elvanluijtelaar]

Thanks for the video. In some countries the formula is somewhat different as it uses ";" instead of a comma (", "). This causes all the errors

[SANCYSHERLY]

How we can enter same sheet name in another

[shilpakadam]

how to change the data series names to sheet name?

[gudashravya]

Hi Ajay
I want to extract the last sheet name of the excel directly.
Is it possible or not? Can you please help.

[mehulmehta]

HELLO AJAY SIR
MERI sheet name suppose koi date 01-04-2021 he. aur me jab sheet copy and move karu to sheet change hoke 02-04-2021 honi chahiye to kaise kare? plz help

[Mallikarjun]

Not working for sheet name is combination of letters & number... Is any other method. ...

[shantirajcompletebusinesss]

if sheet name is in date formate then?

[maglerdon]

This method works, but recently (as of 11/1/2022) it's causing circular reference errors in my workbook. Which is weird, because I've used this method for months without issue. I'm not sure if something changed in the way Excel works, but it's really annoying getting circular reference errors just because I'm trying to use a formula to dynamically return the sheet name.