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

Navigating sheets with keyboard

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


Joined: 29 Oct 2005
Posts: 336

PostPosted: Wed Jul 30, 2008 1:17 pm    Post subject: Navigating sheets with keyboard Reply with quote

In a sheet, I've found that pressing the "End" key takes me to the end of a row, and pressing the "Home" key takes me to the beginning of a row. Pressing "ctrl-end" takes me to the last cell in the sheet's lower right if you will, and pressing "ctrl-home" takes me to the first cell in the sheet's top left. "Page up" and "Page down" seem to take me up and down a certain number of cells within a column.

Am I correct, and what other keyboard shortcuts exist for navigating within a sheet in Calc?
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed Jul 30, 2008 4:39 pm    Post subject: Reply with quote

Just keep on playing. Look what happens when you hold the CTRL key and press down, up, right, left arrows. See the Name Box, left of f(x)? Type in a cell name like D35. .....

David.
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Wed Jul 30, 2008 10:10 pm    Post subject: Reply with quote

Alt+arrow key resizes the active cell.
F6 cycles through open toolbars/toolboxes.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Wed Jul 30, 2008 10:39 pm    Post subject: Re: Navigating sheets with keyboard Reply with quote

Bug wrote:
what other keyboard shortcuts exist for navigating within a sheet in Calc?
Although not within a sheet, Ctrl&PageDown and Ctrl&PageUp move to sheet2, sheet3, etc., and back again.
Back to top
View user's profile Send private message
Bug
OOo Advocate
OOo Advocate


Joined: 29 Oct 2005
Posts: 336

PostPosted: Thu Jul 31, 2008 6:43 pm    Post subject: Reply with quote

Ctrl with left or right arrow keys appears to give inconsistent navigation, depending on the column. What is it doing?
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Jul 31, 2008 6:48 pm    Post subject: Reply with quote

Bug wrote:
Ctrl with left or right arrow keys appears to give inconsistent navigation, depending on the column. What is it doing?


I don't know. What is it doing? I see no inconsistency. It should take you to the far left and far right.

David.
Back to top
View user's profile Send private message
machinegun
General User
General User


Joined: 24 Mar 2005
Posts: 7

PostPosted: Thu Jul 31, 2008 7:05 pm    Post subject: Reply with quote

similar to excel, lets say you are in a non-empty cell

control left/right/up/down will bring you to the furthest 1st non-empty cell
if you press control+direction again, it will bring you to the 1st non-empty cell

if you are in an empty cell, control+direction will bring you to the 1st non-empty cell
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