set default cell in workbooks/spreadsheets
move the default home cell to a1
I have to use shared workbooks and everytime a look at one of the pages in the work book it seems to default to something like z100 (maybe not specifically that but trying to say it is out of range of the data I need to see)
It i possibly the fault of the person who created the work book but for whatever reason, it is extremely annoying as I have to scroll back to the top corner of every sheet in every work book to find the information I need and this happens every time I have to look at it (i.e. it does not save/remember where i was when I last looked at it).
Any way you can improve this?
Trevor Galenzoski commented
When I click on a workbook tab, the horizonal/vertical scroll bars do not start at the far left/top of sheet (top left corner/ A1) of my sheet by default. It would be really nice if their was an option to turn on a "Open sheet on cell XX" option. On shared spreadsheets, it is such a pain, as individuals contact me telling me the sheet is blank (When actually the the sheet is just scrolled over 100 columns to the right! Add this 'Open sheet on cell XX (default cell)" would be so helpful. Thanks.