ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make rows in a table more than one line (https://www.excelbanter.com/excel-discussion-misc-queries/237101-make-rows-table-more-than-one-line.html)

caro

Make rows in a table more than one line
 
In 2003 version, you created a table and enter more than one line in a row.
For example I have one contrator who has ordered 3 different items and I want
to keep them all in a block (one row). EX:
Contractor Item # Price Date Req'd
JMP 33333 25.30 7 /10/09
JMP 44444 50.00 8/1/09
JMP 55555 100.00 9/1/09

and then move on to next row. But when I hit enter or return key, it moves
me to the next row down.

Jim Thomlinson

Make rows in a table more than one line
 
You can add a carriage return to a cell using Alt+Enter, but for your
purposes it is not a great idea. When you do that the numbers are stored as
text, so you will not ba able to do any math functions on them.
--
HTH...

Jim Thomlinson


"Caro" wrote:

In 2003 version, you created a table and enter more than one line in a row.
For example I have one contrator who has ordered 3 different items and I want
to keep them all in a block (one row). EX:
Contractor Item # Price Date Req'd
JMP 33333 25.30 7 /10/09
JMP 44444 50.00 8/1/09
JMP 55555 100.00 9/1/09

and then move on to next row. But when I hit enter or return key, it moves
me to the next row down.



All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com