shortcut to scroll to last cell in row or column

[John Boyee]

Does anyone know a way to set a tab or something to stop at the bottom or
right of a table when the data ends? If i try to scroll down while selecting
data it speeds up so fast it jumps past were I want to stop. Are there any
settings to stop this issue?

 

[Dave Peterson]

If you hit ctrl-end, do you go to the bottom right corner of your data?

If you go past it, then visit Debra Dalgleish's site to see how to reset that
lastused cell.
http://www.contextures.com/xlfaqApp.html#Unused

 

[Gord Dibben]

John

How about a macro to go to bottom of selected column(s)?

Sub GODOWN()
Dim maxrow As Long
With ActiveCell.Parent.UsedRange
maxrow = .Cells(.Cells.Count).Row + 1
End With
ActiveCell.Parent.Cells(maxrow, ActiveCell.Column).End(xlUp).Select
End Sub


Gord Dibben Excel MVP

On Thu, 23 Jun 2005 09:23:08 -0700, "John Boyee" <John