Unhide Columns with the ‘Unhide’ Option
By using the same right-click method that you’ve used to hide the column, you can unhide it too.
The process can be trickier in older versions of Microsoft Excel, as it requires you to select the thick line that represents the hidden column. It’s much easier in the latest Excel releases. Follow these steps:
Select the column that’s adjacent to the hidden one (newer version).
Right-click on the column.
The column should appear. In the older versions, you need to right-click the thick line between the columns and then select the ‘Unhide’ option.