View Single Post
 
Old 04-10-2015, 07:24 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
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