Applies ToSharePoint Server Subscription Edition SharePoint Server 2019 SharePoint in Microsoft 365 Microsoft Lists

You can change list column settings, such as the column's name and type. Depending on the type of column, you can also make changes such as how much text a user can enter, or which columns to show or hide. You can also change the order in which columns appear in a list. For example, in a product list, you can change the item number or price's position in the list.

Notes: 

Change how the columns are displayed

  1. Open the list that you want to update. 

  2. Select View options.Screenshot showing the All Documents view drop down list used to change a list view. Choose a view. By default, it's All Documents.

  3. Hover and select the down arrow on any of the list headings, and then select Column settings Show/hide columns.Screenshot showing the Show/hide columns command in a list.

  4. Drag and drop columns up or down to put them in a new order. You can also use the Up or Down arrows that appear when you hover over a column name.

    Use up or down arrows, or drag and drop column position

  5. Repeat step 4 to change the order of all columns you want, and then select Apply to save.

  6. To save the view, select View options and then select Save view as. Update the name and select Save.Screenshot showing the Save view as command you can use to name your view.

Show or hide columns

  1. Open the list you want to update. 

  2. Select View options. The name displayed in View options is the name of your current view. By default, it's All Documents.Screenshot showing the All Documents view drop down list used to change a list view.

  3. Hover and select the down arrow on any of the list headings, and then select Column settings Show/hide columns.

  4. In Edit view columns, select or clear the columns you want to show or hide.

    check or uncheck columns to show or hide

  5. Select Apply to save.

  6. To save the view, select View options > Save view as. Update the name and select Save.

Change other column settings for a list

You can also change other settings for columns directly from the Column settings dropdown menu.

  1. Open the list you want to update. 

  2. If you want to change columns in a view, select View options, and choose a view. The name displayed in View options is the name of your current view. By default, it's All Documents.

  3. Select the arrow next to the column you want to change, and then select Column settings.Screenshot showing the column settings in a list you can use to modify your list.

  4. In the menu, select the change you want to make, such as formatting the column, moving it left or right, hiding it, or adding a new column. The settings vary depending on the type of column you're editing.

    For more information, see List and library column types and options and Edit a rich text list column.

Leave us a comment

Was this article helpful? If so, please let us know at the bottom of this page. If it wasn't helpful, let us know what was confusing or missing. We'll use your feedback to double-check the facts, add info, and update this article.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.