Can you move two parts of one worksheet independently of another .

[Guest]

I want to be able to move two halves of one worksheet independently of each
other. I.e. I have data in A-N and more data in O-U, and want to scroll them
at different rates. Right now, I am spending a lot of time scrolling up nad
down and cutting and pasting...

Any ideas would be appreciated.

 

[Dave Peterson]

I think that the closest you'll get is:

Window|new Window.
then window|arrange|vertical
Then resize both windows to show only what you want (A:N and O:U).

When you're tired of this view, select the window you don't want and hit ctrl-w.

Any chance you could move the data in O:U into a new worksheet. You could still
do the window stuff, but it might make it a little easier
(inserting/deleting????)

 

[Cancer Genetics]

If you want to MOVE a worksheet in Excel. Right click on
the worksheet tab, select Move or Copy, Select what
worksheet you want it to be placed before.

Once moved, Rename worksheet tab if you like.

To only have O-U, highlight A - N and right mouse click.
Choose Clear Contents and all the A - N column data will
be gone. Much more efficient than cut and paste.

Good luck