Unhide Columns with a Double-Click
Another way to unhide the columns is to double-click on the thick line that represents the hidden one.
In some cases, the column unhidden with this method will appear slightly narrower than usual. You can manually click on the edge of the column and drag your mouse to increase it. Alternatively, you can right-click the column and select ‘Column Width’ before entering the required value.
As you can see, hiding a column in Microsoft Excel is a simple and straightforward task. Keep in mind that hidden columns can be restored easily, so they are not the same as deleted columns.
You should use this feature for organizational purposes and to prevent your screen from getting overcrowded with non-essential data. However, if you want to remove a column for good, use the delete function.