Excel Tip: Display Worksheet Names

I was printing an MS Excel spreadsheet with numerous tabs (or worksheets), and was wondering how to display the tab or worksheet name inside a cell.

This way, when someone is reading the printout, we can easily identify which worksheet they're looking at. It makes editing or correcting spreadsheets easier, especially when you start to have over 30 worksheets in just one spreadsheet, and you're using cryptic or short tab names.

Step 1: Save your spreadsheet. Your file has to have a file name.

Step 2: Copy the following formula as-is into the cell where you want the worksheet name displayed:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Go ahead and try it! :-) And if ever you edit the worksheet name, you'll find that the Excel formula gets automatically updated.
[ First posted on 10/26/2008 by Manuel Viloria ]



Do you LIKE this page? Please let us know, and we will publish more of the content that YOU want. Salamat po!


"Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!"

To Grab This Offer, Click Option Below:

Truly Rich Club Philippine Residents Click Here

Truly Rich Club International Residents Click Here



Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka

Get In Touch With Manuel Today
Manuel@Viloria.net



  Previous Entry
  Next Entry




Secondthoughts @ Viloria.com
"Invest in yourself, before
others will invest in you."
-- Manuel Viloria


Viloria.com
About Manuel Viloria
Secondthoughts
Archives
Angelhouser
Contact Us
Privacy Statement
RSS Feed


Google Reader


Copyright © 1996 - 2015 by Viloria.com All Rights Reserved.