Permission & Access Issues

How to Restrict Access to the All Items View in Microsoft Lists

Phi Hung Vo Oct 19, 2026 869 views

Question details

The user wants to restrict selected users from accessing the 'All Items' view in Microsoft Lists to prevent them from seeing sensitive data hidden in specific views.

How to Restrict Access to the All Items View in Microsoft Lists

Product: Microsoft Lists
Device & OS: not provided
Scenario: Attempting to secure sensitive list data by hiding columns in a specific view and preventing users from switching back to the default All Items view.
Observed behavior: Microsoft Lists does not provide a built-in feature to lock or restrict the All Items view; users can bypass hidden columns by switching views or creating new ones.

Before you start

Understand that list views in Microsoft Lists are designed for organizing data, not for security. Hiding a column in a view will not prevent users who have access to the list from viewing the underlying sensitive data.

Solution 1Recommended

Create Separate Lists with Unique Permissions

The most secure and recommended way to restrict access to sensitive data is to split the data into different lists and assign unique permissions to each.

Because Microsoft Lists does not support view-level or column-level security, any user with read access to the list can potentially access the All Items view or create a new view to reveal hidden columns. By using separate lists, you enforce strict permission boundaries.

Identify Sensitive Data

Review your list and separate the columns into public data (accessible to everyone) and sensitive data (accessible only to specific users).

Create a New Restricted List

Create a new Microsoft List specifically for the sensitive data. You can do this from the Microsoft Lists app or SharePoint site.

Modify List Permissions

Click the gear icon (Settings) in the top right corner, select 'List settings', and then click on 'Permissions for this list'.

Stop Inheriting Permissions

Click 'Stop Inheriting Permissions' in the ribbon. Select the user groups you want to remove, click 'Remove User Permissions', and only grant access to authorized individuals.

Create Separate Lists with Unique Permissions

Best Practice: Always test your new list permissions with a standard user account to verify that unauthorized groups cannot access the sensitive data.

Solution 2

Synchronize Non-Sensitive Data Using Power Automate

If you need a master list for managers and a restricted list for general users, use Power Automate to copy items automatically.

Free Microsoft Office alternative

Manage Data Securely with WPS Spreadsheet

While Microsoft Lists requires complex workarounds to secure specific data columns, managing your structured data in WPS Spreadsheet allows you to easily protect specific sheets, hide formulas, and lock cells. It serves as a highly compatible, free, and lightweight alternative to Microsoft Office.

1. Download and Install: Download WPS Office for free and install it on your device.
2. Open Your Data File: Launch WPS Spreadsheet and open or import your structured data.
3. Apply Protection: Navigate to the Review tab and click 'Protect Sheet' to set a password and restrict users from viewing or modifying specific cells.

Free and lightweight office suiteFully compatible with Microsoft Excel formats (.xlsx, .csv)Easy-to-use worksheet and cell-level protectionFamiliar user interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide a specific column from certain users in Microsoft Lists?

No, Microsoft Lists does not support column-level security. Hiding a column in a list view only removes it from the display. Users can still access the data by modifying the view, switching to the All Items view, or exporting the list.

Does restricting edit access prevent users from seeing the All Items view?

No. Changing a user's permission level to 'Read' only prevents them from modifying or deleting data. They can still view all list items and switch to any public views, including the default All Items view.

How can I share only specific list items with an external user?

Instead of sharing the entire list, you can select specific list items, click the 'Share' icon, and grant access exclusively to those items. However, if you need to manage multiple items this way, it is far more efficient to create a separate list.

Document & File Issues