Shortcut to automatically go to current week's date in a spreadsheet

If you mean to a specific date, Numbers doesn't necessarily know what your dates refer to, so you can't search for 'this week', but you can search for, say "9/14/2026", assuming that's one of the dates in the column.

If you mean that you're extending the column and that the latest date is always at the bottom, you can use Command-Down Arrow to jump to the last cell in the current column, or Command-Option-Down Arrow to jump to the last populated cell in the current column.

Anything more that that is going to need some additional context, and likely scripting - for example, if your column contains dates based on, say, Sundays (e.g. 1/4/2026, 1/11/2026, 1/18/2026...) and you want an arbitrary date which doesn't fall on a Sunday (e.g. January 13th), you'd need some function and/or script to work out the preceding Sunday to work out the appropriate row to highlight.

So more details may be needed if simply 'jump to the end of the data/table' is not sufficient.

Hi Tettelestai,

Building on 6x6's excellent suggestion to use a filter to show only the rows for the current month.

First, let's construct the date of the first day of the current month in the current year.

Formulas in the table "First day of this month in this year":

A2 is TODAY()

B2 is YEAR(A2)

C2 is MONTH(A2)

D2 is 1 (a number typed to force the first day of this month)

E2 is DATE(B2,C2,1)

You can "hide" (move by cut and paste) to another Sheet if it gets in your way.

Now, a Tick Box in another table. Leave it unticked to show all the data. (You may want to sometimes view all the data.)

Formula in A2 of the table "Filter to show this month" is IF(A1=TRUE,"Showing current month","Showing all rows")

In Table 1 C2 the formula is IF(
Filter to show this month?::A$1=FALSE,"Show",
 IF(A2≥First day of this month in this year::E$2,"Show",
"")
)


I used option return to display new lines for more clarity in the formula editor.

Now apply a Filter.

With Table 1 selected, Format Panel > Organise > Filter > Add a Filter > Show? > Text is... Show.

Now turn off the filter (or untick the Tick Box in "Filter to show this month")

You can hide Column C.

Done! Please call back with questions.

Regards,

Ian.

You could use a filter on your table, say a filter for "date greater than 1st of the month". The table would then only show you the data for the current month. (You would need to update the filter every month.)

For more information: Filter data in Numbers on Mac - Apple Support.