row height problem

I've been racking my brain for a long time on this and I'm absolutely stuck. I have a unique excel file with some issues that I just can't figure out. I have a worksheet, "Form", with drop down user selections, that copies the selection into a second worksheet, "Final" (Final!A22:A25=Form!B3...

Through research I understand that there is no formula to adjust row height, so now my question ventures into VBA: In my workbook employees enter data into Cell B68 of worksheet DATA and that data is populated into merged Cell D8:J9 of worksheet V1. This happens for every "V" worksheet, of...

I cannot get the rows and columns to auto format to the correct size in my spreadsheet, in order to show the full contents of the cell. It is only in this particular file, auto formatting does work in all other spread sheets. I have text wrap enabled, but double clicking or auto formatting...

I am sure this is a problem for a lot of people - you create a cell, type some stuff into it and even though text wrapping is on, the row height does not resize based on the cell contents. It is not a big deal but it gets to be a pain to stop what you are doing and click and drag the row height...

I have an excel workbook that has a number of cells that are merged across, which I know has inherent issues for row height automatically re-sizing. I have gone in and manually set the row height, but they keep collapsing just a little bit so that you can no longer see all of the contents of...