Microsoft Excel 2007 tutorial: insert worksheet


Insert worksheet

V. Insert worksheet

By default, when you open Microsoft Office Excel 2007, you will see three sheets (worksheets) in the Excel window. You might think that these three sheets maybe not enough for your work when your work is large. So, you actually need more sheets. You can insert a sheet or more sheets at once.

V.1. Insert a sheet

When your work needs one more sheet, you insert only a sheet. To insert a worksheet, do the following:

- Right-click any sheet you want.

- Click Insert

Excel 2007 insert sheet

Excel 2007 displays Insert dialog box as the figure:

Excel 2007 Insert dialog box

- Click Ok if the Worksheet icon is selected; if not you need to select it first.

Or

- Click Insert Worksheet tab (Shift+F11).

Excel 2007 Insert Worksheet tab

Or

- In the Home tab, in the Cells group, click drop-down arrow in front of Insert, and then click Inert Sheet.

Excel 2007 Insert tool

V.2. Insert more sheets

If your work need two, three or more sheets, you can insert those additional sheets at once. You can insert those sheets one by one, but it is waste the time. So, a good option is to insert the needed worksheets at once. To insert more sheets at once, do the following:

- Select a number of worksheets you want to insert.

- Right-click any selected sheet.

- Click Insert

Excel 2007 displays Insert dialog box.

- Click Ok if the Worksheet icon is selected; if not you need to select it first.

or

- Select a number of worksheets you want to insert.

- In the Home tab, in the Cells group, click drop-down arrow in front of Insert, and then click Inert Sheet.

For example, you want to insert more two sheets while you have three sheets in Excel window already ( Sheet1, Sheet2, Sheet3). To do so, follow the steps below:

- Select two sheets (e.g. Sheet1 and Sheet2) by clicking Sheet1, then holding down Shift key or Ctrl key and then clicking Sheet2.

- Right-click Sheet1 or Sheet2.

- Click Insert

- Click Ok if the Worksheet icon is selected; if not you need to select it first.

or

- Select Sheet2 and Sheet3.

-  In the Home tab, in the Cells group, click drop-down arrow in front of Insert, and then click Inert Sheet.

See the figure before insert sheets and after added sheets is shown below:

Excel 2007 before and after insert sheets

Note: In case, you select up to two sheets, all tools in the Data tab and some tools in other tab are disabled except Acrobat tab. So, to know that you can select more than one sheet or not, please check the Data tab.

 


Comments

Michael Leng comment

 Michael Leng

I like this share. Especially, Shift + F11 insert worksheet.


2013-08-18




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.