Excel 2007 printing defaults

Posted on 2011-10-20
Medium Priority
Last Modified: 2012-05-12
How can I set default print settings in Excel 2007 to always print with the "scale to fit" setting?
Question by:hindsight
  • 3
LVL 11

Accepted Solution

ScriptAddict earned 500 total points
ID: 37002620
Only thing that I can think of off hand is to add some vba that captures when you create a new worksheet and automatically sets it to scale to a single sheet.

I would store this on my personal worksheet(this opens hidden every time you open Excel, so it would always be working)

My understanding of the way Excel works is that these values are null until specifically assigned.

Here is the vba to assign a worksheet to print to a single page.

With ActiveSheet.PageSetup 
    .TopMargin = Application.InchesToPoints(0.2) 
    .BottomMargin = Application.InchesToPoints(0.5) 
    .LeftMargin = Application.InchesToPoints(0.17) 
    .RightMargin = Application.InchesToPoints(0.18) 
    .HeaderMargin = Application.InchesToPoints(0) 
    .FooterMargin = Application.InchesToPoints(0) 
    .Orientation = xlPortrait 
    .CenterVertically = False 
    .FitToPagesWide = 1 
    .FitToPagesTall = 1 
End With 
End Sub 

Open in new window

LVL 11

Assisted Solution

ScriptAddict earned 500 total points
ID: 37002629

Looks like we might need a

.Zoom = False 

Open in new window

in there as well.
LVL 11

Assisted Solution

ScriptAddict earned 500 total points
ID: 37002745
I suppose you could just:
Open a new workbook. Customize as you wish. File>Save
As Type: *.XLTX


Excel will add the .XLTX to save as BOOK.XLTX
Save this workbook in the XLSTART folder
C:\Documents and Settings\ProfileName\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLTX in XLSTART folder also. It now becomes
the default Insert>Sheet.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

864 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