View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
paul[_2_] paul[_2_] is offline
external usenet poster
 
Posts: 31
Default 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