How to Insert a Worksheet in Microsoft Excel

Save

In Microsoft Excel, worksheets can be inserted in any new spreadsheet document as well as moved and copied among documents. The processes, while quick and simple, vary slightly by the type of insertion desired, and there are multiple methods for certain types of insertions. These instructions are applicable to Microsoft Excel 2007.

Things You'll Need

  • Computer with Microsoft Excel 2007 installed

Insert Blank Worksheet Before or After Existing Worksheets

  • Locate the row of tabs identifying your worksheets at the bottom of the Excel window. By default, Excel titles worksheets Sheet1, Sheet2, Sheet3 and so on.

  • At the end of the tabs of worksheets, there is an icon of folder tabs with an asterisk. Click to insert a new worksheet after the existing worksheets. Hold down the "Shift" key, press "F11" and release both keys to insert a new worksheet before existing worksheets.

  • To move the inserted worksheet to another position, click on the worksheet title, but do not release the mouse button; instead, drag the mouse pointer until it is at the location where you want to place the worksheet and then release the button.

Insert Blank Worksheet Before Selected Worksheet -- Method 1

  • Click on a worksheet tab title in the tabs bar at the bottom of the Excel window.

  • Press the "Shift" key, but do not release it.

  • Press "F11" and release both keys. A new worksheet appears; it is titled numerically based on the number of worksheets already in the workbook.

Insert Blank Worksheet Before Selected Worksheet -- Method 2

Insert a Worksheet Based on a Template

  • Right-click on the tab to the left of which you want to insert your new worksheet. Click "Insert..." from the menu.

  • Select a template from the general or spreadsheet solutions tabs. You can also click the "Templates on Office Online" button to download templates shared by users on Microsoft's website.

  • Click "OK."

Insert a Worksheet from Another Workbook

  • Open both the workbook containing the worksheet you would like to insert (the source) and the workbook to which you would like to copy the worksheet (the destination).

  • In the source workbook, right-click the desired worksheet tab and select "Move or Copy..." from the menu that appears.

  • In the "Move or Copy" dialog box select the destination workbook title from the "To book:" drop-down menu and select the worksheet before which you want to insert your copied worksheet.

  • Click the box next to "Create a copy" to copy the worksheet into the destination workbook; leave the box unchecked to move the worksheet and delete it from the source workbook.

  • Click "OK."

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!