I piece together weekly reports for my team.
I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels.
To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...
Everyone is familiar with the "Paste Column Widths" command that will take information from the clipboard and use it to transfer the column widths of a copied range to another range without including the actual data from the cells that were copied. Thus, it seems to me that when a range of...
I need to set the row height of specific rows, starting at Row 33 and ending at Row 2208, with the offset of each row from the last being 29.
It must only perform the row height change if there is a value in the previous cell in column B.
i.e.
Set Row Height for Cells B33, B62, B91, B120...
Can Excel Top Gun here help a rookie out and let me know if there are a better/faster way to perform the same action?
This code works, but its slow and can take around 3-4 minutes on a laptop with i7 12th Gen processor & 64Gb RAM.
The process is to hide the entire row if the respective cell in...
Hi there,
I am trying to hide rows in a spreadsheet with no success and am hoping a macro will help. I have the first column with the date but do not want any lines which are the following month to show. In the image all rows are needed however for a shorter month they are not. I want to add a...
Is there a way to ensure the text in a cell wraps & automatically the row height adjusts? Right now I find the I can the text to wrap but I have to manually adjust the row height or the text gets cut off but the cell bottom.
I've spent some time searching the forums here and while there are many similar queries, nothing quite fits for me.
I have a two column multi row table. Column A is a list of names, and Column B is every job that person will do, therefore all the items in Column A are a single name, but each...
I am trying to Autosize Row height based on Visible cells only and not the Hidden columns. I have columns that has very long text that I will be hiding and then I am left with extra white space in other cells and extra long worksheet.
I tried formatting the Autofit cells Row height but, it...
Im updating a sheets rowsize but when its saved, the size of each row isnt adjusted. Any Ideas?
Thanks
wb.Sheets(1).Range("U:U").ColumnWidth = 10.56
wb.Sheets(1).Range("W:W").ColumnWidth = 50
wb.Sheets(1).Range("X:X").ColumnWidth = 50
Set targetRange = Range("A:A")
For...
Is there a way to get a row to resize if it is below acertain height?
I have my rows in a range set to 38 but I have them autofitting once the day is entered in case the row needs to be taller.
Is there a way for this to either only resize if it is goingto make it taller OR after the AUTOFIT...
I have a complex spreadsheet which has a summary report. There are perhaps 200 populated rows on the summary, but for clarity I wish to set row height to hidden or 1 based on what is in the row. For example, in row 45 if cell B = " " I would like that row hidden or compressed. Row 46 may appear...
Hi,
I'm looking for help on finishing up my gnatt chart by applying a format to widen row height based on an input cell.
For instance, the row height would adjust for the project schedule phase, based on the number of staff assigned (entered in a column for that same row) that would...
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)...
Hey all,
Remember I did this years ago, but now I cant get it to work, nor find a similar question in the forum. I'm generating a list where the cell content change a lot from row to row depending on the user input. The list is mainly generated via validation lists, sometimes there's a lot of...
Is it possible to create an excel style to force row height?
In the spreadsheet I am working on I use a row height of 8 and a specific color to separate specific data sets.
When I begin to input the next data set I skip a row to input data in subsequent rows.
Then I go back and adjust the height...
Here's my situation. I have a text box in column A. In the columns to right is where my data is entered. Sometimes the data in those cells are wrapped into multiple lines, which automatically increases the row height of those cells. I have no problem with those cells adjusting their row height...
I have a number of large spread- sheets. I need to format the row height of every fourth row to 24.00
I have the macro below which doesn't work. Can anyone fix it please?
Sub Height()
X = 0
Do
X = X + 4
Rows(X).RowHeight = 24
Loop Until X = 1000
End Sub
Thanks Steve..:mad:
I have a worksheet that contains two cells that are populated via a series of nested IF statements based on the contents of another cell. The issue is that one of the statements generates a MUCH longer text string than the other two options. To make the text appear aesthetically pleasing, the...
Hello there everyone, i recently came upon something that im not able to figure out and haven't had any luck after searching a bunch for my particular issue..
my dilemma is that ive created a table so that you can re order based on certain columns and data, etc. and within this table i have...
Hello experts,
I have a workbook with the same kind of data in about 30 different worksheet tabs. I want to make all of the rows with data in each worksheet be reformatted with a row height of 30, unless the content is larger than 30 then it needs the entire row to be autofitted. I have code...
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.