How to Import Worksheets Into a Workbook

Save

Microsoft Excel is a spreadsheet program that allows users to complete complicated calculations, organize data and create graphs and spreadsheets. You can save data in a workbook, which is made of worksheets. Depending on the project, it is sometimes necessary to have several worksheets in one workbook. If you need to import a new worksheet into a workbook, you can use Excel's "Move or copy" utility to complete the process.

  • Launch Microsoft Excel. Click the "Microsoft Office" button, then select "Open" from the drop-down list. Navigate to the workbook into which you wish to import the worksheet then double-click it to open it. Click the "Microsoft Office" button again, then navigate to the workbook that contains the worksheet you want to import into the other workbook and double-click it to open it.

  • Click anywhere on the workbook that contains the worksheet you wish to import to select it. Right-click on the worksheet tab name at the bottom of the worksheet. For example, click on "Reports" if that is the name of the worksheet you want to import. Select "Move or Copy" from the pop-up list. The Move or Copy dialog box will open.

  • Click the workbook to which you want to send the worksheet in the "To Book" list. Click the name of the worksheet in the destination workbook that you want your worksheet to appear before in the "Before sheet" list. Click "Move to end" from the "Before sheet" list if you want your worksheet to appear at the end of the destination workbook.

  • Click the check box next to "Create a copy" if you want to leave a copy of your worksheet in the current workbook. Click the "OK" button to import the sheet into the destination workbook.

References

Promoted By Zergnet

Comments

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!