How do I separate Data in Excel to different sheets?

You can separate data in Excel to different sheets by moving or copying existing sheets into new workbooks. Here's how you do it:

Steps to Move or Copy a Sheet to a New Workbook

1. Select the Sheet: In your original Excel workbook, right-click on the sheet tab that you want to separate.
2. Open Move or Copy Dialog: From the context menu that appears, select the "Move or Copy" option.
3. Choose Destination: In the "Move or Copy" dialog box:
   • From the "To book" dropdown menu, select "(new book)". This indicates you want to create a new Excel file for the selected sheet.
4. Decide to Move or Copy:
   • Move: If you want to move the sheet (remove it from the original workbook), leave the "Create a copy" checkbox unchecked.
   • Copy: If you want to copy the sheet (keep a version in the original workbook), check the "Create a copy" checkbox.
5. Confirm: Click "OK". A new Excel workbook will be created containing the sheet you either moved or copied.
6. Repeat: Repeat these steps for each sheet you want to separate into its own workbook.

Example

Let's say you have an Excel file named "MasterData.xlsx" with three sheets: "Sheet1", "Sheet2", and "Sheet3". You want each sheet to be in its own separate Excel file.

1. Right-click on the "Sheet1" tab.
2. Select "Move or Copy".
3. In the "Move or Copy" dialog, choose "(new book)" from the "To book" dropdown.
4. Check the "Create a copy" box if you want to keep a copy of Sheet1 in the original "MasterData.xlsx" file. Otherwise, leave it unchecked to move the sheet.
5. Click "OK". A new Excel file, let's say "Book1.xlsx", is created containing "Sheet1".
6. Repeat the process for "Sheet2" and "Sheet3", each time creating a new book (e.g., "Book2.xlsx" and "Book3.xlsx").