How to insert and delete Excel 2007 worksheets

Source: Internet
Author: User

By default, Microsoftofficeexcel provides three worksheets in one workbook worksheet: The primary document for storing and processing data in Excel. Also known as spreadsheets. Worksheets are made up of cells that arrange rows or columns. The worksheet is always stored in the workbook. , but you can insert other worksheets (and other types of worksheets, such as chart sheets, macro worksheets, or dialog sheets) or delete them as needed.

If you have access to the worksheet templates Template: A workbook that was created as the basis for other similar workbooks that you created or officeonline. You can create templates for workbooks and worksheets. The default template name for the workbook is Book.xlt, and the worksheet's default template name is Sheet.xlt. , you can create a new worksheet based on that template.

The name of the worksheet (or caption) appears on the Sheet tab at the bottom of the screen. By default, the name is Sheet1, Sheet2, and so on, but you can specify a more appropriate name for any worksheet.

Insert a new worksheet

To insert a new worksheet, do one of the following:

• To quickly insert a new worksheet at the end of an existing worksheet, click Insert Sheet at the bottom of the screen.

• To insert a new worksheet before an existing worksheet, select the sheet, on the Start tab, in the Cells group, click Insert, and then click Insert Sheet.

Tip You can also right-click the tab of an existing worksheet, and then click Insert. On the Standard tab, click Sheet, and then click OK.

Insert multiple worksheets at once

1, hold down SHIFT, and then select an existing sheet tab in the open workbook that is the same number as the worksheet you want to insert.

For example, if you want to add three new worksheets, select the sheet tabs for the three existing worksheets.

2, on the Start tab, in the Cells group, click Insert, and then click Insert Sheet.

Tip You can also right-click the selected sheet tab, and then click Insert. On the Standard tab, click Sheet, and then click OK.

Insert a new worksheet based on a custom template

1, you can create a worksheet template that you want to base your new worksheet on as needed.

How to create a worksheet template

(1) Select the worksheet that you want to use as a template.

(2) Click MicrosoftOffice button, and then click Save As.

(3) in the Save as type box, click Templates.

(4) In the Save in box, select the folder where you want to save the template.

• To create a default worksheet template, the default sheet template: The Sheet.xlt template that is created to change the default format for new worksheets. When you add a new worksheet to a workbook, Excel creates a blank worksheet with this template. , select the XLStart folder or the alternate startup folder (alternate startup folder: A folder outside of the XLStart folder that includes workbooks or other files that you want to open automatically when you start Excel, and a template that you can use when you create a new workbook.) )。

The XLStart folder is typically located at:


• To create a custom sheet template, select the Templates folder.

The Templates folder is typically located at:

In Microsoftwindowsxp: c:documentsandsettingsuser_nameapplicationdatamicrosofttemplates

In Microsoftwindowsvista: c:useruser_nameapplicationdatamicrosofttemplates

(5) In the File name box, type the name of the worksheet template.

• To create a template for the default sheet, type sheet.

• To create a custom sheet template, type the name of the file you want to use.

(6) Click "Save".

2. Right-click the sheet tab, and then click Insert.

3. Double-click the template for the type of worksheet you want.

Rename a worksheet

1, on the sheet tabs bar, right-click the sheet tab that you want to rename, and then click Rename.

2, select the current name, and then type the new name.

Tip When you print a worksheet, you can include the name of the worksheet.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.