Create a new workbook

A Microsoft Office Excel workbook is a file that contains one or more worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) 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 (default workbook template: The Book.xlt template that you create to change the default format of new workbooks. Excel uses the template to create a blank workbook when you start Excel or create a new workbook without specifying a template.), or any other template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.).

What do you want to do?


Open a new, blank workbook

  1. Click Microsoft Office Button 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 Button 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 Top of Page

Base a new workbook on an existing workbook

  1. Click Microsoft Office Button 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 Top of Page

Base a new workbook on a template

  1. Click Microsoft Office Button 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 Top of Page

 
 
Applies to:
Excel 2007