HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING

[Guest]

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

 

[Guest]

You might try CTRL+END

Mike

 

[Guest]

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

 

[Guest]

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

 

[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.

 

[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