| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet (tab names) in cells
Using a formula, is there a way to display worksheet (tab names) in a cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1 in each woksheet, I would want to see the worksheet name for whichever worksheet I am viewing. I do not want the name to change in the cell each time I click on one of the other two spreadsheets, similar to what happens with =CELL("FILENAME"). I also do not want to see the entire path for the worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Names | Excel Discussion (Misc queries) | |||
| Associating Tab Names to Cells | Excel Discussion (Misc queries) | |||
| How to name cells using same name yet specific to worksheet in Exc | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
