how do I make two worksheets act as one?

[Guest]

Hi I have reached line number 655336 which is the last line numer in a
worksheet. I now I could goto worksheet2 but If I do, how do I make the two
sheets behave as though they were one, in order to maintain my Althabetical
listing?

Thanks

 

[Stan Brown]

Sat, 26 May 2007 08:13:00 -0700 from Scrambled

Hi I have reached line number 655336 which is the last line numer in a
worksheet. I now I could goto worksheet2 but If I do, how do I make the two
sheets behave as though they were one, in order to maintain my Althabetical
listing?

In Excel 2003 or below, you can't. I don't understand "Althabetical",
but if you mean alphabetical then you'll need to divide your
worksheets -- A-L and M-Z, for instance. (The best dividing point
depends on your data.)

In Excel 2007, you can get up to a million rows in a worksheet, so
perhaps the upgrade is worth considering for your application.