Or at least, to the last entry I made?
remember – i may enter my hours on last friday, but the sheet already has next monday's date pre-filled, so ctrl/end doesn't work.
the year goes to March 2017.
Google-sheets – Google sheets: My timesheet is a pre-filled list of dates for the whole year How to get quickly to today’s date
google sheets
Related Topic
- Google Forms – Report Only the Last Entry Made by User
- Google Sheets – Copy Data to Another Sheet Based on Month of Date
- Google-sheets – Copying data to *and from* another sheet based on the month of a date
- Google Sheets – How to Add Every Sunday in Sequential Order
- Google Sheets Conditional Formatting – Fix Issues for All Cells
- Google Sheets – Highlight Row if Partial Text Matches in Two Columns
- Google Sheets – How to Automatically Fill Missing Data
Best Answer
Keyboard shortcut
Use Ctrl-Down to move to the last filled entry in the column with hours. More precisely, Ctrl-Down moves down to the next cell that either begins or ends a group of filled cells. If you do not have any blanks between filled-in cells, it goes to the last one. From there, pressing Down arrow again brings you to the cell waiting to be filled.
Script
A script can move the cursor to today's date when the spreadsheet is opened. See How to make Google Sheet jump to today's row when opened?