Stacking text in one cell????

[jethro]

Hello all!! Is there any way to stack text in one single cell?? What I would like to do is put two part names into one cell, one on top of the other. It seems like it would be possible but I just can figure it out!!

Thanks.

Example:

Part A
Part B

 

[Brian from Maui]

Hello all!! Is there any way to stack text in one single cell?? What I would like to do is put two part names into one cell, one on top of the other. It seems like it would be possible but I just can figure it out!!

Thanks.

Example:

Part A
Part B

Have you tried using ALT + ENTER and/or Wrap Text

 

[jethro]

Thanks abunch!!! I knew It had to be simple!!!

 

[apakop]

I have similar problem but this is not my solution. With mine i want the headings to be on every page. Eg. Starting from A1 to D1, i have NO., QTY, ITEM and AMT. and have about 400 list or rows below it. How can i print to have the headings No.|QTY|ITEM|AMT fix on every A4 sheet that i print, without doing it manually.

I am waiting for the solution. Thank you for your time

 

[LegionsofMarduk]

I have similar problem but this is not my solution. With mine i want the headings to be on every page. Eg. Starting from A1 to D1, i have NO., QTY, ITEM and AMT. and have about 400 list or rows below it. How can i print to have the headings No.|QTY|ITEM|AMT fix on every A4 sheet that i print, without doing it manually.

I am waiting for the solution. Thank you for your time

Under Page Layout, click Print Titles. In the box for "Rows to repeat at top", select the row that contains your column titles. In your case, the column titles being A1-D1, select the top row so your Rows to repeat will be $1:$1. Click Ok. The row(s) you selected will now be repeated at the top of each page you print.

 

[apakop]

Wow! it worked perfectly
Thanks you very much.