| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Worksheet tab name in cell
I currently use both Excel 97 & Excel XP, is there a way by formula to
include the worksheet tab name in a cell similar to &[tab] in the header/footer? -- Mark |
|
#2
|
|||
|
|||
|
use:
=RIGHT(CELL("filename"),6) but change the 6 to match the length of your tab name. Have a good day -- Gary''s Student "Mark" wrote: I currently use both Excel 97 & Excel XP, is there a way by formula to include the worksheet tab name in a cell similar to &[tab] in the header/footer? -- Mark |
|
#3
|
|||
|
|||
|
See
http://www.xldynamic.com/source/xld.xlFAQ0002.html HTH "Mark" wrote: I currently use both Excel 97 & Excel XP, is there a way by formula to include the worksheet tab name in a cell similar to &[tab] in the header/footer? -- Mark |
|
#4
|
|||
|
|||
|
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips "Mark" wrote in message ... I currently use both Excel 97 & Excel XP, is there a way by formula to include the worksheet tab name in a cell similar to &[tab] in the header/footer? -- Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| I need to return the name of a worksheet in another worksheet cell? | Excel Worksheet Functions | |||
| How can I link a cell in one worksheet to a cell in another works. | Excel Worksheet Functions | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Hybrid Mode
