All sheets opening at column IV - help!

[lenaert73]

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

 

[Niek Otten]

Hi Dana,

Tools>Options>International tab,
under Right-to-Left, check the appropriate boxes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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