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?