Help with Quattro Pro

[Trevor]

I have created a spreadsheet in Quattro Pro where I enter invoice details in colums A-E and after entering the value in column E I want to jump to the beginning of the next line (Column A) to start entering the details of the next invoice there.

If I hit RETURN when in Column E it brings me to Column E on the next line how do I get it to jump each time to Column A in the next line ?

Thank you in advance.

Trevor

[LawyerRon]

I've never used Quattro Pro but try hitting "tab" instead of enter and see what it does.

[Trevor]

If you hit TAB it just takes you to the next cell on the right ie F.

Trevor

[PMich]

Try hitting return to go to the next cell down in column E and then the home key to go back to column A. I know this works in Excel and I am only assuming it will work in QPro

[MadMax]

You could Insert a QuickButton. Right click on the button, then click Button Properties. In the Macro tab enter the following .....

{L 4}{D 1}


You can relocate the button as needed.

[Prew]

Home key will just send the selection to A1.

A simple macro may help you out

In your spreadsheet open Tab B, then click on one of the cells (i.e., E2), then type in :
~{D1}{End}{L}
in the cell before the macro (i.e., D2) type in '\B (note the ' before the \ )

Then go to the menu: Insert\Name\Name Cells

Select \B and click add, then close.

Now, pressing Crtrl Shift B anywhere in the spreadsheet will move the selection one row down and back to the first column.

I find this routine to be especially usefull when entering many columns of data.