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.