Tip of the Day | Thursday February 2nd, 2023Discover new tools to get things done.![]() 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
![]() Choose your language preference belowEnglish (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語 | ||
Home
Privacy Policy
Cookie Policy
EULA
Download
All added Excel tools
Sitemap
Contact Us
|