row height

  1. S

    Row height - point size and pixels

    Hello, I'm having a strange problem. I have Excel 2007 installed on multiple machines in an office. On nearly every computer, a row height of 1 pixel corresponds to 0.75 points. However, on one system (a Dell laptop), a row height of 1 pixel is corresponding to 0.6 points. This ends up...
  2. E

    Display row height and column width in inches a cell

    Hello, I want to display row height in inches in a cell (the same value displayed when using page layout mode), and i want to do the same with column width. I am using Windows 7 and office 2010. I found this code: <CODE>Function Width(MyRange As Range) As DoubleApplication.Volatile Width =...
  3. S

    How can I get text on merged cells to align with single-cells in Excel 2010?

    Hello, I'm working on a dynamic spreadsheet in Excel 2010. It is a bylaws amendment document, and so each line has to be numbered. I used a center column to display the ongoing numbers. On either side, I have merged cells so that every paragraph could be in one merged cell together, but I want...
  4. J

    Auto Cell formatting when using Wrap Text

    I have a rather large list of parts that are exported from an Oracle download. When I pull this report I often have to adjsut the column width in order to read the long part descriptions. If I click on the top of the row and do wrap text to get a cells with a greater row height sometimes all...
  5. L

    Word Wrap & Autofit Row Height Stop Working if Lots of Text

    Please note: I've been researching this online for days and have found many threads with a similar issue relating to merged cells, but I'm not using merged cells, so haven't found a solution to this problem. Version: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...
  6. jan001

    row height: blending default w/autofit?

    I have a report I produce (Excel 2010) every month for management. It's usually 1200 to 1500 rows. The default height for each row is 32.50 but about 40-50% of the rows need to be "higher" than than to display all the content in certain cells. If I select Auto-Fit under Home > Cells > Format...
  7. B

    Set row height of filtered rows

    Excel 2010, Windows 7: I have this little vba routine that sets the row height on merged cells in one column of a worksheet based on the number of characters in the text string. It's not very elegant but it does what I need. The worksheet has been filtered. There may be 20 rows showing and 500...
  8. B

    Set row height based on the first 14 characters in a string

    Excel 2010; I am setting row heights on the basis of some parameters. I have the following statement; If targetCell.Value = "Photo Comment: " Then targetCell.RowHeight = 185 But what I really want is to recognize only the phrase; "Photo Comment:" in a text string that might be much...
  9. B

    Define VBA range using "counta"

    Excel 2010, I have this VBA routine that sets row heights on the basis of some parameters that begins like this; Sub setHeights() Dim targetRange As Range Dim targetCell As Range Set targetRange = Range("T18:T53") For Each targetCell In targetRange.Cells If Not...
  10. B

    Set Row height by character count

    I want to set the row height on the basis of the character count in one cell. The worksheet uses one very important cell that is merged (so the row height does not adjust automatically) and this is the cell I need to set the row height to accommodate. I can get the number of characters using...
  11. H

    Adjust cell width and height to fit print margins (no gaps)?

    Hello, I would like to adjust my cell height and width to perfectly fit a margin of: 0.75inch from right and left. 0.50inch from top and bottom. No room for header or footer. I have 5 columns and 10 rows per page. I adjust my printer margins to match the numbers above and center the prints...
  12. S

    Row height question

    How can I set row height to two lines of text as a minimum, or more if cell contents requires it? The row height should vary according to the font size. The entire worksheet will be in the same font size. Selecting the entire worksheet and increasing/decreasing font size should change the row...
  13. F

    VB Property Question

    Is there a way in VB that if a value of a cell is equal to 0, it can resize the height of row and highlight it red? If someone can point me into the direction of the height property, I can probably figure out the code. I appreciate any help.
  14. T

    Automatic height in detail section

    I haven't used Access before and am trying to generate a Report from a Query. I have built the Report successfully, however am having trouble adjusting the height of the rows in the Detail Section. I want the row height to fit the text, if there are two lines in the row, then have an...
  15. K

    Autofit row height w minimum

    Sub CCAutofit() Dim rRow As Range With Range("RngOrders").Select Rows.AutoFit For Each rRow In .Rows If rRow.RowHeight < 20.25 Then rRow.RowHeight = 20.25 Next rRow End With End Sub What is wrong here? I want to autofit all the row heights, but keep the...
  16. SonGunnar

    Insert Page Breaks and Adjust Rows XL2003

    Problems: Groups of data should not split at inserted page breaks. Row heights vary at the 3rd and 5th row of each 7 row group. Typical pages have between 4 and 6 groups. Average projects contain 10 - 50 pages, or 40 - 250 groups. What I am trying to do is adjust the height of every 5th and 7th...
  17. S

    Fixed Column Width/Autofit Row

    Does anyone know of or have a VBA code that enables you to fix column width yet autofit rows?! I would like columns E:G to have their width fixed to 75, yet still allow rows E12:G16 to autofit. I was previously using the following so that columns E:G autofitted, as and when data was pulled...
  18. T

    Rowheight Change: Macro or Cond Format?

    I want to (i) select a row; (ii) check for text; (iii) if blank; (iv) change the row height to a specified value. What is the best way to do this? Macro? Thanks for your help, Excel Novice.
  19. D

    Macro change row height based on row above

    I'm amending a workbook someone else created and I'm brand new to VB. I've got a table that has over 200 rows and the users enter information into the rows over a year. The creator of the sheet has set it up so there is a "z" in the second cell of each row and as this cell is overtyped with...

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