Split Sheet By Group

The Split Sheet By Group command used to take the current sheet and separate it into multiple sheets based on the values in a specified group column.

For example, if the Invoice sheet in the sample data is split by Salesperson, a new sheet is created for each Salesperson. You can also split on multiple keys such that you would have sheets for Salesperson1/Customerno1, Salesperson1/Customerno2, etc. You can split a sheet into as many as 254 separate sheets.

Example

  • Open Easy-XL's Sample Workbook
  • Select the Invoices Sheet
  • Select Split Sheet By Group from the Easy-XL Menu
  • In the Split Sheet By Group dialog box, select Quarter in the Group section.
  • Click Finished.