Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Sorting data on two sheets
I have data that occupies some 400 columns. Because Excel has only 256
columns, part of it goes on a second sheet. Sorting data on sheet # 1 re-arranges the rows on sheet one but not on sheet 2. SO. . . 1) Is there any way to increase the number of columns in a worksheet (I certainly do not neeed 6000+ rows !)? 2) Is there any way to make a sort on sheet 1 also re-order the rows on sheet 2? -- A. Beare |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data does not expand to other sheets | Excel Worksheet Functions | |||
Sorting data in protected sheets? | Excel Discussion (Misc queries) | |||
Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Sorting Data to Different Sheets | Excel Worksheet Functions |