| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing worksheet tabs
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Freezing worksheet tabs
Colin
Not really. You might try WindowNew Window and WindowArrangeVertical. 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 On Fri, 16 Jun 2006 22:51:02 +0100, "Colin Foster" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Freezing worksheet tabs
hi,
Not exactly sure what you mean by "as normal" but try this.... on the tool bar click Windownew window then on the tool bar click windowcompare 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 "Colin Foster" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeat rows for add'l pages for tabs on a multi-tab worksheet | Excel Worksheet Functions | |||
| Worksheet tabs on multiple lines? | Excel Worksheet Functions | |||
| Transfer "Tabs name" to a worksheet | Excel Discussion (Misc queries) | |||
| Worksheet Tabs | Excel Discussion (Misc queries) | |||
| A "Document Map" of worksheet tabs for Excel | Setting up and Configuration of Excel | |||
Hybrid Mode
