Show or hide columns in a list or library

Show or hide columns in a list or library

You can show or hide columns in a list or library as an alternative to deleting them. When you hide a column, it doesn't affect the column or the data in the column, as it would if you deleted it. To re-use the column, you can just show it again.

You can create lists in Microsoft SharePoint, the Lists app in Microsoft 365, or Teams. Learn to get started with Lists in Microsoft Teams.

Note: To show or hide a column in a list or library, you must at least be a member of the default designer group.

You can also add, change, or delete columns in a list or library, as well as create or delete a list from a page or site. For more information about managing lists or libraries with many items, see Manage large lists and libraries.

Show or hide a column in a list or library

  1. Go to the list or library that want to show or hide columns.

  2. At the top of any column, select the down arrow Chevron icon to expand details. , then select Column Settings > Show/hide columns.

    The Column settings > Show/hide columns option when a column heading is selected in a modern SharePoint list or library
  3. In the Edit view columns pane, check (to show) or uncheck (to hide) the box for the column or columns as needed.

    Note: If you want to rearrange the order of the columns, either drag and drop the column name, or select the up or down arrow next to the column name as preferred.

    The Edit view columns pane in modern SharePoint Online
  4. When you're finished, select Apply.

  1. If the list or library is not already open, select its name on the page or in the Quick Launch.

  2. In the ribbon, select the List or Library tab.

    The library and browse tab on the ribbon
  3. In the Manage Views group, select Modify View.

    SharePoint Online Ribbon Library tab modify view option
  4. In the Columns section, check or clear the box under the Display heading next to the column you want to show or hide.

    Column chooser dialog box
  5. Select OK to save.

Learn more

Create a column in a list or library

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×