Sort Part of a List

I did not mention this is 2010, could be the difference. Maybe there is a checkbox that says to always select the entire active-range whether you ask it to or not.

When I select B1-B7 and sort, the data moves to the top (alphabetically) and the bottom 2 are empty.
Then I select A1-A5 (because they have data in col B) and sort those... but all 7 rows are sorted by column A.

I don't think this is a 2010 issue. I have found that with a new table, even one with Freeze Frames, I can accomplish what I want using a "custom sort" instead of just clicking A-Z on my selection.

However, on the same workbook, for some reason, I cannot sort just a few of my rows. ANY sorting I do automatically does the entire table. Yes, I CAN select the column to sort by, but no matter how I do the selection, it will apply it to the whole table.

So now it's time to post an example workbook...