How to delete an excel file

Rename a worksheet

Double-click the sheet name on the Sheet tab to easily rename it.

You watching: How to delete an excel file

Or, right-click the Sheet tab, click Rename, and form a new name.

Delete a worksheet

Right-click the Sheet tab and choose

*
Delete.

Or, choose the sheet, and then select Home > Delete > Delete Sheet.

*


Note: Sheet tabs are presented by default. If you do not check out them, click Options > Advanced > Display choices for this workbook > Sjust how Sheet tabs.


To insert a new worksheet, carry out one of the following:

To conveniently insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the display.

*

To insert a brand-new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and also then click Insert Sheet.


Tip: You have the right to likewise right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and also then click OK.


Note: To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and also then drag it to the area that you want.


What do you want to do?

Insert multiple worksheets at the same time

Hold dvery own SHIFT, and then select the very same number of existing sheet tabs of the worksheets that you want to insert in the open workbook.

For instance, if you want to add three brand-new worksheets, pick 3 sheet tabs of existing worksheets.

On the Home tab, in the Cells team, click Insert, and also then click Insert Sheet.


Tip: You can additionally right-click the schosen sheet tabs, and also then click Insert. On the General tab, click Worksheet, and then click OK.


To readjust the order of the worksheets in a workbook, click the tab of the worksheet that you desire to move, and also then drag it to the area that you want.

Change the default variety of worksheets in a brand-new workbook

Under Excel, click Options.

In the General category, under When producing new workbooks, in the Include this many kind of sheets box, enter the number of sheets that you desire to incorporate by default as soon as you develop a brand-new workbook.

Click any kind of various other tab to return to your file.

Insert a new sheet that is based upon a practice template

If essential, develop the worksheet theme that you desire to base a brand-new worksheet on.

How to develop a worksheet template

Select the worksheet that you desire to usage as a design template.

Click the File tab.

Under Info, click Save As.

In the File name box, type the name of the worksheet template.

See more: Microsoft: Upgrade Microsoft Office 2003, But Not To Office 2013

To create a tradition worksheet layout, kind the file name that you want to use.

To develop the default worksheet design template, form sheet.


Note: Custom templates are instantly saved in the Templates folder. The default worksheet layout, sheet.xltx or sheet.xltm, must be saved in the XLStart folder, which is commonly C:Program Filesjiyuushikan.org OfficeOffice14XLStart.


Do one of the following:

On a computer that is running Windows Vista, in the list, click Excel Template or Excel Macro-Enabled Template.

On a computer system that is running jiyuushikan.org Windows XP, in the Save as type box, click Excel Template or Excel Macro-Enabled Template.

Click Save.

Right-click the sheet tab of a worksheet, and also then click Insert.

Double-click the template for the type of sheet that you desire.

Rename a worksheet

On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename Sheet.

*

Select the current name, and also then kind the new name.


Tip: You deserve to include the name of the sheet as soon as you print the worksheet.


How to print sheet names

On the Insert tab, in the Text group, click Header & Footer.

In the Page Layout View, click the location wbelow you desire the sheet name to show up.

In the Header & Footer elements team, click Sheet Name

*
.

Delete one or more worksheets

Select the worksheet or worksheets that you desire to delete.


Tip: When multiple worksheets are selected, shows up in the title bar at the height of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any kind of unschosen worksheet. If no unschosen sheet is visible, right-click the tab of a schosen sheet, and then click Unteam Sheets on the shortreduced food selection.


On the Home tab, in the Cells group, click the arrowhead alongside Delete, and then click Delete Sheet.


Tip: You can likewise right-click the sheet tab of a worksheet or a sheet tab of any selected worksheets that you want to delete, and also then click Delete Sheet.


Need more help?

You can constantly ask an skilled in the Excel Tech Community, obtain assistance in the Answers area, or imply a brand-new attribute or innovation on Excel User Voice.


*

A subscription to make the the majority of of your time
Try one month free
*
*
*

Need more help?


Expand also your Office skills
Explore training
*

Get instant Excel help
Connect to an professional now
Subject to Got It terms and conditions

Was this information helpful?


YesNo
Great! Any various other feedback? The more you tell us, the even more we deserve to help.How deserve to we improve? The even more you tell us, the more we have the right to help.

See more: What Is Gom Player Virus - Gom Player Download For Windows & Mac


SendNo thanks

Thank you for your feedback!


Thank you for your feedback! It sounds choose it might be useful to connect you to among our Office assistance agents.


Contact jiyuushikan.org
×
What's new
jiyuushikan.org Store
Education
Enterprise
Developer
Company
English (United States) © jiyuushikan.org 2021