If you have a long sheet and are constantly scrolling all
the way down to the bottom then back up to the top, here are two quick macros
you can use to instantly go to the top or the bottom of the active sheet.
Sub GoTo_Top()
With ActiveSheet
Application.Goto Cells(1, 1), True
End With
End Sub
Sub GoTo_Buttom()
With ActiveSheet
LastRow = Cells(Rows.Count,
2).End(xlUp).Row
Application.Goto Range("B"
& LastRow), True
End With
End Sub
Use the developer tab to
insert a command button, then link it to your macro to make it super easy for
even the most inexperienced Excel user to instantly move from the top and the
button of the spreadsheet.
If you don’t see the
Developer tab at the top, go to File -> Options - > Customize Ribbon
I hope you enjoyed this quick tip! Sign up for my email list for more Excel tips.
