Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) | |||
change page number watermark in page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) |