Quattro Pro Spreadsheet

[Trevor]

I have set up a Quattro Pro Spreadsheet when I input invoice details with one invoice with 6 fields per spreadshhet row. When I come to column 6 in the row and then want to start inputting details for the next invoice I want to hit RETURN and move to the first cell (Column A) in thye next row.

At the moment no matter what settings I use or key combinations all I appear to be able to do is either move one cell to the right on the same row (Column 7) or move down one cell (Column 6 in the next row).

How do I get it to move to Column A in the next row ?

Trevor

[Prew]

Don't think you can change the Return key to do this; however, you can write a macro to do this with another key.

This is how I do it:

Open Sheet B (on the spreadsheet with the data you are using), click on a cell E2

Type in ~{D1}{END}{L}

Click on Cell D2; type in '\B

Click on E2 again (the macro cell)

Click in menu bar: Insert:Name:Cells

The box should say \B

Click Add then Close

Now open Sheet A

Now hitting Ctrl/Shift/B at the same time should move the cursor one row down and back to Column A.

Note: you can change B in the above to any letter you prefer.

[Trevor]

Thank you for the above. A few queries though as I have never used macros before.

1. Do I type in the letters E N D or hit the END key on keyboard

2. Do I use ( or { brackets

3. An added complication, while I only key in 5 fields for each invoice (Cols A, B, C, D & E, columns F - M are used in each row to list the invoice amounts in certain colums so the first colums I do not use is N.

4.

[Trevor]

Thank you for the above. A few queries though as I have never used macros before.

1. Do I type in the letters E N D or hit the END key on keyboard

2. Do I use ( or { brackets

3. An added complication, while I only key in 5 fields for each invoice (Cols A, B, C, D & E, columns F - M are used in each row to list the invoice amounts in certain colums so the first colums I do not use is N.

4. The first invoice is input in ROW 6.

Please can you re clarify the details taking above into account.

Very Many Thanks.

Trevor

[Prew]

Type it in as written: { not [ and END not end key (just try copy and paste)

This macro is typed in sheet B (or any other sheet you want)

The cursor does not have to be in an empty cell to work. Anytime you press crtl/shift and B at the same time the cursor will move to column A one row down.

Corel really should have included an easier option to do this.

[Trevor]

Perfect !!

Very many thanks.

Trevor