| View previous topic :: View next topic |
| Author |
Message |
Bug
OOo Advocate
Joined: 29 Oct 2005
Posts: 336
|
 Posted: Wed Jul 30, 2008 1:17 pm Post subject: Navigating sheets with keyboard |
 |
|
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 |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Wed Jul 30, 2008 4:39 pm Post subject: |
|
|
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 |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2745
Location: Egersund, Norway
|
| Posted: Wed Jul 30, 2008 10:10 pm Post subject: |
|
|
Alt+arrow key resizes the active cell.
F6 cycles through open toolbars/toolboxes. |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Wed Jul 30, 2008 10:39 pm Post subject: Re: Navigating sheets with keyboard |
|
|
| 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 |
|
|
Bug
OOo Advocate
Joined: 29 Oct 2005
Posts: 336
|
| Posted: Thu Jul 31, 2008 6:43 pm Post subject: |
|
|
| Ctrl with left or right arrow keys appears to give inconsistent navigation, depending on the column. What is it doing? |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Jul 31, 2008 6:48 pm Post subject: |
|
|
| 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 |
|
|
machinegun
General User
Joined: 24 Mar 2005
Posts: 7
|
| Posted: Thu Jul 31, 2008 7:05 pm Post subject: |
|
|
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 |
|
|
|
