I'm trying to adjust some row heights in Excel 2010, but when I attempt to make the changes, it doesn't give me any error messages. However, if I check the row height after, if it doesn't "take" it will be some other row height that I didn't want. For instance, it will be .19 instead of .2 or .32 instead of .34. The problem is that I have very exact measurements in order to get these heights to match up with the page it's printing on.

When I did a quick Google search for the issue, I saw something about going to "format" and "cell size" to uncheck "autofit row height". However, when I click on "format cell" the only tabs I get are "number", "alignment", "font", "border", "fill", and "protection".



On the ribbon bar there's a "format" with a down arrow, if I click on it, it expands and has a cell size as well as the "autofit row height" option, which is unchecked. If I click on it, it doesn't check off, it just executes the function to autofit the row height.

How can I tell Excel to stop doing this?

Row height is done in Pixels.
1 = .75, 2 = 1.5, 3 = 2.25, 4 = 3 following this same pattern you can see that .75 is added for each pixel. Now I dont know for sure if this is the case in newer versions of Excel but I think it is. I have used several methods to match up row heights to print off templates and have only seen 1 particular technique to be effective.

Open a new worksheet and set the font for all cells to 6 set the height at 9 and the width to 1 (12 pixels for each) for all cells.

Now the fun part

You need to put the actual row numbers in cells A1 to A100 (or however far down your sheet goes) and the the actual columns in A1 to IV1 (again however far you need to go)
Set a a border to the current page that is grey and dotted so you can easily see the border but not lose it if you write on the page.
Now print out this page and put it on top of the template you are trying to match. Using a highlighter mark the areas that you need to have boxes, tables lines etc. Then you can go back to your excel document and set it up like you have highlighted. Thats why you put the A through IV and 1 through 100.

Let me know if you have any questions.

Thanks

Maybe I'm misunderstanding your response, but one thing I should clarify is that there's already a page with all of the proper row heights. What I was trying to do was expand on this in the same document with a number of additional pages, all set up the same as the first. I'm basically copying the row heights from that page, but they're not sticking.

Is it possible that it could be a font issue? Ergo, the font sizes for the rows in the first page, which I'm working off of, are all set correctly, but then in subsequent rows I haven't adjusted, and thus they readjust after I set them?