Ask Your Question
0

Calc Equivalent to Excel goto function

asked 2020-04-16 15:48:20 +0100

ncshawng gravatar image

updated 2020-04-16 16:28:52 +0100

I have searched through the questions on an Excel ctrl-g (goto) equivalent for Calc, and have not seen the variant I'm interested in.

In Excel, when you type a ctrl-g, a dialog box opens which allows you to enter a cell reference, and then allows you to go to that cell.

I'm aware of the Address location and using F5 to bring up Navigator in LibreOffice Calc. That part does work.

But, there's another aspect of Excel's goto which I can't seem to find in Calc.

Excel maintains a list of the cells you've gone to via ctrl-g goto. It automatically fills in the previous cell location.

So, if I enter ctrl-g in Excel, I get a dialog box asking for the cell reference. I enter the cell I want to go to, and click OK or press Enter. Excel takes me to the specified cell. If I enter ctrl-g again, the same dialog box pops up, but with the previous cell filled in. Ctrl-g will allow you to go back and forth between two cells without having to enter the cell address. There's also no need to write any information down in order to return to the cell that you were previously working on.

A list of cells that have been used are also displayed, allowing the user to simply select from a list of recently used cells by the ctrl-g goto command. See the attached screen shot from Excel to see what I mean.

Noticing that the Address location had a pull-down arrow to the right, I was hoping that it would maintain a list of typed in addresses on a LIFO stack, but unfortunately the pulldown simply brings up another function.

Is there any way to perform this operation in Calc (jump around from cell or sheet to another cell or sheet) without having to write down previously referenced cells addresses? Naming the cells wouldn't be helpful because every time I added a new record to the spreadsheet, I'd have to name the cells I'm interested in.

I'm a big fan of letting the computer do the work. Perhaps a macro can store previously-referenced cells and bring them up already filled in, or allowing the user to type in a new cell reference or address.

This would be a great feature to add to Calc.

C:\fakepath\Screen Shot 2020-04-16 at 9.34.37 AM.png

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-04-16 16:14:02 +0100

Opaque gravatar image

updated 2020-04-16 17:49:34 +0100

Hello

use the name box, add a cell reference and click ok, go back to the name box and append a special character to the reference (eg. an underscore _), click ok once more and you get your list.

image description

If you want to delete the list - use Manage Names from the Name Box drop down.

And "yes", this is some kind of a misuse of Named Ranges.

Update

image description

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more

Comments

Hey, cool. I'll try that. Is it LIFO?

ncshawng gravatar imagencshawng ( 2020-04-16 16:29:45 +0100 )edit

No - seems sorted.

Opaque gravatar imageOpaque ( 2020-04-16 16:37:50 +0100 )edit

This doesn't seem to work. I get a message "You must enter a valid reference or type a valid name for the selected range.", or when the reference can be entered, like B10_, it allows the entry but it does not jump to B10. Items in the pulldown list similarly cannot be jumped to.

ncshawng gravatar imagencshawng ( 2020-04-16 16:46:31 +0100 )edit

Do you think that a paste fake answers... and fake screenshots? You need to

  1. Insert a reference into the Name Box (without the underscore _)
  2. Press Enter key (Cell gets selected)
  3. Move the mouse back to the Name Box
  4. Append the _
  5. Press Enter key once more (the Name gets defined).
Opaque gravatar imageOpaque ( 2020-04-16 16:56:30 +0100 )edit

Note also the shortcut key ctrl+shift+F5 to jump to the name box (and simply F5 for the full navigator dialog).

keme gravatar imagekeme ( 2020-04-16 19:37:18 +0100 )edit

Or Shift+Ctrl+T to focus the Name Box.

erAck gravatar imageerAck ( 2020-04-16 20:18:35 +0100 )edit

OK, I'll work with the person who asked me about this and see if this works for him. He balks at having to pay a boatload of money to Microsoft for his Office 365 subscription. I still wish this was more automatic, as ctrl-g does in Excel.

ncshawng gravatar imagencshawng ( 2020-04-17 00:08:20 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-04-16 15:48:20 +0100

Seen: 284 times

Last updated: Apr 16