+ Reply to Thread
Results 1 to 1 of 1

Autofit does not work with wrapped text in a table

  1. #1
    Registered User
    Join Date
    08-25-2017
    Location
    At, Home
    MS-Off Ver
    2016
    Posts
    5

    Autofit does not work with wrapped text in a table

    I have a table with dates in one column and the description in another. I created a formula for the description to include the date [ex: ="Description "&"("&A4&")" where A4 is the cell with the date; it would appear in the cell as Description (8/25/3000)]. Many of the descriptions are the same but with different dates. This formula works for the most part except for one particular document type (pay stubs) that I copy.

    The pay stubs cell is usually three lines when I copy the formula. But when it pastes, it's only two lines. I unwrap and rewrap the cell which usually fixes the problem but it doesn't work. The strange thing is, when I copy an earlier pay stub cell it works (ex: copy cell B20 to B130). But if I copy the new cell (ex: B130) and paste into a different cell (ex: B185) it won't autofit. I have all the rows set to autofit but it doesn't work for this pay stubs. I think there may be some incompatibility issues because the earlier working cell (B20) was done on my computer at home and I'm working on my laptop.

    I would share the excel document itself but it has sensitive information and I can't share it. I tried to replicate the problem in a new blank excel document but the problem wasn't transferring into the new document. I even copied the cells that weren't working (B130) but when I unwrapped and rewrapped the cell, the autofit worked. I have no idea where this problem came from but it's really frustrating.

    Edit: solved the problem. The date was not set to Date format. That seems to have fixed the problem
    Last edited by ehh-cellent; 09-08-2017 at 09:51 PM. Reason: solved the problem

+ 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. Intelligent Column Width with Wrapped Text NOT AutoFit
    By diakonos1984 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2013, 01:37 PM
  2. Autofit a row of merged cells that have wrapped text.
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 11-13-2009, 08:41 AM
  3. Replies: 4
    Last Post: 05-31-2006, 05:15 PM
  4. [SOLVED] Autofit in cells with multiple lines of wrapped text.
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2006, 03:10 PM
  5. RE: Autofit in cells with multiple lines of wrapped text.
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2006, 11:35 AM
  6. Replies: 0
    Last Post: 10-21-2005, 10:05 AM
  7. Autofit Column Headers with wrapped text (Not a merged cell issue)
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2005, 08:05 PM
  8. Replies: 3
    Last Post: 05-22-2005, 08:06 PM

Tags for this Thread

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