Excel Tip: Change Excel Default Settings

If you find that every time you create an Excel worksheet you need to change settings, such as margin, number format, typeface, footer, column width, etc., and these changes are the same for each of your worksheets, you may want to simply make changes in the new worksheet defaults.

To create new default settings in Excel, follow these steps:

  • 1. Open a blank workbook.

  • 2. Without entering information in the cells, make all the formatting adjustments that you want to incorporate into your future workbooks.

  • 3. Choose File, Save. The Save As window will appear.

  • 4. Enter Book as the name of this file.

  • 5. Change the Save in location to the XLStart folder, which is a subfolder of the Excel folder. The location of the Excel folder will vary depending on the way in which your Excel program was installed. If you use Excel on a network, there will be an XLStart folder on your hard drive and also one on your network. Check with your network administrator before saving a file to the network folder.

  • 6. In the Save as type area of the Save as window, choose Template.

  • 7. Click the Save button.
  • From this point forward, each time you open a new workbook in Excel, the workbook will incorporate your chosen default settings.

    If you know someone who would like this tip, click here to send it to a colleague or client.

    View more helpful tips!

    You may like these other stories...

    By Jason Bramwell When CPA Barry MacQuarrie started the SocialCPAs Social Media Survey in 2010, he said social networking was still relatively new to the accounting profession. The self-proclaimed "social media...
    By Jason Bramwell In an effort to address the increased demand for comprehensive and intensive training on eXtensible Business Reporting Language (XBRL), the American Institute of CPAs (AICPA) and XBRL US Inc., the not-...
    By Lauren Prosser, Director of ProfitCents Professional Services, Sageworks Staffing is among the top management issues facing CPA firms, according to a recent survey by Sageworks, a financial information company. That...

    Upcoming CPE Webinars

    Apr 22
    Is everyone at your organization meeting your client service expectations? Let client service expert, Kristen Rampe, CPA help you establish a reputation of top-tier service in every facet of your firm during this one hour webinar.
    Apr 24
    In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
    Apr 25
    This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.
    Apr 30
    During the second session of a four-part series on Individual Leadership, the focus will be on time management- a critical success factor for effective leadership. Each person has 24 hours of time to spend each day; the key is making wise investments and knowing what investments yield the greatest return.