How to Keep an Unhidden Column in Its Original Position in Microsoft Lists
Question details
The user wants to know how to unhide a column in Microsoft Lists and have it return exactly to its original position instead of appearing at the far left or right of the view.

- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Unhiding a previously hidden column in a Microsoft Lists view and attempting to restore its original display order.
- Observed behavior
- When the column is unhidden, it automatically appears at the far end of the view. There is no automatic button to restore its former position.
Ensure you have the necessary edit permissions for the Microsoft List, as changing column visibility and positioning requires modifying the list's view settings.
Manually Set Column Position via View Settings
Because Microsoft Lists defaults to placing unhidden columns at the end of the view, you must use the 'Edit current view' menu to manually assign its original position number.
Microsoft Lists does not store the 'previous' position of a hidden column in a way that automatically restores it upon unhiding. To fix this, you have to access the backend view settings to explicitly define the display order.
Navigate to your Microsoft List. In the top right corner of the list area, click on your current view name (often labeled 'All Items').
From the dropdown menu that appears, click on 'Edit current view' to open the classic view configuration page.
Scroll down to the 'Columns' section. Find the specific column you want to unhide and check the box in the 'Display' column.
Next to your column's name, look at the dropdown menu under 'Position from Left'. Change this number to place the column in your preferred original order.
Scroll to the very top or bottom of the settings page and click the 'OK' button to save your view. Your column will now be unhidden and in the correct spot.

Manage Data and Spreadsheets Easily with WPS Office
While Microsoft Lists handles specific list views, WPS Spreadsheet offers a robust, easy-to-use environment for managing data, tables, and columns. If you are looking for a highly compatible and free alternative to Microsoft Office for your daily data tasks, WPS Office is the perfect choice.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open Your Data: Launch WPS Spreadsheet and open your existing .xlsx or .csv data files directly.
- 3. Manage Columns: Right-click any column letter at the top to easily hide or unhide columns, or drag the headers to instantly change their position.

Frequently Asked Questions
Why does my column disappear immediately after I click Apply to unhide it?
This can happen due to a glitch in the modern list quick-edit pane or browser cache issues. To bypass this, click 'Edit current view' from the view dropdown and unhide the column from the classic settings page instead.
Can I save a specific column layout for other users to see?
Yes. When you modify the column layout using 'Edit current view', the changes are saved to that specific view. As long as it is a public view, anyone with access to the list will see the columns in the order you set.
Is it possible to reset my Microsoft List view to its original default state?
Microsoft Lists does not have a single 'Reset View' button. If your view gets too disorganized, your best option is to either manually rearrange the columns or create a brand new view based on the default list layout.




