Excel 2007 - Default Row Height Problem 14.4

I have an Excel problem with viewing and printing documents from Excel.    


The exact same document will view and print differently on two separate PC's.  At the bottom of one document (see screenshots) there is a large white space at the bottom while on another PC there is no space and the document fits the page perfectly.   We don't want the large space to appear.  

Please, note that I have compared every page setup and print setting such as margins,  page percentage, DPI setting and they are the exact same.  


This issue occurs on multiple machines and setups randomly in my company.    What I have noticed is is the following.    The PC's seem to render/present row height in excel differently.   I noticed the main difference between the PC's is the default row height in excel.  

The PC's that render the document with the large white space have a default row height of 14.4 when a blank workbook is created in excel.  

The PC's that render the document correctly, filling the page completely,  have a default row height of 15 when a blank workbook is created in excel.  


It seems like 15 is the true default row hight within Excel.   Although, it can depend on the font type and size used within the cell.   I am using the same font/size on both PC's.

I have no idea why some machines show 14.4 but feel that this is directly related to my original problem of displaying the excel document correctly.  


I have tried changing many settings,  uninstalling and reinstalling MS Office 2007.     Trying different Office service packs but the problem continues to happen on the PC's.   Even after completely re imaging the laptops they still show the problem,  while others of the same make/model do not.   This issue also spans across different models of our Lenovo laptops.  


Lenovo T500 or T510  - both have 15" displays
Windows 7
Office 2007 SP2  (SP1 shows the same issue on the problematic, 14.4, PC's)
Same additional third party software installed both (comes from an  image we deploy)

Sorry this is such a long question.   It is a complex and weird one that is driving me crazy.  Any suggestions or help would be appreciated.

Who is Participating?
rjpawConnect With a Mentor Author Commented:
I figured it out.   Thanks everyone for your suggestions.   The discussion got me going down the right track.    

I started thinking about font size and if a font could be different on two PC's.    All of the sudden it hit me.   The PC's showing the problem were using the "make font larger or smaller" feature found in the Windows 7 Display control panel.  

The PC's with the 14.4 row height were using the 125%  while the PC's with the 15 height were using the regular 100% setting.     When I changed the setting back down to 100%  it also rendered the problematic document mentioned in the correct way..

I wish I would have though about it earlier.   We have seen problems from this feature with some older programs but I never figured it would give Excel problems.   Now the question is how to fix it and/or prevent it from happening.    If I create a completely new document it does not have the same problem which is good.

If I figure out how to truely "fix" the document I will  post my findings here.  
...just some thoughts about fonts (yes, I saw your note about ensuring that the fonts were identical)...

1- Even when uninstalled and reinstalled, document templates sometimes persist: they too would set a font (not exactly default but acting that way).

2-  The automatic row height can vary for different fonts even though the selected font size is the same.

3- All of this default height stuff was introduced with Office 2007: that does seem to be what you are using. For Office 2003, all bets are off.

4- The default font for a fresh installation is Arial 10 point (row height of 12.75 ... I think that's 17 pixels).

5- Finally, see if there are any .XLT files in the StartUp directory. If such are present, they could be modifying the defaults.

...hope this helps...
rjpawAuthor Commented:
Thanks for the reply.  

3 - Yes we are using Office 2007 on all PC's

4 - I've seen that information posted on the web,  however, the default that our PC's all have is Calibri 11.   If I switch it to Arial 10 and type in a cell, the row height continues to be 14.4.  

5 - I have checked all of the XLStart directories that I could find but none have a template file.   My PC(which has the 14.4) did have a file called Aofrmlfn.xll file that I believed is used with an add on.   However, removing it and restarting the application does not change anything.      On that note,  I've disabled any add-ins that I knew were used with some of our third party software.     Issue still persists.  

Any other ideas?
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Try the macro below.

To install a sub in the ThisWorkbook VBA code pane:

1) Press ALT+F11
2) Find the workbook name in the VBAProject window (CTRL+R if it's not visible), and below it you will see 'This Workbook' - double click on it
3) Copy and paste the code below into the 'This Workbook' VBA code pane
4) ALT+F11 to return to the worksheet.
5) Save and close the file

When the file is next opened the Workbook_Open sub will run automatically and will set the row height in all the worksheets to 15 - change the value to suit your requirements.

Hope that helps


Private Sub Workbook_Open()
Dim ws As Worksheet

For Each ws In Worksheets
    ws.Cells.RowHeight = 15 'set value to whatever works correctly
Next ws

End Sub

Open in new window

rjpawAuthor Commented:
Thanks for the reply.  

I understand what your Macro is trying to do.   Basically just a fancy select all across all workbook sheets to set the row height value to 15.    I've tried this manually but it still does not fix my problem.    

As you'll see in the screenshots below.   Although they now have the standard 15 row height.   The machine that originally had the row height of 15 still appears longer than the machine with a default height of 14.4.    The 15 PC actually now stretches off onto a second page.   Thats why you won't see the page number at the bottom (which is not in a footer).

I just don't get it.   The file is identical.   I literally open it on one machine and then open it on the next.  


Two points if I may:

1. >I've tried this manually but it still does not fix my problem.

What does fix the problem?

2. I suggest you use MWSnap for screenshots as I'm afraid yours are illegible. You can get MWSnap free from:


rjpawAuthor Commented:
See above comment
rjpawAuthor Commented:
I figured out the answer on my own.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.