HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING

V

VSRBLR

in a file of 3600 lines I would like to 3600th line(last line or end of the
file)
HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 
V

VSRBLR

ITS NOT GOING TO THE LAST LINE ITS GOING TO SOME CELL WHICH IS FAR AWAY FROM
THE LINE 3600
 
M

Mike H

A couple of ideas.

First switch of the caps lock on your keyboard.

Second. It will go to the intersection of that last row-column used. For
example if the last row used is 3600 and the last column used is G it will go
to G3600. If it isn't where you think it should be then check you haven't got
any rogue data (spaces for example) that you haven't noticed.

Mike
 
S

Stan Brown

Mon, 21 May 2007 03:56:02 -0700 from VSRBLR
in a file of 3600 lines I would like to 3600th line(last line or end of the
file)
HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
Click to expand...

Please don't SHOUT, it gives us a headache.

Ctrl-End is the key combination you want.
 
M

MartinW

Hi VSRBLR,

As already mentioned by others Ctrl+End will take you to the last
used cell in the bottom right. If you then tap the Home key it will
take you back to column A of that row.

If this is way below the end of your data then check out
Debra Dalgleish's site about resetting the used range
http://www.contextures.com/xlfaqApp.html#Unused

HTH
Martin
 
Top