answersLogoWhite

0


Best Answer

If your Excel workbook has several worksheets and you want to save them into separate Excel workbooks, try the following: Position your mouse on the worksheet tab (bottom left of the screen). Right mouse click on the worksheet tab and select "Move or copy" from the shortcut menu. This opens the Move or Copy dialog box. In the "To book:" field, choose "(new book)"

Click the check box for Create a copy if you want to keep the worksheet in the original workbook, or leave it unchecked if you want to move the worksheet from the original workbook. Click OK to finish the steps.

User Avatar

Wiki User

7y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Explode Excel worksheets into separate Excel workbooks?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What kind of documents does Excel Produce?

There are different names: Workbooks or Spreadsheets or Worksheets. Workbooks contain worksheets, and they can be called spreadsheets. They will have a .xls extension.


Excel provides the ability to create new worksheets and new what?

workbooks


What is Excel workbook collection of?

A workbook in Excel is a collection of worksheets, which may be what you mean. There is no particular name for a collection of workbooks. They are just workbooks or spreadsheet files.


Workbooks Worksheets Lists and Charts are four component of Excel?

Yes, all of those can be found in Excel.


What is the extension for excel 2007 worksheets?

Worksheets do not have extensions. They are contained in files known as workbooks. A 2007 workbook extension is .xlsx.


What is a collection of cells in an Excel worksheet called?

A workbook in Excel is a collection of worksheets, which may be what you mean. There is no particular name for a collection of workbooks. They are just workbooks or spreadsheet files.


How do you separate Excel Workbooks into new files?

Save as new file, delete all the worksheets you do not want to save in that file. Repeat the process until you have saved each worksheet to a new file.


What are some applications for excel workbook and worksheet in both the fields of accounting and for an nfl team?

What are some application for excel workbooks and worksheets in both the field of accounting and for an NFL team


What types of documents can be created in excel?

Either *docs or docx depending on which version (year) of office you use.


Which file name extention is used for Excel workbooks?

The standard extension for Excel workbooks is xls for versions up to 2003. Excel 2007 uses xlsx as its extension for workbooks.


Where are individual worksheets stored in Excel?

Worksheets are stored in a workbook in Excel.


How many workbooks are open on the taskbar when you first install Excel?

No workbooks are open when you first install excel. The first time you use excel, you will have one workbook open.