+ Reply to Thread
Results 1 to 4 of 4

Seeing all the text in a worksheet cell

  1. #1
    Registered User
    Join Date
    09-22-2008
    Location
    Rhode Island
    Posts
    25

    Seeing all the text in a worksheet cell

    I have been using Excel to take research notes for some years, but my system here at work has just upgraded to Vista. It seems to work differently from Windows 97 in a very important respect. Every row in my workbook is a data point, basically, for my research. In one cell, I enter a summary of the text of the document to which it refers. Now in Windows 97, when you clicked that cell, you saw all the text you had entered, even though that covered up a good many subsequent cells. Now that does not happen and I cannot find any way to see all the text at once, either in the cell or the formula bar. This will be a huge problem if I can't fix it. Does some one know how to change a setting so that when I click a cell I will see all the text in the cell? Thank you.

    KaiserD2

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi,

    Are you using Excel 2007 as well? If you click on the drop-down arrow to the right of the formula bar this will make the formula bar deeper so you can see more text.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    09-22-2008
    Location
    Rhode Island
    Posts
    25
    I had figured that out, and that is a help; but I used to be able to see all the text in the actual cell, too.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi,

    How about double-clicking either on the right hand side of the top of the column heading or on the bottom edge of the row heading (in either case the mouse cursor changes to a two-headed arrow)

    You could also try Format > Cells > Alignment > Wrap Text

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-16-2008, 09:54 AM
  2. trying to retrieve cell TEXT not formula
    By JakeP in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-02-2008, 03:59 AM
  3. Replies: 2
    Last Post: 05-15-2007, 10:18 AM
  4. formulas in cell auto formatting as text
    By relaing in forum Excel General
    Replies: 7
    Last Post: 11-26-2006, 04:41 AM
  5. Cell References in a Formula
    By cillowjr in forum Excel General
    Replies: 0
    Last Post: 09-12-2006, 10:54 AM

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