Others

How to Keep an Unhidden Column in Its Original Position in Microsoft Lists

Huma Ashraf ChHuma Ashraf Ch Oct 23, 2026 870 views

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.

How to Keep an Unhidden Column in Its Original Position in Microsoft Lists
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.
Before you start

Ensure you have the necessary edit permissions for the Microsoft List, as changing column visibility and positioning requires modifying the list's view settings.

Solution 1Recommended

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.

1
Open the View Menu

Navigate to your Microsoft List. In the top right corner of the list area, click on your current view name (often labeled 'All Items').

2
Select Edit Current View

From the dropdown menu that appears, click on 'Edit current view' to open the classic view configuration page.

3
Unhide the Column

Scroll down to the 'Columns' section. Find the specific column you want to unhide and check the box in the 'Display' column.

4
Adjust Position from Left

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.

5
Save the Changes

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.

Manually Set Column Position via View Settings
Drag and Drop Alternative: If you are using the modern list view, you can also unhide the column first, then simply click and drag the column header left or right to manually reorder it without entering the settings page.
Free Microsoft Office alternative

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. 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Data: Launch WPS Spreadsheet and open your existing .xlsx or .csv data files directly.
  3. 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.
Completely free suite including Word, Excel, PowerPoint, and PDF tools.Seamless format compatibility with Microsoft Excel (.xlsx, .xls) and CSV files.Intuitive column management: easily hide, unhide, and drag to reposition columns with no hassle.Lightweight software with a familiar interface, ensuring zero learning curve.
QA img-9

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.