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.
Panuorin Mo Ito...
Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka
Get In Touch With Manuel Today
About Manuel Viloria