row height

  1. L

    Autosize Row Height VBA Macro

    I have a worksheet called "Selected LP List" and on that worksheet, there are index(match()) functions in columns A:F that returns text linked to another worksheet. The problem I am having is that the rows do not automatically adjust the height so any wrapped text is cut off. Typically, column F...
  2. C

    Autoexpand Row Height on a Password Protected Spreadsheet

    Morning All, I am using Excel 2010 which I am experiencing a small problem with. I have a spreadsheet which is password protected, this spreadsheet contains a large number of formulae lifting data from another spreadsheet. When I make a selection from cell O2 I would like rows X5:Y11 to...
  3. J

    Find Text and Resize Row Height - VBA

    Hello, I am attempting to find a code that goes through all worksheets in activeworkbook and searches column C for the term "Method of Quoting:", when it is found, I would like to resize that row height to 100. Is this possible?
  4. U

    Seemingly random rows of height 0

    Hi all, I've been working on a decently sized spreadsheet (110 columns x 500 rows) with a mix of text and numbers. I have formulas, filters, conditional formatting, etc being used throughout the sheet. My problem is this: I'll be working on the spreadsheet and tend to copy across information...
  5. J

    Pivot table row height resizing on data refresh (but only in certain circumstances)

    This is a weird one. Basically, I have a pivot table and in the interest of presentation and formatting, I have set a custom row height of 24 to all rows in the sheet. At this stage, everything is fine - when I refresh or re-filter the data, styling and row heights are retained. However, if I...
  6. V

    Auto adjust row height to max height value

    Hello, I have a spreadsheet used as a tracker where column A is Priority, column B is Item, column C is Description and column D is Comments. Where most of the data entered is in the cells of column D then as the data in the cell grows, then what data is actually visible in the row currently...
  7. M

    Autofit row height with custom maximum

    I have a table that is populated by a data connection to an Access database. When there is new data available, the data can be refreshed by clicking the the Refresh button on the Data tab. One column, called 'Description', holds varying length text strings. I have set the column width and...
  8. S

    Error with Macro that Toggles Row height from default to Auto fit and back

    I originally found this thread and implemented this solution in my excel sheet with great success http://www.mrexcel.com/forum/excel-questions/726836-possible-collapse-cell-long-text.html to double click on a cell and toggle the row height from default (12.75 points) to autofit and back. I...
  9. P

    Auto Size Cells across two sheets

    I have two sheets that have data entered. Sheet 2 gets text from a particular cell on sheet 1. When I enter data on sheet 1 the cell auto fits to show the text. This does not automatically happen on the corresponding cell on sheet 2. Is there a way to have the cells on sheet 2 automatically...
  10. E

    Set Row Height According to Number of Text Lines in a Cell

    Background I regularly use Excel to contain blocks of text in a particular column. The properties of the cells in that column have word wrap selected. As text is entered and/or line breaks inserted (alt/enter), the row height normally increases automatically so that all text in the cell...
  11. D

    How to minimize wasted space in cells - optimize row height/column width?

    I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of increasing row height and autofit the width of the columns there is a lot of wasted space in my...
  12. G

    Row Height Change

    Hi all, I had some help in getting a column to change it's width temporarily and am now looking to have a row's height be changed based on the number of characters in a certain cell, G30. Past 32 characters the string goes off my printed page which all needs to be on one for audit purposes. I'd...
  13. S

    If one cell contains text, return value of another cell, if no - do nothing

    Hello, I'm looking for a "1" in A and want return value from C-1 in B. If statement does not work for me, because =IF(A2=1;C1;"") changes previous row height noticeably, when the A2=/=1. How maintain former row height?
  14. S

    How to set a column width or row height using an excel function

    I can retrieve a cell width or height using the CELL function. I would like to use this function to keep multiple sheet in sync with any reformatting done on the first sheet. Is there any Excel Function that does something like SetColumnWidth(Column,Width) or SetRowHeight(Row,Height) ? Thanks...
  15. BryanSergeant

    Selectively set row height (or hide / unhide rows) using a macro

    Hi Folks, I’m trying to write a macro to run down an Excel sheet and selectively, based on a parameter, set the row height to zero or 15. It could be expressed as: - For Rows 1 to 500 - If the value of the cell in column A for a row is 0, then set that row height to 0 - If the value of the cell...
  16. H

    Single page worksheet won't fit on page when opened on a different computer

    I've got a worksheet that our field technicians use on tablets and then send to clients. We've used Panasonic Toughpads (Win8.1) and others with no problems. The sheets look the same (and fit on a printed pdf page) on my desktop Win7 as they do on the tablets. Just picked up a Surface Pro2...
  17. P

    Autofit does not expand row height enough to display all text in cell

    I have 22 identical worksheets for a financial report used by our businesses where Col A has categories, Cols B-J are used for numbers, and Col K is for comments. Col K is configured to Wrap text (also, for 'TEXT ALIGNMENT', 'Left (Indent)' and 'Bottom' are selected). To print the report...
  18. 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...
  19. OtterlyAdorable

    Automatic Row Height with Pictures

    I'm not great with VBA, but I think it's the only way to solve this puzzle. I have a table with one picture in a particular cell that will move around. (It's a linked picture to a table, since you can't nest tables. -___- ) What I would like is this: A macro/VBA code that will BOTH expand a...
  20. M

    VBA to Autofit Row Height on multiple sheets

    I'm looking for a macro that will Autofit row height for cell ranges on select sheets in my workbook. Ideally if the macro could reference a tab with a setup table containing the sheet names and cell ranges to format I think that would work best for me. I'm having difficulty finding something...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top