HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 

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

HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 

You might try CTRL+END

Mike

"VSRBLR" wrote:

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

HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 

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


"Mike H" wrote:

You might try CTRL+END

Mike

"VSRBLR" wrote:

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

HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 

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

"VSRBLR" wrote:

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


"Mike H" wrote:

You might try CTRL+END

Mike

"VSRBLR" wrote:

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

HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING
 

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