Create a new workbook

A Microsoft Office Excel workbook is a file that contains one or more worksheets that you can use to organize various kinds of related information. To create a new workbook, you can open a blank workbook. You can also base a new workbook on an existing workbook, the default workbook template, or any other template.

What do you want to do?

Open a new, blank workbook

Base a new workbook on an existing workbook

Base a new workbook on a template

Open a new, blank workbook

  1. Click Microsoft Office Button Office button image, and then click New.

  2. Under Templates, make sure that Blank and recent is selected, and then under Blank and recent in the right pane, double-click Blank Workbook.

    Keyboard shortcut  To quickly create a new, blank workbook, you can also press CTRL+N.

Tips

  • By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain under When creating new workbooks on the Popular tab in the Excel Options dialog box (Microsoft Office ButtonOffice button image, Excel Options button).

  • You can also add and remove worksheets as needed.

    For more information about how to add or remove worksheets, see Insert or delete a worksheet.

Top of Page

Base a new workbook on an existing workbook

  1. Click Microsoft Office Button Office button image, and then click New.

  2. Under Templates, click New from existing.

  3. In the New from Existing Workbook dialog box, browse to the drive, folder, or Internet location that contains the workbook that you want to open.

  4. Click the workbook, and then click Create New.

Top of Page

Base a new workbook on a template

  1. Click Microsoft Office Button Office button image, and then click New.

  2. Under Templates, click Installed Templates or My templates.

  3. Do one of the following:

    • To use an installed template, under Installed Templates, click the template that you want, and then click Create.

    • To use your own template, on the My Templates tab, double-click the template that you want.

      Note   The My Templates tab lists the templates that you have created. If you do not see the template that you want to use, make sure that it is located in the correct folder. Custom templates are typically stored in the Templates folder, which is usually C:\Users\user_name\AppData\Local\Microsoft\Templates in Windows Vista, and C:\Documents and Settings\user_name\Application Data\Microsoft\Templates in Microsoft Windows XP.

Tips

  • To obtain more workbook templates, you can download them from Microsoft Office Online. In the New Workbook dialog box, under Microsoft Office Online, click a specific template category, click the template that you want to download, and then click Download.

  • For more information about how to create your own templates, see Create and use an Excel template.

Top of Page

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language