Sorting excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1533882%22%20slang%3D%22en-US%22%3ESorting%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533882%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20%26nbsp%3BI%20set%20up%20a%20custom%20list%20under%20preferences%20to%20sort%20my%20excel%20spreadsheet.%20%26nbsp%3BHowever%2C%20I%20keep%20getting%20a%20red%20error%20message%20that%20says%20%E2%80%9CMissing%20column%2Frow%20name%E2%80%9D.%20%26nbsp%3BI%20have%20highlighted%20the%20name%20of%20the%20column%20for%20the%20sort%20but%20that%20does%20not%20work.%20%26nbsp%3BI%20keep%20getting%20the%20same%20error%20message.%3CBR%20%2F%3EAny%20suggestions%3F%20%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EPatty%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1533882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello.  I set up a custom list under preferences to sort my excel spreadsheet.  However, I keep getting a red error message that says “Missing column/row name”.  I have highlighted the name of the column for the sort but that does not work.  I keep getting the same error message.
Any suggestions?  

Patty

 

1 Reply

@plberg58 I suspect a column adjacent to the one you are trying to sort has data in it. See attached picture. I selected only cell G1 and then Sort, A to Z and "My list has headers" checked. Excel automatically expands the sort range to include adjacent columns, but it does NOT automatically set the column by which you want to sort. Leave "Column" blank and you will get "Missing column/row name" at the bottom and the red exclamation mark next to "Sort by". Choose the header of the column you want to sort by and OK. 

Screenshot 2020-07-21 at 07.04.18.png

Now, if you list has adjacent data, but you really want to sort one column only, select the entire column (or range in that column, including the header). Press Sort and confirm that you want to continue with the current selection, i.e. that you do NOT want to expand the selection.

Screenshot 2020-07-21 at 07.12.47.png

Check your sheet and see if this solves your problem. By the way, this is not affected by using custom lists.