ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freezing Worksheet Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/94496-freezing-worksheet-tabs.html)

Colin Foster

Freezing Worksheet Tabs
 
Is it possible to freeze worksheet tabs so that, for example, Sheet 1 is
always visible & only Sheets 2 - 8 are scrolled through?

Regards
Colin Foster



Chip Pearson

Freezing Worksheet Tabs
 
As I understand your question, this is not possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Colin Foster" wrote in message
...
Is it possible to freeze worksheet tabs so that, for example,
Sheet 1 is always visible & only Sheets 2 - 8 are scrolled
through?

Regards
Colin Foster




Don Guillett

Freezing Worksheet Tabs
 
AFAIK, no but a good idea.

--
Don Guillett
SalesAid Software

"Colin Foster" wrote in message
...
Is it possible to freeze worksheet tabs so that, for example, Sheet 1 is
always visible & only Sheets 2 - 8 are scrolled through?

Regards
Colin Foster




Elkar

Freezing Worksheet Tabs
 
Nope, but I agree, that would be a handy feature.

But, you can Right-Click on the scroll arrows. This brings up a menu of
your first 15 sheets, plus an option to see entire list. You can then easily
select the first sheet in your workbook.

HTH,
Elkar


"Colin Foster" wrote:

Is it possible to freeze worksheet tabs so that, for example, Sheet 1 is
always visible & only Sheets 2 - 8 are scrolled through?

Regards
Colin Foster




Colin Foster

Freezing Worksheet Tabs
 
THanks for the response...

I have to admit that I didn't think that it was possible... but if you don't
ask... :-)

Thanks anyway
Regards
COlin


"Chip Pearson" wrote in message
...
As I understand your question, this is not possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Colin Foster" wrote in message
...
Is it possible to freeze worksheet tabs so that, for example, Sheet 1 is
always visible & only Sheets 2 - 8 are scrolled through?

Regards
Colin Foster






Gord Dibben

Freezing Worksheet Tabs
 
See one possible in your other posting


Gord Dibben MS Excel MVP

On Fri, 16 Jun 2006 22:59:50 +0100, "Colin Foster"
wrote:

Is it possible to freeze worksheet tabs so that, for example, Sheet 1 is
always visible & only Sheets 2 - 8 are scrolled through?

Regards
Colin Foster




All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com