Opening View in Excel 2007

Gateway / Mx6436
October 1, 2016 at 16:53:02
Specs: XP SP3, 3Ghz/4GB Ram
I have created a phone book using Excel 2007 and would like to know how to be able to view a specific spot.

All I want to be able to do is open the spreadsheet and scroll up and down. For some reason it does not by default go to my last position and I have to scroll left to see the list of names and the numbers next to the freeze frame of the list of contacts.

Is there a way to have it open so that I can view my last entry or to no have to scroll left?

message edited by sluytman


See More: Opening View in Excel 2007

Reply ↓  Report •


#1
October 2, 2016 at 02:41:28
Any document, be it Word or Excel or whatever, will always open at the start position.

To my knowledge there is no way to make it open at the end or at the last entry.

The only way to reduce the amount of vertical/horizontal scrolling required is to use a larger screen or reduce the zoom percentage lower than 100%, but the latter may make the text to small to read.

message edited by phil22


Reply ↓  Report •

#2
October 2, 2016 at 05:12:04
A Workbook_Open macro could be used to tell Excel which cell to select each time it opens the workbook. It could be told to select the last cell in the UsedRange, any specific cell, the end of a given row or column, etc. It might even be able to select the cell that was selected when the workbook was last closed by saving that address in a "holder cell".

What specifically are you trying to do?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

Related Solutions


Ask Question