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.

[an error occurred while processing this directive]

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:


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!

Panuorin Mo Ito...

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

Get In Touch With Manuel Today

  Previous Entry
  Next Entry

Secondthoughts @ Viloria.com
Manuel Viloria

About Manuel Viloria
Contact Us
Privacy Statement
RSS Feed

Google Reader

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