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 open...
- 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
Try the following:
Quit Excel completely.
Hold down the left Ctrl key while you start Excel again.
It will ask you whether you want to start Excel in Safe Mode. Answer Yes.
Create or open a workbook.
Select for example cell F100, then save the workbook (Ctrl+S) and close it (Ctrl+F4) without quitting Excel.
What do you see when you reopen the workbook from within Excel?
Hi Hans
I tried your suggestions several times without success. When I reopened it after using (Ctrl+F4) I saw the ribbon at the top of the page but the rest of the page was blank.
I'm out of ideas, sorry.
- 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 Derek1947Good to hear that you were able to solve it.