Cursor "new line and carriage return" - SOLVED

phaedra · General User Joined: 11 Jun 2007 Posts: 18

Hi to all, after a little search in the old posts, i haven't found any answer to my question.

How can i, when i finish my row data insertion, with a combo of keys, make the cursor go back to the left start of the row and go down in the under row? I think in excel this is a little automated...

Thanks! Shocked

Mark B · Posted: Mon Mar 31, 2008 5:28 am Post subject:

Hi

<CTR><Left Arrow> will take you to the 1st column, and then (obviously) <down arrow> will move you down one row.

Mark
_________________
Mark B's Articles

phaedra · General User Joined: 11 Jun 2007 Posts: 18

Surely, this is quite simple, but not what i'm searching for...

I don't want to make 2 actions, i need to make (ex Ctrl+Enter) a combo of keys to make it in one move...

keme · Posted: Mon Mar 31, 2008 5:37 am Post subject:

This works like a charm in 2.4. Use tab to skip to next cell. Calc remembers where you started, so when you hit Enter, you're on the cell below the start of your "tab series". IIRC it didn't work like that in previous versions.

For any version, a quick way to define a temporary data entry range:
Just select the range. Enter your data and hit tab to move right (wraps to next row when it reaches the right edge) or hit enter to move down (wraps to next column when it hits the bottom. The range dissolves as soon as you use the mouse or an arrow key.

To make such a data entry range permanent, select the range like above, then remove cell protection (menu item Format - Cells..., tab Cell protection, untick Protected). To activate that range (limit data entry to unprotected cells), select menu item Tools - Protect Document - Sheet.

phaedra · General User Joined: 11 Jun 2007 Posts: 18

Yeah that's works fine (in 2.4)... thank you very much ! Very Happy