You could try Edit/GoTo/Special - last cell (or Control+End), however,
sometimes the last cell does not have data in it (it could just have some
formatting done to it - or sometimes excel gets confused as to what the last
cell is). Also, if you have data in cell D14 and F11, the last cell will be
F14 (intersection of the last row/last column).

You can also hold down the Control key and hit one of the arrow keys which
will take you to the end (you will have to hit the arrow key several times if
there are breaks in your data - or select a cell in an empty column hit
Cntrl+Down Arrow to go the the bottom of the sheet, then click on a cell in
the column you want and hit Cntrl+Up Arrow).

Or you could try a macro, but depending on what you consider the last cell
(in the above example, would it be cell D14 or F11), you may need to change
Searchorder from xlByRows to xlByColumns.

Sub Macro1()
Cells.Find(What:="*", _
After:=Range("A1"), _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Activate
End Sub

"A Big Dummy" wrote:

Hello All,
Is there a shortcut for getting to last filled/used cell in a spreadsheet ?