SharePoint Document Issues

How to Fix Missing Items or Columns in Microsoft Lists

John Wilson Oct 10, 2026 868 views

Question details

Users are unable to see certain items or columns in Microsoft Lists, typically occurring after modifying list views or applying new formatting.

How to Fix Missing Items or Columns in Microsoft Lists

Product: Microsoft Lists
Device & OS: not provided
Scenario: Viewing or modifying list configurations, formatting, and custom views in Microsoft Lists.
Observed behavior: Specific items or columns appear to disappear completely from the active list view, even though the underlying data has not been deleted.

Before you start

Before making changes, verify that you have sufficient permissions to edit views in the affected Microsoft List and confirm with your team that the missing columns were not intentionally deleted.

Solution 1Recommended

Edit the Current View to Restore Missing Columns

Modify the existing list view settings to ensure that the hidden columns are checked and set to be visible.

Often, changing a list layout or applying specific formatting accidentally unchecks columns in the view settings. Manually re-enabling them is the fastest way to resolve this.

Open the View Options

Navigate to your Microsoft List and click on the View options menu (usually showing your current view name) located in the top-right corner of the list header.

Edit Current View

Select 'Edit current view' from the dropdown menu. This will open the classic SharePoint view configuration page.

Select Missing Columns

Scroll through the list of available columns, check the boxes next to the missing columns you want to display, and click 'OK' at the top or bottom of the page to save your changes.

Edit the Current View to Restore Missing Columns

Data Intact: Your data is never lost when a column is hidden; checking the box simply restores its visibility in the front-end layout.

Solution 2

Create a New List View

Switching to an alternative view or creating a fresh one can bypass hidden formatting glitches that may be hiding your data.

Free Microsoft Office alternative

Manage Your Data Easily with WPS Office

If you frequently struggle with missing columns or complex view settings in Microsoft Lists, exporting your data to a spreadsheet is a great workaround. WPS Office is a free, lightweight alternative to Microsoft Office that offers seamless compatibility, a familiar interface, and straightforward data management.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your computer.
2. Export List Data: In Microsoft Lists, select 'Export' and choose 'Export to Excel' or 'Export to CSV' to secure your data.
3. Analyze Data Seamlessly: Open the exported file in WPS Spreadsheet to view, manage, and analyze all your columns without view-related glitches.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsLightweight application that runs smoothly on any deviceFamiliar user interface requiring zero learning curveFree built-in PDF tools and extensive document templates

microsoft office alternative - wps office

Frequently Asked Questions

Why do items disappear when I apply grouping or filtering in Microsoft Lists?

Applying strict filters or grouping rules can inadvertently hide items that do not meet the exact criteria. Check your view settings by clicking the filter icon and clear any active filters to see if the missing items reappear.

Can custom formatting scripts hide columns in Microsoft Lists?

Yes, while conditional formatting usually changes colors or styles, advanced JSON formatting applied to a view or column can sometimes hide specific elements. Reviewing or disabling custom formatting via the 'Format current view' option can help restore visibility.

How do I know if my Microsoft List data was deleted instead of just hidden?

You can check the SharePoint Recycle Bin associated with the site. Navigate to Site contents > Recycle bin. If the items are not there, they have likely not been deleted and are just hidden by your current list view configurations.

Document & File Issues