Stacking text in one cell????

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Stacking text in one cell????

  1. #1
    New Member
    Join Date
    Feb 2004
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Stacking text in one cell????

     
    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

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Stacking text in one cell????

    Quote Originally Posted by 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
    Have you tried using ALT + ENTER and/or Wrap Text

  3. #3
    New Member
    Join Date
    Feb 2004
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    New Member
    Join Date
    Sep 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Stacking text in one cell????

    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

  5. #5
    New Member
    Join Date
    Jul 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Stacking text in one cell????

    Quote Originally Posted by apakop View Post
    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.

  6. #6
    New Member
    Join Date
    Sep 2013
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Stacking text in one cell????

      
    Wow! it worked perfectly
    Thanks you very much.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com