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

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!
 
G

Gord Dibben

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

Tabs accross of bottom of sheet are not showing 3
How can I "re-hook" my worksheet window to my Excel window? 1
two-fold problem 3
Sheet tabs not showing - 2003 5
Why do sheet tabs keep disappearing? Box in Tools is checked. 1
Autofilter changes frozen pane 1
Hidden Tabs keep appearing once workbook is reopened. 4
how do i make sheet tabs look veritical 5

Top