Contents
While working in Excel, situations often arise when certain columns of a table need to be hidden. The result is clear – some of the columns are hidden and are no longer shown in the book. However, this action has the opposite – namely, the disclosure of columns. And below we will look at exactly how you can turn on the display of hidden columns back.
Content
First you need to understand if there are hidden columns in the table and determine their location. This task is easy to implement, and the horizontal coordinate panel of the program, on which the names of the columns are indicated, will help us in this. We pay attention to the order of names, if it is not observed somewhere, it means that in this place there is a hidden column (columns).
Now that we have decided on the presence and location of the hidden elements, we can move on. There are several ways to make columns visible again.
Method 1: Boundary Shift
You can display hidden columns by expanding the borders or returning them to their original place.
- To do this, move the cursor over the column border, as soon as it changes to a double-sided arrow, hold down the left mouse button and drag it in the desired direction.
- With this simple action, we again made the column “С” visible.
Note: This method is quite simple, however, some users may not like the moment when they have to “hook” on a rather thin line of the border, trying to move it. In addition, when it comes to several hidden columns, this method becomes quite troublesome. Fortunately, there are other methods, which we’ll look at next.
Method 2: Using the Context Menu
Perhaps this is the most popular method that allows you to display hidden columns.
- On the coordinate panel, we select in any way convenient for us (for example, using the left mouse button pressed) a range of columns, inside which there are hidden elements.
- Right-click anywhere in the selected area. In the list that opens, click on the command “Show”.
- As a result, all hidden columns in this range will be displayed in the table again.
Method 3: Ribbon Tools
In this case, the Ribbon of program tools will not help.
- Select on the coordinate panel the range of columns in which there are hidden elements. Switch to tab “Home”. In section “Cells” click on the button “Format”. In the list that appears, click on the item “Hide or show” (subsection “Visibility”) and then “Show columns”.
- Hidden columns will be visible again.
Conclusion
Hidden columns is a useful feature that allows you to temporarily remove unnecessary information from an Excel spreadsheet, making it more comfortable to work with and easier to understand. However, not all users know how to return the hidden elements to their place. This can be done in three different ways, which are quite easy to learn.