OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

"Go to" cell keyboard shortcut?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ToVeR
OOo Advocate
OOo Advocate


Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium

PostPosted: Sat Aug 04, 2007 6:39 am    Post subject: "Go to" cell keyboard shortcut? Reply with quote

Is there a keyboard shortcut for the MS Excel shortcut "ctrl + g": This pops up a "go to" dialog, allowing immediate entry of a cell you want to go to. A similar thing is possible using the navigator in Calc, but this is more cumbersome to use (first of all: I do not know how to focus to the navigator using only the keyboard, which I prefer over using a mouse as I am often using a laptop).

Is there a viable alternative?

Info on how to focus to the navigator pane using the keyboard is also welcome.
_________________
LibreOffice 3.4.3
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Sat Aug 04, 2007 10:11 am    Post subject: Reply with quote

F5 is what I use in Excel for Go To, and same in Calc, rather than Ctrl-G. Pressing F5 again gets rid of the dialogue box.

I agree it's a bit more cumbersome. To get to cell B26 in Calc, say:

Press F5
Press Del to clear the column letter
Press B
Press Tab to highlight the row number
Press 26
Press Enter
Press F5 to get rid of the dialogue box.

In Excel I think I just:

Press F5
Press B26
Press Enter

There may be a better way in Calc....
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Aug 05, 2007 11:33 am    Post subject: Reply with quote

RickRandom wrote:

...
There may be a better way in Calc....

Enter a range address into the name box left of the formula bar. If you enter something which is not a generic address nor an existing range name, then it will name the currently selected cells.
Back to top
View user's profile Send private message
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Mon Aug 06, 2007 12:00 am    Post subject: Reply with quote

To access the Name Box via the keyboard, use Ctrl+Shift+T or Ctrl+Shift+F5

If you want to map that to Ctrl+G:
  1. Tools > Customise... > Keyboard
  2. Select Ctrl+G in the Shortcut keys
  3. Select Application in Category
  4. Select Sheet Area Input Field in Function
  5. Press the Modify and OK buttons
Back to top
View user's profile Send private message
ToVeR
OOo Advocate
OOo Advocate


Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium

PostPosted: Sat Aug 18, 2007 3:00 am    Post subject: Reply with quote

RickRandom wrote:

Press F5
Press Del to clear the column letter
Press B
Press Tab to highlight the row number
Press 26
Press Enter
Press F5 to get rid of the dialogue box.


This does no work for me. When I press F5 in OOo Calc, the focus is still on the sheet and not on the navigator pane. And as I do not know how to focus on it ...

huwg wrote:

To access the Name Box via the keyboard, use Ctrl+Shift+T or Ctrl+Shift+F5


This works better for me. Alleviates the need for the navigator pane.

However, is there a way to focus to the navigator pane? As I say above, this seems to be impossible for me without using the mouse pointer.
_________________
LibreOffice 3.4.3
Back to top
View user's profile Send private message
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Mon Aug 20, 2007 12:07 am    Post subject: Reply with quote

ToVeR wrote:
huwg wrote:

To access the Name Box via the keyboard, use Ctrl+Shift+T or Ctrl+Shift+F5


This works better for me. Alleviates the need for the navigator pane.

However, is there a way to focus to the navigator pane? As I say above, this seems to be impossible for me without using the mouse pointer.
F6 sets subwindow focus.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group