+ Reply to Thread
Results 1 to 4 of 4

Need to see full value returned by a formula without having to expand column.

Hybrid View

Textoph Need to see full value... 06-13-2012, 02:12 PM
Cutter Re: Need to see full value... 06-13-2012, 05:42 PM
Textoph Re: Need to see full value... 06-13-2012, 08:33 PM
Cutter Re: Need to see full value... 06-19-2012, 12:16 PM
  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Exclamation Need to see full value returned by a formula without having to expand column.

    Please see the formula starting in cell D4. When the result of this formula is true I would like to be able to see the entire value that is returned without having to expand the cell. What would be the best way to accomplish this? Any help with this would be greatly appreciated.
    Attached Files Attached Files
    Last edited by Textoph; 06-13-2012 at 04:08 PM.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Need to see full value returned by a formula without having to expand column.

    Try doing this:
    Select the range you want this to apply to and then
    on the ribbon - click Home > in the cells section click Format > click AutoFit Column Width

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Need to see full value returned by a formula without having to expand column.

    Thanks, but this doesn't work because it changes the column width. I would like to keep the columns at the same widths.

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Need to see full value returned by a formula without having to expand column.


+ 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