Navigate Text Inside a Cell in Numbers After Control+Option+U

numbers

In Numbers we can use the ControlOptionU shortcut to edit text in a cell. Doing so the cursor goes to the end of the cell (the right side) here.

What if I want to edit in the middle of the text?

One approach might be to delete the text until the point I want to type something but I don't want to that for obvious reasons.

And if I press left/right keyboard arrows it goes to the other cell.

So how do I navigate the text in the current cell, the one I'm editing?

Perhaps I should mention I don't want to use mouse/touchpad.

Best Answer

You can press OptionEnter to start editing a cell the same way that double clicking will edit a cell. This will allow you to use your arrow keys, unlike ControlOptionU.

Interesting that there are two ways to do this, I wonder what the reasoning behind the command you found working the way it does is.

Related Solutions

Keyboard short cut to edit a cell in Numbers

(⌥OptionEnter↩).

Or just return if you've unchecked Return key moves to next cell in the inspector:

enter image description here

COUNTIF using two conditions from data inside and outside the dataset

It's probably easiest to add another column with:

AND(A1=1,B1=1)

and then use

COUNTIF(Table 1::C,"=TRUE")

You can hide the extra column if you want by selecting the column's drop-down arrow and clicking "Hide Column".

Minimal example: https://www.icloud.com/iw/#numbers/BAJy4qiGzoTh1VSmyA-BZ16VCStKBAKb9pSE/TEST (link will be removed in 1 week)

PARTIAL SOLUTIONS:

Example using Fudge Tables: https://www.icloud.com/iw/#numbers/BAI89SfR5AMJFjId3zyBzaZuxCGzy9uGo5eE/Fudge_Tables.numbers

Example using Subtables: https://www.icloud.com/iw/#numbers/BAJMsEi-8NDWoPbLaxeBsLTzYZ2Mqnmqo5eE/Subtables

Note that Subtables has a problem with zeroes (0000 translates to a number in the subtable). The best solution (as I did) is to put something like an "X" in every space that doesn't have a number in it in the main table.

Of course, be sure to check the data. The biggest problem with these methods is that they're very manual labor intensive and are very error prone. I blazed through them pretty quickly so I easily could have made a mistake. Just be careful. ;)

Best Answer

Related Solutions

Keyboard short cut to edit a cell in Numbers

COUNTIF using two conditions from data inside and outside the dataset

Related Question