![]() ![]() | ||
ASAP Utilities, description of our Excel tools![]() Sheets » 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. Starting this utilityIn the Excel menu choose: ASAP Utilities » Sheets » Split the selected range into multiple worksheets...« Return to the list of “Sheets” tools.
You can do this too![]() Download "The one essential add-in for all Excel users." Download 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 | ||
Home
Privacy Policy
Cookie Policy
EULA
Sitemap
Search
List of all utilities
Printer friendly page
Contact Us
^ Back to Top
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
![]() ![]() |