Simple Excel utility for splitting columns and rows without changes in edited sheet.
Another unique utility allows "seamless" cutting sections. Something that Excel not offer.
Often becomes, that is necessary in already edited sheet insert into column (row) one or more new columns (rows). This utility is trying to convert the above functionality without noticeable changes in the modified worksheet.
- without installation
Run file Partitioning_columns_rows.xlsm and excel file, in which is necessary to split (insert) singel columns (rows).
In specific (active) sheet is necessary to define column (row), which will be split by marking the column (row) and pressing Ctrl+D.
After entering number of parts (the number of splits) and press Start button is a created copy of the sheet formed on the active sheet to the defined column (row) inserts the specified number of splits.
January 13, 2015
MS Office 2007 and above
Win XP / Vista / 7 / 8 / 10
Visual Basic for Applications (VBA)
excel utility, splitting rows and columns, inserting rows and columns
Overall rating: 97.6 %