View Single Post
 
Old 04-07-2015, 08:55 AM
ShankedS ShankedS is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default Excel Row Heights don't "take"

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?
Reply With Quote