combine worksheets
 

655336I have hit the magic number 655336 which is the last row on a excell
worksheet.

I'd like to know if it is possible to increase the number of rows for my my
worksheet and if needbe fore go collumns as my list only requires 4.

This list list needs to be kepted in alphabetical order for searching
purposes using the Ctrl+f for finding.

Can any one please kindly advise, thank you

combine worksheets
 

xl2007 offers 1 meg of rows.

In xl97-xl2003, you can't go past 65536 rows.



Scrambled wrote:

655336I have hit the magic number 655336 which is the last row on a excell
worksheet.

I'd like to know if it is possible to increase the number of rows for my my
worksheet and if needbe fore go collumns as my list only requires 4.

This list list needs to be kepted in alphabetical order for searching
purposes using the Ctrl+f for finding.

Can any one please kindly advise, thank you

--

Dave Peterson

combine worksheets
 

you can start a new sheet of course,with some logic perhaps A-m on 1st
sheetM-z on the second
--
paul

remove nospam for email addy!



"Dave Peterson" wrote:

xl2007 offers 1 meg of rows.

In xl97-xl2003, you can't go past 65536 rows.



Scrambled wrote:

655336I have hit the magic number 655336 which is the last row on a excell
worksheet.

I'd like to know if it is possible to increase the number of rows for my my
worksheet and if needbe fore go collumns as my list only requires 4.

This list list needs to be kepted in alphabetical order for searching
purposes using the Ctrl+f for finding.

Can any one please kindly advise, thank you

--

Dave Peterson

combine worksheets
 

The other option is to import the files into Access.

"paul" wrote:

you can start a new sheet of course,with some logic perhaps A-m on 1st
sheetM-z on the second
--
paul

remove nospam for email addy!



"Dave Peterson" wrote:

xl2007 offers 1 meg of rows.

In xl97-xl2003, you can't go past 65536 rows.



Scrambled wrote:

655336I have hit the magic number 655336 which is the last row on a excell
worksheet.

I'd like to know if it is possible to increase the number of rows for my my
worksheet and if needbe fore go collumns as my list only requires 4.

This list list needs to be kepted in alphabetical order for searching
purposes using the Ctrl+f for finding.

Can any one please kindly advise, thank you

--

Dave Peterson