Excel 2007 - Default Row Height Problem 14.4

Posted on 2011-02-21
Medium Priority
Last Modified: 2012-05-11
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.

Question by:rjpaw
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2

Expert Comment

ID: 34945154
...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...

Author Comment

ID: 34945385
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?
LVL 45

Expert Comment

ID: 34945724

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 34945909
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.  

LVL 45

Expert Comment

ID: 34945961

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:



Accepted Solution

rjpaw earned 0 total points
ID: 34946964
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.  

Author Comment

ID: 34947002
See above comment

Author Closing Comment

ID: 34986560
I figured out the answer on my own.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question