How to show the title on upper-left corner in a spreadsheet

In default, the spreadsheet sheet directly shows the title of the sheet on the left lower corner as a tab. Could any guru please show me how to show it on left-upper corner as a single page. Thanks.
jl66Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
upper left corner mean Cell A1 ?
gowflow
0
gowflowCommented:
Put this formula in A1 and you will get the tab name of the actual sheet in Cell A1

=MID(CELL("filename",A1),SEARCH("]",CELL("filename"))+1,31)

Open in new window


gowflow
0
jl66Author Commented:
Thanks for the info. However, what I wanted is the title in top-left page, but not in any cell. I tried to draw it

The default:
------------------------
|   Cells                |
|                           |
|                           |
...
|                           |
------------------------
- - -                                   <- title here

============================================
Want:
------------------------
|-                          |          <-title here                  
------------------------
|  Cells                 |
|                           |
|                           |
...
|                           |
-------------------------
 
I saw it, but just don't know how to get there. It should be a few clicks to get there.
0
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

gowflowCommented:
You mean you want to show the sheet tab on top of the columns not under ?
gowflow
0
jl66Author Commented:
Yes. However, it does not seem that the full tabs of sheet titles can show on the top. What i saw/wanted is that the title shows on a sheet and no title tabs under.   Thanks
0
jl66Author Commented:
Revision: "What i saw/wanted is that the title shows on the TOP of a sheet and no title tabs under."
0
gowflowCommented:
Is this what you want ?
I kept the Sheet Tab showing so you can click on any sheet and see its name appear on the window.
What you asked is to hide the sheet names but then how would you select the sheets ?? thru VBA ?

gowflow
SheetCaption.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jl66Author Commented:
Very sorry I passed the wrong info. On the sheet top-left corner, it shows the spreadsheet file title (not the sheet title like Sheet1). For example, I have a file called test.xlsx and it will show on the top left corner of the sheet without the Sheet title tabs.
I could not test the SheetCaption.xlsm here.
0
gowflowCommented:
I could not test the SheetCaption.xlsm here.

What do you mean why you could not test it ? You need to activate macros to test it.
gowflow
0
jl66Author Commented:
Thanks a lot.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.