Auto-scroll an Excel workbook

DylanBrown You can do this with a bit of VBA code (paste into a normal module):

Option Explicit

Dim nextTime As Double

Sub scrollAgain()
    Dim curVisLastRow As Long
    curVisLastRow = ActiveWindow.VisibleRange(ActiveWindow.VisibleRange.Cells.Count).Row
        With ActiveSheet.ListObjects(1)
        If curVisLastRow < (.ListRows.Count + .Range.Cells(1, 1).Row) Then
            ActiveWindow.SmallScroll Down:=1
        Else
            ActiveWindow.SmallScroll up:=curVisLastRow - 1
        End If
    End With
    nextTime = Now + TimeValue("00:00:01")
    Application.OnTime nextTime, "scrollAgain"
End Sub

Sub StopScrolling()
    On Error Resume Next
    Application.OnTime nextTime, "scrollAgain", , False
End Sub

Start the scrolling by running the scrollAgain macro (alt+F8 from Excel, click on macroname and hit Run).

Stop it by running StopScrolling.

To make this slower, adjust the "00:00:01"

By the way: the code assumes your table is "Formatted as table".