How to Order Word Mail Merge Labels by Column
Question details
The user needs to change the mail merge sequence for labels so that the data fills vertically down columns rather than horizontally across rows.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Creating mail merge labels and attempting to adjust the print order to match specific physical label layouts or sorting requirements.
- Observed behavior
- By default, Word mail merge populates label templates left-to-right across each row before moving to the next row, ignoring requests for column-first filling.
Ensure you have saved a backup copy of your original mail merge document and that your data source (such as an Excel spreadsheet) is finalized before modifying the layout or sorting order.
Convert Label Merge to Directory Merge with Columns
Modifying the document layout to a Directory merge using newspaper-style columns allows the data to naturally flow vertically down the page.
Because the standard Mail Merge 'Labels' feature is built using Word tables, it strictly fills cells from left to right. By switching to a 'Directory' merge (which stacks records continuously) and applying page-level columns, you can force the text to flow downwards first.
Open your existing label mail merge document. Delete all label placeholders and "<<Next Record>>" rules except for the very top-left label entry.
Navigate to the 'Mailings' tab on the ribbon. Click 'Start Mail Merge' and select 'Directory' from the dropdown menu instead of 'Labels'.
Go to the 'Layout' (or 'Page Layout') tab, click 'Columns', and select 'More Columns'. Set the number of columns to match your label sheet, and adjust the spacing to perfectly align with the physical gaps between your labels.
Ensure your merge fields are correctly placed in the top-left section. Go back to 'Mailings', click 'Finish & Merge', and select 'Edit Individual Documents' to generate the new column-ordered labels.

Reorder the Excel Data Source Using a Macro
Sort your source data in Excel using a custom macro so that Word's default row-by-row filling perfectly mimics a column-first sequence on the final printed page.
Easily Create and Format Mail Merge Labels in WPS Office
WPS Writer provides robust Mail Merge features that are fully compatible with Microsoft Word documents, allowing you to easily manage directory merges, custom columns, and data sources to achieve column-first label printing.
- 1. Open Document in WPS Writer: Launch WPS Writer, open your label template, and navigate to the 'References' tab, then click 'Mailings'.
- 2. Set Up a Directory Merge: Click 'Start Mail Merge' on the ribbon and choose 'Directory'. Clear out all entries except the first one in the top-left corner.
- 3. Configure Page Columns: Switch to the 'Page Layout' tab, click 'Columns', and define the number of columns and spacing to match your physical label sheet grid.
- 4. Merge and Output: Insert your desired merge fields into the first block, then click 'Merge to New Document' to generate your labels sorted down the columns.

Frequently Asked Questions
Why does Word always fill mail merge labels across rows first?
Word's label feature is fundamentally built on standard document tables. Because mail merge populates table cells systematically from left-to-right, row-by-row, it cannot natively skip to the cell below it until the current row is completely filled.
Can I use the 'Next Record' rule to force column ordering in a table?
No, the 'Next Record' rule simply commands Word to pull the next row of data from your source file. If your template is structured horizontally as a table, it will still place that next record in the adjacent horizontal cell. Altering the page flow into columns via a Directory merge is required.
Will changing to a Directory merge mess up my label sizes?
It can if not configured carefully. When using a Directory merge with page columns, you must ensure that your column widths, margins, and the exact paragraph height within the single directory entry perfectly match the physical dimensions of your label stickers.




