Excel Tip: Change Excel Default Settings | AccountingWEB

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!

    Wait, there's more!
    There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
    Premium content is currently locked

    Editor's Choice

    WHAT KIND OF FIRM ARE YOU?
    As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
    This is strictly for internal use and data will not be sold
    or shared with any third parties.