Page 1 of 1

How to go back to the first column?

Posted: Thu May 15, 2008 8:52 am
by mrwitoon
When I key data in row to the last column by using tab to move to each column and begin a new row with Enter, which in Excel it will come to the first column I start but in OO it only come down in the last column. How can I go back to the first column by only press Enter as in Excel?

Thanks in advance.
Witoon

Re: How to go back to the first column?

Posted: Thu May 15, 2008 9:15 am
by keme
With Open Office version 2.4, enter will move to the cell below where you started the tab sequence, which is exactly like Excel 2003 does.

Any version: If you are inputting in a rectangular range, just select the range first, and only use tab. Tabbing "across the border" will take you to the start of the next row. (Enter moves down, so if you pass the lower border of the selected range by that method, you will be taken to the start of the next column.)