Apr 25 2022 06:32 AM
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?
Apr 25 2022 06:45 AM
Make sure that you save the workbook before you close it.
Apr 25 2022 06:59 AM
Thanks Hans, I tried your suggestion, but I still got the same result.
Apr 25 2022 07:04 AM
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?
Apr 26 2022 02:49 AM
Hi Hans
I only bought this PC 3 weeks ago and it came with Windows 11. My previous PC had Windows 10.
I have no idea about VBA codes or add ins.
Apr 26 2022 03:24 AM
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?
Apr 29 2022 03:51 AM
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.
Apr 29 2022 05:31 AM
I'm out of ideas, sorry.
May 05 2022 06:33 AM
SolutionMay 05 2022 07:05 AM
Good to hear that you were able to solve it.
May 05 2022 06:33 AM
Solution