Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default 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/


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 860
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format page number in excel footer to start at a specific page # straitctrydncr Excel Discussion (Misc queries) 4 April 28th 23 07:45 PM
Add page numbers to multiple worksheets without changing page setu alatona Excel Discussion (Misc queries) 2 March 16th 07 07:23 PM
change page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:16 AM
change and/or remove page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:15 AM
How do I print a one page spreadsheet multiple time, each with its own page number? lhsallwasser Excel Discussion (Misc queries) 4 August 17th 05 03:00 PM


All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"