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 the File tab.
  1. Click New.
  2. Under Available Templates, 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.

For more information, see Change the number of worksheets in a new workbook.

  • 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 the File tab.
  1. 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 the File tab.
  1. Click New.
  2. 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 Top of Page

 
 
Maikakapit sa: