S
sali
excel2000, when having multiple [2 or 4] panes on sheet [view is divided]:
a) range copy
making a range [active cell in one pane, shift+click on other pane], and
right click for copy, if mistakenly clicking the visible part of range on
other pane the range is disappearing. i must click range *only* in pane
having active cell!
is it true? may i adjust excel to allow me to click range in whatever pane
it is visible?
b) pane scroll
when scrolling a pane with mouse wheel, is it possible to have "mouseover"
effect, to scroll a pane mouse is over [like outlook express mail client is
doing], without having to click inside pane to select it for scrolling?
for these things to have workable, do i need to upgrade to some higher
excel?
thanks.
a) range copy
making a range [active cell in one pane, shift+click on other pane], and
right click for copy, if mistakenly clicking the visible part of range on
other pane the range is disappearing. i must click range *only* in pane
having active cell!
is it true? may i adjust excel to allow me to click range in whatever pane
it is visible?
b) pane scroll
when scrolling a pane with mouse wheel, is it possible to have "mouseover"
effect, to scroll a pane mouse is over [like outlook express mail client is
doing], without having to click inside pane to select it for scrolling?
for these things to have workable, do i need to upgrade to some higher
excel?
thanks.