Forum Discussion
Solved
How do I open an excel spreedsheet where I want.
When I finish working on an Excel Spreadsheet I highlight a cell just below where I finish say F120 which is where I want to start the next time I open that spreadsheet. However, the spreadsheet opens at the very top of the page with cell A1 highlighted. How can I get it to open where I want it to?
- Hi Hans
Thank you for your help and let me apologise for the length of this post. I have solved the problem of my excel worksheet opening at the top and not where I last closed it.
My PC is about 4 weeks old and has Windows11 installed. My previous PC was 10 years old and had Windows 10 installed. My old PC would not support Windows11 and word and excel documents were not working properly, so I used a Microsoft application called Cool Office.
When I check the excel file extension for the documents I was having trouble with I found it was .ods. I went online and found a document converter, then made a copy of one of my excel documents and dragged and dropped it into the converter after I had set it to convert .ods to .xsls and send it back to my PC desktop. I check the file extension of the converted document and sure enough it is .xsls. After several times opening and closing the document it opens at the same place where I last closed it. Many thanks Derek1947
9 Replies
Make sure that you save the workbook before you close it.
Thanks Hans, I tried your suggestion, but I still got the same result.
That is strange. Normally, Excel opens a workbook the way you last saved it.
Do you have VBA code that could cause this? Or an add-in?
