Discover new tools to get things done.
This tool helps you reshape a long, narrow dataset into a more compact layout for printing.
It splits your selected data into multiple vertical sections (like snaking columns, as seen in newsletters), side by side on a new worksheet. This allows more data to fit on a single printed page, saving paper and improving readability.
The original data remains untouched. The reorganized layout is created in a new worksheet.
You can choose:
This is useful when:
Example:
Original data in one column:
A001
A002
A003
A004
A005
A006
After splitting into three columns of two rows each:
A001 A003 A005
A002 A004 A006
Note:
The data is split top-to-bottom, then left-to-right across columns, similar to how a multi-column newsletter or directory prints.
Your last used settings are automatically remembered.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Tip:Alt+P for the previous tool.