Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2015, 08:55 AM
ShankedS ShankedS is offline Excel Row Heights don't "take" Windows 7 64bit Excel Row Heights don't "take" Office 2010 64bit
Advanced Beginner
Excel Row Heights don't "take"
 
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
  #2  
Old 04-10-2015, 07:24 PM
excelledsoftware excelledsoftware is offline Excel Row Heights don't "take" Windows 7 64bit Excel Row Heights don't "take" Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
excelledsoftware will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 04-15-2015, 07:17 AM
ShankedS ShankedS is offline Excel Row Heights don't "take" Windows 7 64bit Excel Row Heights don't "take" Office 2010 64bit
Advanced Beginner
Excel Row Heights don't "take"
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Open Recent" and "More..." in Excel and Word BudVitoff Office 0 04-03-2015 09:17 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas jocke321 Word VBA 2 12-10-2014 11:27 AM
Excel Row Heights don't "take" Mailing: how to make the "page number" in Word is the same as "row number" in excel w Jamal NUMAN Word 1 09-03-2011 11:37 AM
Excel Row Heights don't "take" How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
"Microsoft Excel Application" missing in the "Component Services" on win08 sword.fish Excel 0 02-26-2010 02:09 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft