How can I keep sheet tabs visible when I use split pane function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the tools, options, show tabs selected but whren I freeze panes in
excell, the tabs disappear. I want them to remain visible. Need help!
 
The sheet tabs are there in the left side of the split screen.

Select a cell in the middle of the window and Window>Split.

A truncated set of the sheet tabs are visible at lower left.

If you move the split to the left you will see fewer or no sheet tabs.

What are you attempting to achieve?

You may do better using Window>New Window and Arrange to get two views, each
with sheet tabs.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any way to get Freeze Panes to work with Split View? 2
Excel loses "Freeze Panes" setting 1
Autofilter changes frozen pane 1
Open Workbook with Multiple Windows 5
Freeze Pane Macro 1
Freeze Pane Saving 10
How do I freeze/ unfreeze a window pane in Excel 2007? 2
How can I "re-hook" my worksheet window to my Excel window? 1

Back
Top