Excel questions

Cabana

Senior member
Mar 29, 2001
491
0
0
Is it possible to do this? I'm making an invoice and it'd be nice to just keep tabbing from one field to the next until the end of the line, where tab would then go down the beginning of the next line.
 

RayH

Senior member
Jun 30, 2000
963
1
81
I believe if you lock the sheet and leave the input cells unlocked, tabbing will cycle you though the unlocked cells.
 

Cabana

Senior member
Mar 29, 2001
491
0
0
That worked perfectly, thank you. I have another question now.

I set up the invoice so the price for each item is on the right which is a product of the quantity and price in the same row. Is there a way to make enter or tab insert another line with the same formula as the line above? This way more items can easily be added to the list while retaining the formula.

Also, I set the description column to wrap text, but only the first line shows up in the main window. When I edit it through the top entry, it shows all the lines. How do I get them to show up when printing? I tried setting it to auto-height in the hopes it'd adjust the row to the height of the cell, but nothing happens.
 

RayH

Senior member
Jun 30, 2000
963
1
81
You could just pre-populate the column with the formula ahead of time and if you don't want to display all the zeros or errors, you can either format the result to not display zeroes, use conditional formatting to not display the results if there are no inputs or use an IF statement in the formula to not display results if there are no inputs.

Not sure what the problem is with the printing. Is it printing different from what you see on the screen? Typically after changing the format of a cell or column of cells to wrap text, adjusting the column width will force the row height to automatically update.