Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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()
Range("A1").Select
End Sub
share|improve this answer
add comment

Your Answer

 
discard

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.