auto fit

  1. A

    Autofit Row Height of Visible Cells Only (including merged cells)

    I am trying to autofit the height of cells (including merged cells) for visible rows only when I have filtered a set of data. Below I've listed cell references: The range of cells A2:A19 are all merged together as one (and there are about 5 lines of text within that group of merged cells)...
  2. A

    Autofit Row Height of Cells (including merged cells) for Visible Rows Only

    Hello, I have a file that contains multiple groupings of merged cells, as well as many cells are not merged. I need to be able to filter a column and have all of the visible rows auto-fit the height so I can view all the text within (some will be merged and others will not be). I have found...
  3. F

    Autofitting row height with merged cells

    I've been doing some research trying to figure out how to solve this problem, but I'm not making much headway. I have a data analysis report. We collect data on various pieces of machinery, and our program prints the numbers into its own simple report. I paste this report onto sheet two of my...
  4. J

    Cell contents cutting off

    We have run into issues with cell contents cutting off. Even when using the auto-fit options, contents are still often cut off and with a large spreadsheet, it's time-consuming to check each cell. It primarily seems to happen to cells with a lot of text. Any thoughts? We really need to make sure...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top