1. I have a column of dates. Is there a way to change the year on all the dates?
2. I have a spreadsheet saved on my Google drive that I open and input one row daily, usually on my phone. When I open it, it starts at the top. Since I've been inputting info in it daily for a couple months, it takes me a bit to scroll to the current row I need. Is there a way to make it open in the next open row or even the last completed row?