Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you sort a worksheet which has embedded lists?
I have created a worksheet that contains 7 columns. Column 7, I have created
a "list" from the right-clicked menu with the data for the list coming from that entire row. When I completed inputiing data for that list and moved to the next data row, the previous rows were enclosed by a heavy blue line forming a box around all data tied to the original row. I have not hidden the column numbers that resulted from the created list. When the worksheet was completed, I attempted to "sort" the data fields, however, it will not sort. I have re-formated numerical data to text in the column that is driving the sort criteria but to no avail. I want to sort the ws while maintaining the data row and corresponding list together. Any help would greatly be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
How do you convert embedded drop-down lists in Excel '97? | Excel Worksheet Functions | |||
Scrolling an Excel worksheet embedded in a Visio diagram with VBA | Excel Worksheet Functions | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) |