How to Indent Multiple Lists in WPS Office Writer Using Styles or VBA
Question details
The user needs a reliable way to indent multiple lists in a Word-compatible document, especially after exporting from Adobe, because a VBA command targeting ActiveDocument.Lists(1) only changes the first list.
- Product
- WPS Office Writer
- Device & OS
- not provided
- Scenario
- A user is formatting a document originally created in Adobe and exported to a Word-compatible file, where multiple lists need consistent indentation.
- Observed behavior
- A VBA macro that references ActiveDocument.Lists(1) indents only the first list, and the exported document may contain inconsistent list formatting.
Open the affected document in WPS Office Writer, display paragraph marks from the Home tab, and click inside one list item to see which style is currently applied.
Apply Built-in List Number Styles to Indent Multiple Lists in WPS Writer
Use this when lists have inconsistent indentation after Adobe export and you want a stable, low-maintenance formatting fix without editing macros.
Built-in list styles such as List Number, List Number 2, and List Paragraph apply consistent indentation to list paragraphs in one pass. This is safer than a macro because it does not depend on VBA list indexing.
In WPS Office Writer, go to the Home tab and click the Styles dialog box launcher to open the Styles panel.
Select the list items you need to indent, including items from the Adobe-exported document, by dragging across the text or holding Ctrl while selecting separate ranges.
In the Styles panel, click List Number, List Number 2, or List Paragraph. Use List Number for the main numbered list and List Number 2 for second-level items.
Click anywhere in the list and check the ruler or indentation markers to confirm each list level now uses the same indent.
Use VBA to Target Each List Separately in WPS Writer
Use this only if you must automate indentation and want to avoid ActiveDocument.Lists(1) affecting only the first list.
Indent Multiple Lists in WPS Office Writer with Built-in Styles or Safe VBA
WPS Office Writer lets you apply built-in List Number and List Paragraph styles to multiple lists at once, and if you need automation, you can loop through each list in the VBA editor instead of only ActiveDocument.Lists(1).
- 1. Open your document in WPS Office Writer: Launch WPS Office and open the Adobe-exported or Word-compatible document that contains multiple lists.
- 2. Select the lists and open Styles: Select all affected lists on the page, then click the Home tab and open the Styles panel.
- 3. Apply the appropriate list style: Click List Number, List Number 2, or List Paragraph to indent the selected lists consistently.
- 4. Optional: run a VBA loop: If you still need macro automation, press Alt+F11, loop through ActiveDocument.Lists, and format each list range separately.
- 5. Save as a Word-compatible file: Save the document in .docx format to preserve the list styles and indentation.
Frequently Asked Questions
Why does ActiveDocument.Lists(1) indent only one list?
The Lists(1) index points only to the first list object in the document. To affect all lists, use the built-in styles or loop through every list in the VBA Lists collection.
Which built-in style should I use for a second-level list?
Use List Number 2 for a second-level numbered list. For general indentation without numbering, apply List Paragraph, then set the indent level from the Home tab.
How do I fix list indentation after exporting a PDF from Adobe to Word?
Open the exported document in WPS Office Writer, select all affected list paragraphs, and reapply List Number or List Paragraph from the Styles panel. If the list structure is broken, clear direct formatting with Ctrl+Q first.
Can I use VBA macros in WPS Office Writer?
Yes, WPS Office Writer supports VBA macros. Open the editor from Tools > Macro > VBA Editor, but test any macro on a copy because Adobe-exported documents may have irregular list structures.
Will these list styles remain when I open the file in Microsoft Word?
Yes, if you save in .docx format, List Number, List Number 2, and List Paragraph styles are preserved when the document is opened in Microsoft Word.
