I'm running Excel 2007. When I attempt to sort a column, the top two rows aren't included in the sort. How do fix this?
Need some details about the steps you're taking. I assume you are using the Data, Sort command, rather than using the AutoFilter sort.
Are you sorting the whole sheet, or just a subset of the data?
Does your data have headers? If not, on the sort dialog box, is "my data has headers" checked? If so, that will ignore the top row.
Best way to get an answer is to post your file here and describe exactly what steps you are taking to sort.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks