Excel sheet keeps opening at the very bottom on onedrive.

Copper Contributor

How do you fix this so that it opens to the last data set instead? Thanks!

1 Reply



In this case, I would accommodate myself to Excel. And for what it's worth, it generally makes sense anyway to be adding new data at the bottom. (I'm assuming you have an Excel table with dated data.) Otherwise, if you're inserting new rows at the top, I assume that means you're inserting a new row first... i.e., you're doing it the hard way,


If you need to see the most recent at the top, separate the "viewing sheet" from the "raw data" or input sheet, and do your adding of rows in what I truly think is the "normal way" but have a different "dashboard" sheet for viewing....and there you can sort/filter in whatever order on whatever criteria you wish.