Unhide Column in Excel (Using Top 7 Methods)
You can unhide columns in excel 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.
Method #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
Method #2 – Using the Shortcut Key
After selecting the column of both sides, we can press Alt+H+O+U+L.
Method #3 – Using Context Menu
After selecting, the column of both sides, then by right-clicking and choosing the Unhide.
Method #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.
Method #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 methods mentioned above, we can unhide column in excel.
Method #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.
Method #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
- 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, use Name box in excel (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 –