To begin, open your workbook in Excel.
Click the Column Header you want to hide.
In the Home tab, click "Format" to open a drop down menu.\ Under "Visibility," hover over "Hide & Unhide" then click "Hide Columns."
Click the Select All cell in the top left of the spreadsheet.
In the Home tab, click "Format" to open a drop down menu. Under "Visibility," hover over "Hide & Unhide" then click "Unhide Columns"