You may come across an Excel spreadsheet with hidden columns. It is very easy to make them appear, regardless of the version of Excel (Windows or macOS).
Step 1. Open your Excel document
There are two possibilities: either you double-click directly on the document which contains hidden columns or you run Excel first, then you open the document in question from the home page or from the general menu bar.
Step 2. Select the columns on either side of the hidden columns
Hold down the Shift key, then click the column header to the left of the hidden column, then click the column header to the right. The two columns are then highlighted.
- Suppose the columns B and VS are hidden (illustration), hold down the Shift key, click TO, then on D.
- Special case: if it is the column TO which is hidden, in the white field (formula bar) above the header B, type A1.
Step 3. Click on the Home tab
In the green ribbon, this tab is the second from the left, at the top of the Excel window. In doing so, you bring up the toolbar of the section Home.
Step 4. Click Format
This option is in third position in the group Cells, rather to the right of all groups. A drop-down menu will then appear.
Step 5. Select Hide & Show
You will find this possibility in the menu and in the section Visibility. By clicking on it, a context menu will appear on the right.
Step 6. Click Show Columns
In the menu Hide & show, this option is in fifth position. From then on, the hidden columns of your document are displayed on the screen again.
- If the columns remained hidden after this operation, it is because the width of the columns in question is set to 0. To widen them, bring the mouse cursor over one of the small lines close to the header row, wait for your cursor becomes a double horizontal arrow and by clicking on the mouse, drag the cursor to the right of the desired width.
- If you want to display all the hidden columns (dispersed or not) of an Excel spreadsheet, click on the button (black and triangular) Select all which is to the left of the column TO and above the line
Step 1.. Then all you have to do is operate as explained above.