Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a cell = the sheet name?
How do I make a cell only display the name of the sheet? without writing e.g
"sheet1" Is there a formula such as =sheetname ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a cell = the sheet name?
File must be saved at least once for the formula to work...
Try in any cell =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) "adam" wrote: How do I make a cell only display the name of the sheet? without writing e.g "sheet1" Is there a formula such as =sheetname ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a cell = the sheet name?
Brilliant works like a charm, thanks for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a cell = the sheet name?
You are most welcome. Thanks for the feedback.
Try to get into the habit of using Google... it will save you time and teach new things... "adam" wrote: Brilliant works like a charm, thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make a cell mandatory in the excel sheet | Excel Worksheet Functions | |||
I need to make cell a1 on sheet 2 ALWAYS = a1 on sheet 1 | Excel Worksheet Functions | |||
In Excel, how do I make a cell equals the sheet name? | Excel Worksheet Functions | |||
Make a cell show the name of the sheet tab | Excel Worksheet Functions | |||
How do I make a cell reference to a sheet title name | Excel Discussion (Misc queries) |