I have columns A through F. Each column has 26 rows with inventory items
(text). When I try to sort it, it sorts BY column A and the other columns
remain unsorted. Apparently, I can only sort each column separately but I
need the items in ALL of the columns to be sorted together.

Is there a way to do this?

BTW, I'm using Excel 2007.