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

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