I believe that *jumps* to the last row.

To *select* to the last row:
<Ctrl <Shift <DownArrow
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Shortcut.................

Select row 1309 then SHIFT + End + DownArrow to select to 65536.


Gord

On Tue, 13 Feb 2007 11:57:11 -0800, A Big Dummy
wrote:

Well that did work. I just had to go all the way to row 65536 to delete
all
of them, but now I can CRTL +End and get to the last filled cell on my
worksheet.

Thank you.



"Gord Dibben" wrote:

After deleting.....not clearing.........the rows below 1308 you must
SAVE the
workbook for your changes to take effect.

Excel commonly over-estimates the used range of a worksheet if you have
used
those cells at one time then just cleared the contents.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 09:36:01 -0800, A Big Dummy
wrote:

Thanks for the input.
Ctrl + End goes to cell G 1643 and my data ends at F 1308.
I do not understand why it goes to that cell as my end. I tried
selecting
all the blank rows after 1308 and deleting them and clearing them, but
it
still goes there.

I am using excel 2003.

"JMB" wrote:

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 ?