Excel 2007 printing defaults

Posted on 2011-10-20
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
    LVL 11

    Accepted Solution

    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


    Looks like we might need a

    .Zoom = False 

    Open in new window

    in there as well.
    LVL 11

    Assisted Solution

    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

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now