Freezing worksheet tabs

  • Thread starter Thread starter Colin Foster
  • Start date Start date
C

Colin Foster

Hi All, looking for wisdom,

Is it possible to freeze a worksheet tab so that Sheet 1 is always visible,
whilst 2 - 6 can be scrolled through "as normal"?

Regards
Colin Foster
 
Colin

Not really.

You might try Window>New Window and Window>Arrange>Vertical.

This will give two windows.

You can leave the first one on sheet1 and scroll through 2-6 in the other
window.


Gord Dibben MS Excel MVP
 
hi,
Not exactly sure what you mean by "as normal" but try this....
on the tool bar click Window>new window
then on the tool bar click window>compare side by side
this will split the screen and show the same file in two windows. you can
keep sheet one in one window and scroll through the tabs on the other.

regards
FSt1
 

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

Freezing Worksheet Tabs 5
PowerPoint Freeze animation 1
Freezing Sheet Tab 2
Freeze Pane Macro 1
When sharing, can I force an Excel document to open in a certain view? 0
Hide or Freeze 3
Freeze Worksheet Tabs Excel 2000 1
Freeze Sections and column in a worksheet 3

Back
Top