Worksheet tab name in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
use:

=RIGHT(CELL("filename"),6)

but change the 6 to match the length of your tab name.

Have a good day
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Name a worksheet tab based on the value in a cell. 1
Worksheet tab name 12
Linking Tab/worksheet names to a worksheet cell 3
Sum Worksheets 7
Headers & Footers _auto update info from a cell in the worksheet 4
Array 3
Protected Worksheet Tab Order 1
TABS formula Is This Possible & How 2

Back
Top