How to scroll a specific sheet or all sheets to the top row in Excel?

Whether you want to scroll a specific sheet or all sheets in a workbook to the top, VBA code provides a quick and efficient solution. This guide explains how to use simple VBA scripts to streamline your navigation and focus on your data.

Scroll a specific sheet or all sheets to the top row with VBA code

Scroll a specific sheet or all sheets to the top row with VBA code

To scroll a specific sheet or all sheets to top row in Excel, please do as follows.

1. In the worksheet you need to scroll to top, please press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.

2. In the Microsoft Visual Basic for Applications window, click Insert > Module. Then copy and paste either of the VBA codes below into the Code window.

VBA code: Scroll a specific worksheet to the top row

Sub ScrollToTop()
ActiveWindow.ScrollRow = 1
End Sub

VBA code: Scroll all worksheets to the top row

Sub Select_A1_On_Activeworkbook()
    Dim xSheet As Worksheet
    For Each xSheet In ActiveWorkbook.Sheets
        xSheet.Activate
        ActiveSheet.Range("A1").Select
    Next
    ActiveWorkbook.Worksheets(1).Activate
End Sub

3. After entering VBA code into the Code window, please press the F5 key to run the code.

The active worksheet or all worksheets in the current workbook will immediately scroll to the top.