They must be contiguous columns.
Select them all together *before* you choose <Data> <Sort>.
Never, never, never allow XL to choose your sort range for you.
Never, never, never use the sort icons on the tool bar.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How do you sort 5 or more columns?