Others

How to Display More Than Five Lines in Microsoft Lists

Olivia MillerOlivia Miller Oct 23, 2026 871 views

Question details

The user wants to view more than five lines of text in a multiple-lines-of-text column within the modern Microsoft Lists interface.

How to Display More Than Five Lines of Text in Microsoft Lists
Product
Microsoft Lists
Device & OS
not provided
Scenario
Viewing long text entries in multiple-lines-of-text columns without the content being cut off automatically.
Observed behavior
Microsoft Lists limits the visible height of text columns by default in the modern interface, truncating content after a few lines.
Before you start

Ensure you have the necessary edit permissions for the Microsoft List to modify column settings and apply custom JSON formatting.

Solution 1Recommended

Apply JSON Formatting to Create a Scrollable Area

Use custom JSON code in the column settings to adjust the maximum height and add a vertical scrollbar for longer text entries.

By default, the modern interface of Microsoft Lists restricts the display height for multiple-lines-of-text columns. Although there is no built-in toggle to display all lines automatically, you can override this limitation by using JSON column formatting to enable an auto-scrolling text box.

1
Access Column Settings

Click on the column header of your multiple-lines-of-text column, select 'Column settings' from the dropdown, and then choose 'Format this column'.

2
Enter Advanced Mode

At the bottom of the formatting pane on the right side of the screen, click on the 'Advanced mode' link.

3
Apply JSON Code

Enter JSON code that sets a specific 'max-height' (for example, '150px') and sets the 'overflow-y' property to 'auto'.

4
Preview and Save

Click 'Preview' to verify that the text area now displays more lines and becomes scrollable. Once confirmed, click 'Save' to apply the formatting to the list.

Apply JSON Formatting to Create a Scrollable Area
JSON Formatting Error: If you receive a column-formatting error upon saving, ensure your JSON syntax is correct. Sometimes, regional language settings can affect the error messages displayed, but standard JSON formatting applies universally.
Free Microsoft Office alternative

Manage Your Data Effortlessly with WPS Spreadsheet

While Microsoft Lists requires complex JSON formatting to display long text, managing lists and textual data in spreadsheets can be much simpler. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for all your document and spreadsheet needs.

  1. 1. Download and Install: Go to the official WPS website and click 'Download WPS Office Free' to install the suite on your device.
  2. 2. Open WPS Spreadsheet: Launch WPS Office and open WPS Spreadsheet to start managing your list data.
  3. 3. Format Text Easily: Use the 'Wrap Text' and 'AutoFit Row Height' features on the ribbon to display long text fields automatically.
Easily adjust row heights and use 'Wrap Text' to view long entries without any coding.Fully compatible with Microsoft Excel (.xlsx) formats.Lightweight installation and incredibly fast loading speeds.Free to use with an intuitive, familiar user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Can I display all lines automatically without a scrollbar in Microsoft Lists?

Currently, the modern Microsoft Lists interface does not provide a built-in option to automatically expand the row height to fit all lines. JSON formatting is required to create a scrollable view.

Why am I getting an error when saving my JSON code in Lists?

Errors usually stem from incorrect JSON syntax, such as missing quotes, brackets, or commas. Ensure you are copying the exact JSON format required by SharePoint and Microsoft Lists.

Does JSON formatting alter or delete the data in my column?

No, column formatting only alters how the data is visually presented in the list view. It does not modify, truncate, or delete the underlying text data.

Can I apply this JSON scrolling format to other column types?

While JSON formatting can be applied to most columns in Microsoft Lists to change their appearance, configuring max-height and overflow-y properties is specifically useful for multiple-lines-of-text columns.