Want to sort Excel spreadsheet by heading rather than column letter; spreadsheet was originally a notebook file

[austinjane]

Hi all,

I am using Excel 2010 and still getting used to the flaky parts.

I'm working with a spreadsheet was originally a Notebook document. Successfully opened the Notebook file in Excel and saved it as an Excel 2010 spreadsheet, and am attempting to sort and manipulate data, removing dupes, etc. On this spreadsheet, I want to sort by BUSINESS, LAST NAME, ADDRESS rather than Column A, Column B and Column C.

I created the BUSINESS, LAST, FIRST, ADDRESS, etc. headings after I opened the Notebook file in Excel. Excel is now treating these "headings" as regular data instead of headings. When I create the custom sort, Excel hightlights 3 columns and gives me options to sort the columns highlighted: Column A, Column B, Column C, rather than the headings. Plus there are probably 20 columns in this spreadsheet.

I'm a little lost. I could add the "headings" in the Notebook file, but will these also be treated as data rather than headings?

Any insight is appreciated.

Kind regards,

austinjane

 

[BenMiller]

In the sort dialog box, make sure "My data has headers" is checked. It can help to format the first row differently; i.e. bold or larger font size.

 

[austinjane]

Thanks, Ben. I was looking for something like that - appreciate you telling me where it was.

Best.

 

[BenMiller]

No problem Glad I could help Appreciate the feedback!