shortcut to scroll to last cell in row or column

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?

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



John Boyee wrote:
>
> 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

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
Boyee@discussions.microsoft.com> wrote:

>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?