To unhide the hidden columns, please refer to Ctrl+Shit+0 if you like using shortcut or follow the steps below:
Step 1: Select columns or the whole worksheet by clicking the top left corner;
Step 2: Right-click and select "Unhide" from the dialog box;
Step 3: The hidden column will show up.
Alternatively, please use the commands in the ribbon:
Step 1: Select the hidden columns or select whole worksheet;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Format" in the Cells section, and select "Unhide Columns" from the "Hide & Unhide" command;
Step 4: The hidden columns will appear.