With the help of the mouse, click the label of column B appearing on top.
![unhide first column in excel mac unhide first column in excel mac](https://www.techonthenet.com/excel/rows/images/unhide_row1_2011_003.gif)
The steps to hide excel columns is listed as follows: So, the dataset begins from column A (emp ID) and ends with column G (department). Consider one column of the table as one column of an Excel worksheet. The following table displays the IDs, names, gender, age, and department of some employees of an organization. Example #1–Hide Columns Using the “Hide” Option of the Context Menu For hiding multiple non-adjacent columns, refer to the second question under the heading “frequently asked questions.” This is given at the end of this article. Note: All the following examples demonstrate the process of hiding adjacent (contiguous) columns. Let us discuss these methods one by one with the help of examples. The techniques of hiding columns in Excel are listed as follows:
Unhide first column in excel mac how to#
How to Hide Columns in Excel? (Top 4 Methods) The purpose of hiding an excel column is to allow viewing the relevant areas of a worksheet at a given time. This helps avoid confusion amongst users of a shared worksheet.Ī column is hidden when its data needs to be concealed from other Excel users, it is unused and not required for a while, its presence is making comparisons between the remaining columns difficult, and so on. However, to use a hidden column again, it needs to be unhidden at first.įor example, a column containing calculations may be hidden.
![unhide first column in excel mac unhide first column in excel mac](https://cdn.ablebits.com/_img-blog/freeze-panes/excel-freeze-top-row.png)
In Excel, one can hide both contiguous and non-contiguous columns. This means that it does exist and has been only temporarily held from view.
![unhide first column in excel mac unhide first column in excel mac](https://i0.wp.com/cdnssl.ubergizmo.com/wp-content/uploads/2017/01/click_on_view_option.jpg)
A hidden column is not deleted from the worksheet. Hiding a column in excel implies making it invisible so that it is removed from display.