One of our consultants was copying and pasting headings for a table in a
worksheet and the next thing he knew, he was at the end of the spreadsheet,
at column IV. Now whenever he opens up a new workbook or spreadsheet it opens
at column IV. He can use Ctrl+< to get to column A, but when he lets go it
automatically returns to column IV. And this is with anything he opens.

Any ideas what he did, or more importantly, how to fix it?

Thanks,
Dana