| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How Do I insert the Worksheet Name in Cell A1 ?
Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
|
#2
|
|||
|
|||
|
How Do I insert the Worksheet Name in Cell A1 ?
=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$ A$1))-FIND("]",CELL("filename",$A$1)))
Insert this formula exactly. Just copy and paste this formula, and don't change a thing. Most people are tempted to insert the filename where it says "filename" but leave it exactly like it is. "robertguy" wrote: Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
|
#3
|
|||
|
|||
|
How Do I insert the Worksheet Name in Cell A1 ?
Oh and FYI this only works if you've saved the file at least once.
"Sloth" wrote: =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$ A$1))-FIND("]",CELL("filename",$A$1))) Insert this formula exactly. Just copy and paste this formula, and don't change a thing. Most people are tempted to insert the filename where it says "filename" but leave it exactly like it is. "robertguy" wrote: Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
|
#4
|
|||
|
|||
|
How Do I insert the Worksheet Name in Cell A1 ?
in cell A1 type =cell("filename") - don't put the actual filename in and do
include the "s. "robertguy" wrote: Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you reference a cell that is sorted in excel 2002? | Excel Worksheet Functions | |||
| How to use a cell value to reference a worksheet name | Excel Worksheet Functions | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
Hybrid Mode
