The ASAP Utilities menu in Excel (English)
Split the selected range into multiple worksheets...
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Sheets › 9. Split the selected range into multiple worksheets...
With this tool you can quickly split your selected data into multiple sheets.You can do this either by value/group in a column or you can specify the number of rows to create per sheet.
Examples:
Create a new sheet for each company in your table.
Note:
Your initial data remains unaltered.
If you want to save the new created worksheets as separate files, then you can do this with the utility "Export » Export worksheets as separate files...".
We have also received the request for this tool from people that used workbooks with over 500 000 rows (Excel 2007+) and then needed to create a file that could be opened in Excel 2003. In order to do that they had to split the information into pieces of a max of 65536 rows per worksheet because that is the maximum amount of rows that a sheet in Excel 2003 can contain. With this tool you can quickly have ASAP Utilities do that for you.
Screenshots
Starting this tool
- Click ASAP Utilities › Sheets › 9. Split the selected range into multiple worksheets...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Additional keywords for this tool:
split each group into a separate worksheet tab, Split Every N Rows From Worksheet Into New Worksheets, split up, split cells to different worksheets, copy and paste on different sheets, automatically generate new sheets, columns
split each group into a separate worksheet tab, Split Every N Rows From Worksheet Into New Worksheets, split up, split cells to different worksheets, copy and paste on different sheets, automatically generate new sheets, columns