Ask Your Question
0

can I jump to a specific worksheet via keyboard shortcuts?

asked 2019-12-28 17:47:26 +0100

Berry gravatar image

updated 2019-12-28 18:09:21 +0100

I have 40 worksheets. Each has a unique name. I'd like to navigate directly to each sheet.

In MS Excel, I had set a name to topmost cell (e.g. A1's name > david).

Then, when I want to jump to that worksheet,

  1. I press Ctrl+G (goto)
  2. I write "david"
  3. I press Enter

That's the shortest way I could find.

Is there any equivalent in Libre Calc ? for now, I know 2 options:

  1. F5 (navigation) (closes existing dialog) > F5 (starts & focus the dialog) > TAB > TAB > TAB > then arrow keys or 1st letter of worksheet name.
  2. manually Ctrl+PgDn all the way to the desired sheet
  3. write a macro
edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
2

answered 2019-12-28 19:19:33 +0100

Opaque gravatar image

Hello,

just type the sheetname into the range field (name box) of the formula bar leftmost. An info box "Go To Sheet" will appear and just press Enter:

image description

Hope that helps.

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

edit flag offensive delete link more

Comments

Note the shortcut - Ctrl+Shift+F5 by default - to move to the Name Box.

Mike Kaganski gravatar imageMike Kaganski ( 2019-12-29 12:09:29 +0100 )edit

@Mike Kaganski - thanks, searched for a shortcut but with no luck, thus already considered to delete the answer since it doesn't meet OP's requirement to be keyboard-only solution

Opaque gravatar imageOpaque ( 2019-12-29 12:23:25 +0100 )edit
0

answered 2019-12-31 00:06:31 +0100

Regina gravatar image

You can use Ctrl+Tab and Ctrl+Shift+Tab to go to the next or previous sheet, respectively. Or you write a macro and assign a shortcut to the macro.

Example

sub Jump
dim oDocument  as variant
oDocument   = ThisComponent.CurrentController.Frame
dim oDispatcher as variant
oDispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dim sNr as string
sNr = InputBox("Enter sheet number", "Jump To Table","1")
dim nNr as integer
nNr = CInt(sNr)
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Nr"
args1(0).Value = nNr
oDispatcher.executeDispatch(oDocument, ".uno:JumpToTable", "", 0, args1())
end sub
edit flag offensive delete link more
0

answered 2019-12-28 21:24:36 +0100

kompilainenn gravatar image

Right click on "+" sign to left from sheet tabs and you'll see context menu with list of all your sheets. You can select any and jump to it

edit flag offensive delete link more

Comments

This is similar to what you get via the Navigator - which has a scrollbar in addition.
The questioner's problem seems to be the large number of sheets.
I tried and got (on my screen with my settings) a maximum of 48 sheets shown at a time with the "+ rightclick". If the sheets are not sorted in an obvious way the lookup may take some time. In case of known names @Opaque's suggestion may be superior.

Lupp gravatar imageLupp ( 2019-12-28 23:22:58 +0100 )edit

Yet, the Navigator variant does also allow to perform the search using keyboard only, and without long search: F5 to open Navigator; Tab×3 to go to the list; if needed, navigate to "Sheets" node using arrow keys, and expand it using Enter or right arrow; either use arrow keys again, or start typing the sheet name (will only work if typing is fast enough).

Mike Kaganski gravatar imageMike Kaganski ( 2019-12-29 12:38:05 +0100 )edit

I sometimes have docked (correct expression?) the Navigator inside a sidebar. Calling it with F5 does not move the keyboard focus to it then.

Lupp gravatar imageLupp ( 2019-12-29 17:42:56 +0100 )edit

@Lupp: yes, in that case you only (?) can use F6 to finally switch to the Navigator pane.

Mike Kaganski gravatar imageMike Kaganski ( 2019-12-31 09:42:06 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-28 17:47:26 +0100

Seen: 433 times

Last updated: Dec 31 '19