Partial Copying to New Worksheet in same Workbook

  • Thread starter Thread starter Frank West
  • Start date Start date
F

Frank West

Hi, again.

I have a worksheet with a lot of data going across. If I want to look
at data on the far right, I have to scroll all the time. I thought it
would be easier to, say, divide the worksheet into thirds and put each
third into a separate worksheet in the same workbook. That way I
could just click on the tab to view the data.

The problem I'm having is that I keep getting the #ref error. Yes, I
have all sorts of formulas and stuff, but shouldn't you just be able
to copy to another sheet and have it work? What is the easiest
solution?

Thanks,

Frank West
 
Hi Frank
Are you sure that you want to break up the data? Its not a bad thing, i
just wonder how much maintenance is involved when it has to be
changed?

Have you thought of splitting the screen? (or wont this work for you?)

Do you know how to write a macro. This way you could write one that is
connected to a keyboard shortcut so that it scrolls to the correct
position every time?
 
Hi Frank
Are you sure that you want to break up the data? Its not a bad thing, i
just wonder how much maintenance is involved when it has to be
changed?
Click to expand...

I don't know how to do it without getting the #ref! error, but it
seems like an easy solution.
Have you thought of splitting the screen? (or wont this work for you?)
Click to expand...

I can split the screen from top to bottom using the freeze pane mode,
but I haven't tried splitting from left to right.
Do you know how to write a macro. This way you could write one that is
connected to a keyboard shortcut so that it scrolls to the correct
position every time?
Click to expand...

I hadn't thought of a macro, I might try that, thanks.
 
Another option may be to just use Window|New window a couple of times.

Then you can arrange the windows (vertically?) and show each portion
independently.

When you're tired of all the open windows, you can click on the window you don't
want and hit ctrl-F4.

If you see:
book1.xls:2
in the title bar, that's excel's way of warning you that you have multiple
windows.
 
Another option may be to just use Window|New window a couple of times.

Then you can arrange the windows (vertically?) and show each portion
independently.

When you're tired of all the open windows, you can click on the window you don't
want and hit ctrl-F4.
Click to expand...

Hi, Dave, thanks for the suggestion.

This is a good answer, but the only problem is that when you open a
new window you lose all of your formatting. I have to refit the
screen size (from 100% to 80%) and I lose my freeze pane mode.

Is there a way around this?

Thanks,

FW
 
Back
Top