Forum Discussion
Derek1947
Apr 25, 2022Copper Contributor
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 open...
- May 05, 2022Hi 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
HansVogelaar
Apr 29, 2022MVP
I'm out of ideas, sorry.
Derek1947
May 05, 2022Copper Contributor
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
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
- HansVogelaarMay 05, 2022MVP
Good to hear that you were able to solve it.