Auto position column on opening Numbers s/s on iPad

Question

Auto position column on opening Numbers s/s on iPad

Can anyone tell me if it is possible to automatically position a spreadsheet to specific column (or cell would be the bees knees) when opening a Numbers s/s?

For example, in a sheet that has columns by day of the month, it would be useful if when a collaborator opens the spreadsheet if the correct day's column were selected automatically. I can highlight the column using conditional highlighting but cannot find how to position to this column automatically using the same criteria. Any help would be appreciated, thank you.

Posted on Sep 27, 2023 10:03 AM

Reply

Answer 1

SGIII

Level 8

37,568 points

Sep 30, 2023 2:42 AM in response to Ex-Excel_Numbers-Newbie

I don't think there is a way to auto-position the cursor.

But you could perhaps use a filter to show only the part of the table after yesterday by doing something like this:

When you want to work with the whole table you'll need to remember to turn the filter off.

More on filters here:

Filter data in Numbers on Mac - Apple Support (HK)

SG

Reply

Answer 2

SGIII

Level 8

37,568 points

Sep 27, 2023 6:19 PM in response to Ex-Excel_Numbers-Newbie

In Numbers, unlike in Excel, you will be better off using multiple smaller tables rather than one big expanse of cells. If you do that, it will easy to navigate to the spot where you need to go.

See the built-in templates for good examples of effective document design in Numbers.

SG

Reply

Answer 3

Sep 29, 2023 4:42 AM in response to SGIII

Hi SG, Thanks very much for getting back to me and so quickly too. I took your advice and reviewed the templates and found one in particular that was close to my current project. It was in the "Education" section and the template was called "Attendance".

The design of the template is similar in many respects to my project but I still cannot find a way of "position on opening' based on, say, a formula that used the DAY from TODAY to determine the start cell. If I frame my question in relation to the template I wonder if you would be kind enough to take a second look and suggest a methodology. My question for the "Attendance" template is - how do I get the sheet positioned at the correct date cell for the first named attendee based on the current date or day thereof?

If I'm being a pain in the rear just tell me or point me at a reference for dummies that would help me.

Reply

Answer 4

Sep 30, 2023 4:32 AM in response to SGIII

SG - That's brilliant. Thanks very much. The filter system will work just fine for what I want and I thank you for all of your help. There's always a way of achieving the end result you want whether it's Numbers or Excel I find, you just have to wear different hats!

Reply

Auto position column on opening Numbers s/s on iPad

Similar questions