+ Reply to Thread
Results 1 to 3 of 3

How to open a wrapped text cell to first character

Hybrid View

  1. #1
    Registered User
    Join Date
    12-12-2009
    Location
    edmond okla
    MS-Off Ver
    Excel 2007
    Posts
    6

    How to open a wrapped text cell to first character

    hello - I have to edit text cells (lots of them) containing approximatley 40 lines of text (screen width) - generally the edit will be done on lines 1-5

    When I click on a cell, Excel is opening approximately half-way thru the text

    I have to Ctrl Home to get to first line on each cell.

    Is there a way I can set Excel 7 so that it opens the cell on the first line, first character of the text?

    thanks
    george
    Last edited by vandelia; 12-12-2009 at 07:07 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: How to open a wrapped text cell to first character

    You need to change the vertical alignment to Top Align. Select all the cells then click the top left icon on the Alignment part of the ribbon.

  3. #3
    Registered User
    Join Date
    12-12-2009
    Location
    edmond okla
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: How to open a wrapped text cell to first character

    thanks, I searched hi-low excel help and couldn't find that and obviously didn't think of it, makes me feel really dumb.
    thanks again
    george

+ 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