Is there a Go To function in Numbers?
I really like the function in AppleWorks‘ to be able to link to other parts of a document. I don’t see anything like this in Numbers unless I am missing it. Can anyone prove me wrong?
MacBook, Mac OS X (10.6.8)
No, but...
There are a couple of techniques you can use to get to a row near the one you want or to a cell in the immediate neighborhood.
- Place a single cell table near the row you want to go to on your large table. Give it a name that indicates where it is. Drag it to a location near that row. Clicking the new table's icon in the Sheets List will bring it to the front and into view. from there, it should be a short hop to where you want to be. (Technique suggested some time ago by Jerry.)
- "Find" + "Jump to" can be used to jump to a cell determined by its contents. You can define the content of selected cells or of one or more columns to be unique within the table (or to have the same content, and be located in handy places throughout the table).
• Use command-F to open the Find pane. Type the identifier into the search field, then select the correct location from the list in the pane and press command-J to jump to the selected cell.
With the second technique, you'll get a single item list if the identifier is unique within the table, or a list of all cells containing the identifier if it's in more than one cell.
Regards,
Barry