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 , 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 the File tab.

  2. Click New.

  3. Under Available Templates, double-click Blank Workbook.

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

Tips

Top of Page

Base a new workbook on an existing workbook

  1. Click the File tab.

  2. Click New.

  3. Under Templates, click New from existing.

  4. 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.

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

Top of Page

Base a new workbook on a template

  1. Click the File tab.

  2. Click New.

  3. Do one of the following:

    • To use one of the sample templates that come with Excel, under Available Templates, click Sample Templates and then double-click the template that you want.

    • To use a recently used template, click Recent Templates, and then double-click the template that you want.

    • To use your own template, on the My Templates, and then on the Personal Templates tab in the New dialog box, double-click the template that you want.

      Note   The Personal 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.

Tip    To obtain more workbook templates, you can download them from Microsoft Office.com. In Available Templates, under Office.com Templates, click a specific template category, and then double-click the template that you want to download.

Top of Page

Applies To: Excel 2010



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