Forum Discussion
Large Excel sheet won't stay parked at top of page.
Hello
I am working with Office 365 using an Excel workbook comprised of several tabs with several hundred rows and columns. I have this workbook saved as a template and use it for new projects and then save it as a workbook for each project. For some reason in the past few days when I open some of the tabs the page opens to the bottom of the page and I have to keep scrolling back to the top every time I go back to that tab. I have opened the parent template and corrected it and re-saved it only to find the page back tat the bottom when I re-open the tab. I have completely removed Office 365 and re-installed it to no avail. This is very time consuming and frustrating. Does anyone have any suggestions?
Thank you
2 Replies
- mtarlerSilver Contributor
Mark Wheeler I don't have an answer why that would be happening but 2 tips I can mention are:
1) CTRL-HOME with take you to cell A1 on that sheet
2) you can also freeze the first col and row and then if you click on the frozen cell and click an arrow key to go to the next cell the sheet will scroll to that point (i.e. if you click in B1 and hit enter it will scroll to the top of page so you can see B2)
- dubrowrmCopper Contributor
Mark Wheeler I too, an experiencing the same issue with Excel & Teams. a fix would be kindly appreciated quickly!