How do I insert the sheet name into a cell

J

Jelly

I cannot find a function that allows me automatically to insert the sheet
name into a cell within the sheet.
Grateful for any help.
 
R

Ryan Poth

Jelly,

Not exactly what you want, but it might get you closer.

=CELL("filename")

will return the path, file, and sheet names in one. You can then use a
string function to extract the sheet name from there.

HTH,
Ryan
 
J

Jelly

That's really useful. I would like to add the sh.name function you describe
but cannot find book.xlt or any similar Excel template (I'm running Office
XP). Can please let me know how/where I can do this?
Many thanks
 
B

Bob Phillips

Jelly,

There is a problem with your formula. Take a look at the link I posted to
see what and why.
 
B

Bob Phillips

Jelly,

Book.xlt does not necessarily exist and if it does, might be in different
locations on different machines.

If you don't have one, new a standard Excel workbook, make the changes you
want, and save it as an Excel template named Book.xlt.

Save it to the Office\XLStart directory, and check that that works.
 
B

Bob Phillips

Sorry, meant Ryan

--

HTH

RP

Bob Phillips said:
Jelly,

There is a problem with your formula. Take a look at the link I posted to
see what and why.

--

HTH

RP
Click to expand...
 
Top