Unhide Column in Excel (Table of Contents)
Unhide Column in Excel
You can unhide column using one of the following 7 Methods –
- Using the Ribbon
- Using the shortcut key
- Using ‘Context Menu’
- Using ‘Column Width’
- Using the Ctrl+G (Go To) command
- Using the Ctrl+F (Find) command
- By double-clicking the ‘double line’ for hidden columns.
#1 – Using the Ribbon
To unhide column, we need to select the columns of both sides and then choosing the ‘Home’ tab-> ‘Cells’ group -> ‘Format’ dropdown -> ‘Hide & Unhide’ -> Unhide Columns
#2 – Using the Shortcut Key
After selecting the column of both sides, we can press Alt+H+O+U+L.
#3 – Using Context Menu
After selecting, the column of both sides, then by right clicking and choosing the Unhide.
#4 – Using Column Width
After selecting, the column of both sides, then by right clicking and choosing the column width, please specify the ‘Column width’ to any number.
#5 – Using the Ctrl+G (Go To) Command
As we know column C and D are hidden, Using ‘Go to’ command (Shortcut Key: F5), we can specify the reference of any cell in B like B1 and then choose any of the method mentioned above, we can unhide column in excel.
#6 – Using the Ctrl+F (Find) Command
Sometimes, we don’t know the cell reference, we know the data written in the cell, in that case, we can use the ‘Find’ command to go to the required cell reference and unhide column in excel by using any of the above four methods.
#7 – By double-clicking the ‘double line’ for hidden columns.
By double-clicking the ‘double line’ on the column labels, we can unhide column in excel.
To do the same, we can enter single cell reference of the required column into the Name box and then use the command available through the format button on the Home tab of the ribbon to unhide column in excel.
Locating the Hidden Columns
To locate the hidden column, after selecting the entire sheet, we need to use ‘Go To’ (F5) command -> Special ->Visible Cells only->OK.
There is a line, which is showing the hidden columns. Now after selecting the columns, we can use any of the mentioned methods to unhide column.
If one user wants to view the hidden columns and the other user does not’. Then we can use the ‘Custom Views’ command on the View tab, add the view, and use this whenever by not hiding and unhiding the columns.
Things to Remember about Unhide Column in Excel
- The columns disappear from the display. Notice, however, that the other columns do not change; they retain the same column labels. Excel does, however, leave a thick bar in the column header area to indicate where the hidden columns would normally appear.
- If the first column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that column. We can select the entire worksheet, and then unhide columns (Home tab, Cells group, Format drop-down, Hide & Unhide command), but that displays all hidden rows and columns in the worksheet, which we may not want to do. Instead, we can use the Name box (Next to the formula bar) or the Go To command to select the column and then type A1, and then press ENTER.
This has been a guide to Unhide Column in Excel. Here we discuss its uses and how to create Unhide Column in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –
- Explanation of Column Lock in Excel
- How to Freeze or Lock Top Column in Excel?
- Excel Group Columns
- What is 3D Cell Reference in Excel?
- Excel Rows to Columns
- Types of Cell Reference in Excel
- Compare Columns in Excel
- Hide Formula
- Data Table in Excel
- Convert Numbers to Text
- TEXT Function in Excel
- Columns Function in Excel