Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Everytime I open a very large excel spreadsheet, it opens on the far right of the chart (like column Z, then blank space, rather than the beginning (column A) of the chart. How can I change this to show column A first?

share|improve this question

As datatoo indicated, the last active cell location has influence on where the workbook opens. If you want to make sure it opens to a certain location I prefer ActivewWindow.ScrollIntoView. Because it does not actually change the saved selection.

Private Sub Workbook_Open()
    ActiveWindow.ScrollIntoView 1, 1, 1, 1
End Sub

This will scroll the very top left of your document into the top left of your window.

share|improve this answer
+1 I like this, I had forgotten this – datatoo Jul 14 '12 at 19:01

Normally this is a result of the last active cell location when the file was saved before closing. Unless you have a macro running on the Workbook_Open event that changes that.

If you don't mind a macro in the workbook, or want to force this you might try this

Private Sub Workbook_Open()
End Sub
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.