General discussion

  • Creator
    Topic
  • #2316780

    Excel rows problems with resizing

    Locked

    by pdown ·

    One of my users has an Excel spreadsheet that resizes the rows to the text contents and others rows that won’t. It seems that he always has one added line at the bottom of the row. There are no extra lines in the cell and all cells in the row, but this one, are clear. I have even used the paint brush to copy the formatting from a cell that works correctly. That did not help. Any suggestions on how to fix?

All Comments

  • Author
    Replies
    • #2739171

      Reply To: Excel rows problems with resizing

      by dklippert ·

      In reply to Excel rows problems with resizing

      Try using the TRIM() function to make sure there are no extra characters

      • #2739468

        Reply To: Excel rows problems with resizing

        by pdown ·

        In reply to Reply To: Excel rows problems with resizing

        I tried the Trim function and this did not work because it said I got a message that the formula was too long. Any other suggestions?

    • #2739435

      Reply To: Excel rows problems with resizing

      by dklippert ·

      In reply to Excel rows problems with resizing

      Assuming the data is in the A column, choose an empty column and enter the formula
      =TRIM(A2)
      Copy the formula down the column.
      How much text is being entered?
      While 32,767 characters can be entered in a cell, only 1,024 will be displayed.

    • #3378452

      Reply To: Excel rows problems with resizing

      by caramia ·

      In reply to Excel rows problems with resizing

      The answer may be easier than trimming. In File – Page Setup on the Page tab, if you have chosen
      “Fit to 1 page wide by 1 page tall” to force the data onto one page, Excel will automatically resize any larger fields to fit within the page.
      I find it better to choose the other scaling choice and then drag the page breaks to where I want them in Page Break Preview.

Viewing 2 reply threads