Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 226
Default How can I keep sheet tabs visible when I use split pane function?

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How can I keep sheet tabs visible when I use split pane function?

The sheet tabs are there in the left side of the split screen.

Select a cell in the middle of the window and WindowSplit.

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 WindowNew Window and Arrange to get two views, each
with sheet tabs.


Gord Dibben MS Excel MVP

On Tue, 2 Jan 2007 18:19:00 -0800, Roger
wrote:

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Could this be possible? shail Excel Worksheet Functions 9 September 13th 06 12:35 PM
Lookup function and compare Student Excel Discussion (Misc queries) 8 April 25th 06 03:11 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Sheet tabs disappear sometimes in Internet Explorer Jan Nordgreen Excel Discussion (Misc queries) 0 December 6th 04 01:34 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"