How to go back to the first column?

Discuss the spreadsheet application

How to go back to the first column?

Postby mrwitoon » Thu May 15, 2008 8:52 am

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
mrwitoon
 
Posts: 2
Joined: Thu May 15, 2008 8:43 am

Re: How to go back to the first column?

Postby keme » Thu May 15, 2008 9:15 am

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.)
Apache OO 3.4.1/4.1.2/4.1.3, on Ms Windows 7/10 and Mac OS-X 10.8.5 and 10.11.
LibreOffice 4.3.3.2 on Mepis Antix MX 14
User avatar
keme
Volunteer
 
Posts: 3367
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests