Excel Problem

So I am remotely updating the workstations on my domain for the latest MS RPC vulnerability, and the boss needs to know our status. So the tool I am using (which scans and patches) logs the status of what is and is not patched. So I import my log file into excel into 3 columns: IP address, computer name and status. Well, when I try and sort the spreadsheet by IP, all the other information stays put, computer name and status. How can I sort by IP and ensure that the other information in the row (computer name and status) stays together? I am sure it is something ridiculously simple, but my boss, not having that info, seems to think that I am simply ridiculous. Any help would be greatly appreciated.

Using excel 2002, I made a 3 column list and it sorted ascending and decending just fine, keeping all three columns together. I was only able to sort one column at a time after clicking a confirmation. What version of excel are you using?

I have Excel 2000. Maybe its something I am doing wrong, but when I sort columns, they all get sorted independently of each other.

(I apologize for late reply. We evacuated due to hurricane Isabel.)

Make sure the entire sheet is highlighted. Then when you click data-> sort, make sure my list has header row is highlighted. You should be able to sort all three columns that way.

Chuck