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:
Go ahead and try it! :-) And if ever you edit the worksheet name, you'll find that the Excel formula gets automatically updated.
"Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!"
To Grab This Offer, Click Option Below:
Visit SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka
Get In Touch With Manuel Today
"Invest in yourself, before
others will invest in you."
-- Manuel Viloria
About Manuel Viloria