Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane: freeze from two worksheets?
is it possible that when you freeze panes, the left part frozen is the part
from let's say "worksheet 1), but then the left part is from any worksheet you click? i'm doing a summary which involves categories, so i had to make different worksheets for it. however, the items is always from the same worksheet 1. if i put on the same items on each worksheet, and next time i update, either i update every item on every worksheet or i forget to update them and just update worksheet 1.... any help on this? willing to do macros and others.... thanks a lot in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane: freeze from two worksheets?
Maybe WindowNew Window.
WindowArrangeVertical This will give you two windows side by side and you can have the right hand window be worksheet1 and the left hand window be any sheet you click on. Gord Dibben MS Excel MVP On Sat, 24 May 2008 01:33:00 -0700, Chris wrote: is it possible that when you freeze panes, the left part frozen is the part from let's say "worksheet 1), but then the left part is from any worksheet you click? i'm doing a summary which involves categories, so i had to make different worksheets for it. however, the items is always from the same worksheet 1. if i put on the same items on each worksheet, and next time i update, either i update every item on every worksheet or i forget to update them and just update worksheet 1.... any help on this? willing to do macros and others.... thanks a lot in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane: freeze from two worksheets?
well,i was hoping for something else.... the instructions below only allows
me to view two windows at the same time, but will not scroll down together, or print all contents of the left window with the contents of the right window..... what i'm envisioning right now is that i only make a list of items on worksheet 1, and all the left side (which are the items), will be visible even when i print other worksheets.... sort of like a header/ footer, but on the left side... "Gord Dibben" wrote: Maybe WindowNew Window. WindowArrangeVertical This will give you two windows side by side and you can have the right hand window be worksheet1 and the left hand window be any sheet you click on. Gord Dibben MS Excel MVP On Sat, 24 May 2008 01:33:00 -0700, Chris wrote: is it possible that when you freeze panes, the left part frozen is the part from let's say "worksheet 1), but then the left part is from any worksheet you click? i'm doing a summary which involves categories, so i had to make different worksheets for it. however, the items is always from the same worksheet 1. if i put on the same items on each worksheet, and next time i update, either i update every item on every worksheet or i forget to update them and just update worksheet 1.... any help on this? willing to do macros and others.... thanks a lot in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane: freeze from two worksheets?
No way to do what you want as far I know without copy/pasting the data columns
from sheet 1 to the left of data on other sheets then freezing those columns. Gord On Sun, 25 May 2008 23:30:01 -0700, Chris wrote: well,i was hoping for something else.... the instructions below only allows me to view two windows at the same time, but will not scroll down together, or print all contents of the left window with the contents of the right window..... what i'm envisioning right now is that i only make a list of items on worksheet 1, and all the left side (which are the items), will be visible even when i print other worksheets.... sort of like a header/ footer, but on the left side... "Gord Dibben" wrote: Maybe WindowNew Window. WindowArrangeVertical This will give you two windows side by side and you can have the right hand window be worksheet1 and the left hand window be any sheet you click on. Gord Dibben MS Excel MVP On Sat, 24 May 2008 01:33:00 -0700, Chris wrote: is it possible that when you freeze panes, the left part frozen is the part from let's say "worksheet 1), but then the left part is from any worksheet you click? i'm doing a summary which involves categories, so i had to make different worksheets for it. however, the items is always from the same worksheet 1. if i put on the same items on each worksheet, and next time i update, either i update every item on every worksheet or i forget to update them and just update worksheet 1.... any help on this? willing to do macros and others.... thanks a lot in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane: freeze from two worksheets?
oh, well... thanks man. toobad this isn't possible.hehehe.
"Gord Dibben" wrote: No way to do what you want as far I know without copy/pasting the data columns from sheet 1 to the left of data on other sheets then freezing those columns. Gord On Sun, 25 May 2008 23:30:01 -0700, Chris wrote: well,i was hoping for something else.... the instructions below only allows me to view two windows at the same time, but will not scroll down together, or print all contents of the left window with the contents of the right window..... what i'm envisioning right now is that i only make a list of items on worksheet 1, and all the left side (which are the items), will be visible even when i print other worksheets.... sort of like a header/ footer, but on the left side... "Gord Dibben" wrote: Maybe WindowNew Window. WindowArrangeVertical This will give you two windows side by side and you can have the right hand window be worksheet1 and the left hand window be any sheet you click on. Gord Dibben MS Excel MVP On Sat, 24 May 2008 01:33:00 -0700, Chris wrote: is it possible that when you freeze panes, the left part frozen is the part from let's say "worksheet 1), but then the left part is from any worksheet you click? i'm doing a summary which involves categories, so i had to make different worksheets for it. however, the items is always from the same worksheet 1. if i put on the same items on each worksheet, and next time i update, either i update every item on every worksheet or i forget to update them and just update worksheet 1.... any help on this? willing to do macros and others.... thanks a lot in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze pane for more than one row anyone??? | Excel Discussion (Misc queries) | |||
Freeze Pane Saving | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions | |||
Freeze pane | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions |