+ Reply to Thread
Results 1 to 3 of 3

Adding multiple lines of text within one cell

  1. #1
    Michael
    Guest

    Adding multiple lines of text within one cell

    Is there a way, in excel, to add multiple lines of text to a cell?
    For example, I want to add a few bullet points (need hard return) but I want
    them to all appear within one cell.

    Thanks!


  2. #2
    JulieD
    Guest

    Re: Adding multiple lines of text within one cell

    not sure about the bullet points bit .. but ALT & ENTER will give you a line
    return within a cell.

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "Michael" <[email protected]> wrote in message
    news:BE8BDB15.5157%[email protected]...
    > Is there a way, in excel, to add multiple lines of text to a cell?
    > For example, I want to add a few bullet points (need hard return) but I
    > want
    > them to all appear within one cell.
    >
    > Thanks!
    >




  3. #3
    Gord Dibben
    Guest

    Re: Adding multiple lines of text within one cell

    Michael

    ALT + 0149 for a bullet then type some text and ALT + ENTER

    ALT + 0149 for a bullet then type some more text and ALT + ENTER

    ALT + 0149 and on and on.

    When you want out just hit ENTER

    Format for wrap text and autofit.


    Gord Dibben Excel MVP

    On Wed, 20 Apr 2005 10:10:29 -0700, Michael <[email protected]> wrote:

    >Is there a way, in excel, to add multiple lines of text to a cell?
    >For example, I want to add a few bullet points (need hard return) but I want
    >them to all appear within one cell.
    >
    >Thanks!



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1