| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I make two worksheets act as one?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I make two worksheets act as one?
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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to make excel save worksheets independently | Excel Discussion (Misc queries) | |||
| make worksheets sortable | Excel Worksheet Functions | |||
| How do you make titles for columns in worksheets? | New Users to Excel | |||
| how do I make changes in several worksheets at once? | Excel Worksheet Functions | |||
| how do I make changes in several worksheets at once? | Excel Discussion (Misc queries) | |||
Linear Mode
