How to Create Spreadsheets in Excel 2007

Save

Excel 2007 is a spreadsheet program that is part of the Microsoft Office suite. If you are new at using Excel and want to create a spreadsheet, it takes only a few clicks of the mouse to do so. When you open a new Excel workbook, three spreadsheets are included automatically. If a project you are working on requires more than three sheets, you can quickly create new spreadsheets to add to the workbook.

  • Open Excel 2007. The three spreadsheets that are created by default are labeled "Sheet 1," "Sheet 2" and "Sheet 3."

  • Click the "Insert Worksheet" button. The button is located to the right of the "Sheet 3" tab. A new spreadsheet will open that is labeled "Sheet 4." Repeat this to insert additional sheets.

  • Right-click over a spreadsheet tab and click "Insert" from the menu that pops up to create a spreadsheet using a different method. Select "New Worksheet" when the "Insert" dialog box opens. A new spreadsheet will be created.

  • Create multiple spreadsheets at once by holding down the "Shift" key and highlighting the existing spreadsheet tabs in your workbook. Highlight the number of spreadsheets you want to create. For example, if you want to create two additional spreadsheets, highlight two spreadsheet tabs. Click the "Home" tab from the Excel ribbon at the top of the page and look to the "Cells" section. Click the "Insert" button and select "Insert Sheet" from the drop-down menu. The spreadsheets will be added to your workbook.

Tips & Warnings

  • You can change the order of the spreadsheets in a workbook by clicking one of the spreadsheet tabs and dragging it to a new position in the workbook.
  • If you want to change the name of a spreadsheet tab, right-click over the tab and select "Rename" from the menu that pops up and enter the name you want to use in the tab.

References

Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Make a Spreadsheet in Office

    Spreadsheets, whether created on paper or using a computer application, make data (such as numbers) easy to read. A spreadsheet's gridlines lay...

  • How to Do Excel Budget Spreadsheet Samples

    Excel Budget Spreadsheet samples can provide you a template to chart out your monthly budget. This excel sample can be a versatile...

  • How to Create Excel Worksheets

    If you’re new to Excel, you’ll find it easy to learn and work with. You can complete most of the tasks by...

  • How to Delete a Worksheet in 2007 Excel

    Excel is a Microsoft spreadsheet program that allows users to complete a myriad of complicated mathematics quickly and easily with computer-coded commands....

  • How to Make Tables in Excel 2007

    Excel 2007 allows you to create, edit, and view spreadsheets from your Windows-based computer. Using Excel 2007, you can make tables to...

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!