Scrolling to top of spreadsheet - Excel 2007

Posted on 2011-05-02
Last Modified: 2012-05-11
I have a spreadsheet with two tabs.  Is there a way to ensure that when I go from one tab to the other I am always at the top of the second spreadsheet even if I have scrolled down on the other spreadsheet.

Example:  I have scrolled down to column K33 on Spreadsheet_A
When I click on spreadsheet_B I would like to be at the top A1
Question by:morinia
    LVL 1

    Expert Comment

    The last cell chosen on any one sheet is the same, irrespective of where the selected cell is located on a different sheet.
    You could write some code, but the easiest way is simply to press CTRL+Home before clicking on the next sheet. This will always return the selected cell to A1. The next time you click on that sheet the cell will be at the same position you left it in... that is: A1.
    LVL 50

    Expert Comment


    the previous comment could be formulated a bit more concise:

    When a sheet is opened, the active cell will be the same cell that had the focus when the sheet was last active. If you scroll in sheet A and then open Sheet B, the scrolling in Sheet A will not make a difference to what cell is in focus on Sheet B.

    Pressing Ctl-Home before clicking on a new sheet will not have an effect on the active cell on the new sheet, just on the active cell of the sheet you are about to leave.

    Author Comment


    I found that out when I tried it. Do you know the code to cause the sheet to position to A1 whenever a sheet is selected?
    LVL 50

    Accepted Solution

    Yes. Put this into the Sheet Module for each worksheet that you want to select A1 when activated

    Private Sub Worksheet_Activate()
    End Sub

    Or, if you want to apply this to the whole workbook, put this in the ThisWorkbook module

    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    End Sub

    cheers, teylyn

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now