row height

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...

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...

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...

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...

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...

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...

I have a worksheet with 7 or 8 columns in it, with the source data copied from another spreadsheet. When I pasted it into my new worksheet, some rows display (and print preview also) with an extra line below the text. The font is Calibri 11 point, and the zoom is 100%. I have done a number...