![to unhide a column in excel to unhide a column in excel](https://excelinexcel.in/ms-excel/wp-content/uploads/sites/2/2020/07/new-13-450x307.png)
Let us know if you face any problems in the comment box.
#To unhide a column in excel how to#
In this article, we described 4 simple methods of How to Hide Columns in Excel. Right-click the selected columns, and then select Unhide from the Context Menu.Select both columns on either side of Column C(January).Let’s say, we want to unhide the sales amount of January. Unhide Columns with Simple Unhide Command Read more: How to Unhide Columns in ExcelĢ. Double click on the Hidden Column line.Unhide Columns by Double Clicking the Hidden Column Line How to Unhide Columns in Excel (2 Quick ways) 1.
![to unhide a column in excel to unhide a column in excel](https://res.cloudinary.com/diqqalzsx/image/upload/v1580551967/content/Excel/doc-hide-unhide-rows-with-plus-sign-04_jnnp8h.png)
You can see that Column C, Column E and Column G are hidden. You can see the C1, E1 and G1 Cells are selected. Type the Cell References C1, E1, and G1(that contains data of the corresponding month) into the Name Box.You can see the Column C, Column D & Column E are hidden. We can see the C1, D1, and E1 Cells are selected. Type the Cell References C1, D1, and E1 (that contains data of corresponding month) or any other cells on the corresponding columns into the Name Box.On the Home tab > Cells Group > Format > Hide & Unhide > Hide Columns.Type the Cell Reference C1(that contains January Data) or any other cell in Column C into the Name Box.Using the Name Box is another simple way of hiding columns in Excel. The Group command can’t be used to hide multiple non-adjacent columns. To hide the column, click the minus sign.First, we have to select the first column ( Column C – January) by clicking on top of it.On the Data tab > Outline group > Group > Group.Group command is used to visually group columns or rows to monitor them in a concise & organized manner under one heading.
![to unhide a column in excel to unhide a column in excel](https://www.jquery-az.com/wp-content/uploads/2019/07/51-excel-hide-col-row-demo-1.gif)
Hide Single or Multiple Columns with Group Command from the Data Tab
![to unhide a column in excel to unhide a column in excel](https://excelunlocked.com/wp-content/uploads/2020/02/How-to-Hide-or-Unhide-a-Row-or-Column-in-Excel.png)