| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split screen
Is it possible to have rows at the top and bottom of the screen remain static
and rows inbetween that scroll? -- Regards Tom G |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Split screen
No - Excel will allow you to freeze rows at the top and columns at the left -
but that is it. "Black87Bird" wrote: Is it possible to have rows at the top and bottom of the screen remain static and rows inbetween that scroll? -- Regards Tom G |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Split screen
Not without adding a window.
Top window can contain static row(s) using WindowFreeze Panes. Bottom window can contain the row(s) to remain static at bottom. Gord Dibben MS Excel MVP On Wed, 20 Aug 2008 11:44:34 -0700, Black87Bird wrote: Is it possible to have rows at the top and bottom of the screen remain static and rows inbetween that scroll? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Split screen
Nor sure how to add a window, a advise?
-- Regards Tom G "Gord Dibben" wrote: Not without adding a window. Top window can contain static row(s) using WindowFreeze Panes. Bottom window can contain the row(s) to remain static at bottom. Gord Dibben MS Excel MVP On Wed, 20 Aug 2008 11:44:34 -0700, Black87Bird wrote: Is it possible to have rows at the top and bottom of the screen remain static and rows inbetween that scroll? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Split screen
Sorry, sat and though about opening another window for a minute and realized
what you were saying. Thanks, that should work well. -- Regards Tom G "Black87Bird" wrote: Nor sure how to add a window, a advise? -- Regards Tom G "Gord Dibben" wrote: Not without adding a window. Top window can contain static row(s) using WindowFreeze Panes. Bottom window can contain the row(s) to remain static at bottom. Gord Dibben MS Excel MVP On Wed, 20 Aug 2008 11:44:34 -0700, Black87Bird wrote: Is it possible to have rows at the top and bottom of the screen remain static and rows inbetween that scroll? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Split screen
WindowNew Window.
WindowArrangeHorizontal. Adjust window sizes to suit. Gord On Wed, 20 Aug 2008 14:48:01 -0700, Black87Bird wrote: Nor sure how to add a window, a advise? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split Screen in VBA Editor | Excel Discussion (Misc queries) | |||
| split screen | Excel Discussion (Misc queries) | |||
| What is the difference between split screen and freeze? | Excel Discussion (Misc queries) | |||
| HOW DO i UNDO A SPLIT SCREEN | Excel Discussion (Misc queries) | |||
| Split Screen | Excel Worksheet Functions | |||
Linear Mode
