| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Worksheets | Excel Worksheet Functions | |||
| How to combine several worksheets | Setting up and Configuration of Excel | |||
| how can I combine multiple worksheets into one? | Excel Worksheet Functions | |||
| combine worksheets in one file | Excel Discussion (Misc queries) | |||
| Combine Mutiple Worksheets into one | Excel Discussion (Misc queries) | |||
Linear Mode
