You cannot see, but cell A has been selected now. Step 2: Under the Reference field, enter the column number, i.e., A1 and click the OK button. You can also use the F5 function key to open the Go To dialogue box directly. Step 1: On your Excel worksheet, navigate to Home > Find & Select > Go To to open the Go To dialogue box. We have the following Excel dataset where the first column A is hidden. To unhide the first column (A) of an Excel sheet, we will use the Go To option. There is no other column before the column A.
Unhiding the columns seems easy, but when you need to display only the leftmost one, i.e., Column A, it requires a different method. Often, the first column can also be hidden in an Excel worksheet and the user only want to unhide only that column, not all. Unhide the first column (A) of an Excel sheet Note: If you clicked on selected cells rather than the column header, Unhide function would not work.Īs a result, all the hidden columns will unhide in the current Excel worksheet. Step 3: Right-click on the column header of the table, a context menu will open where click on the Unhide option. However, you can also press the CTRL+A shortcut key for this. Tip: It will select the entire worksheet. Step 2: In your Excel spreadsheet, click on the small triangle present at the start of the row and column in the upper left corner. Step 1: We have the following Excel dataset where more than two columns are hidden. We have a few steps to unhide all the hidden columns in Excel to make the data visible to the users. This method is also the same as the above some and two simple steps to be performed. Whether there is one hidden column or more, this method will unhide all the hidden columns. Thus, this time we will unhide all the hidden columns at once in an Excel worksheet. It might be possible that two or more columns are hidden at different places, which can take time to find and unhide them. See that column E (Salary) and F (Joining_Date) columns are visible now. That's it.Īll the hidden columns between the selected ones will be unhidden, as you can see by yourself. Step 2: Now, right-click on the selected columns and click on the Unhide option at the end of the list. Step 1: Select the two columns (previous and next to the hidden one). We will explain these steps to unhide the hidden column in Excel to make the data visible to the users. To unhide the selected column, we will use the Standard Hidden option. This is a standard method to unhide the selected hidden columns in an Excel worksheet. Check the total number of hidden columns.We will describe all these methods one-by-one in detail. There are four different ways to unhide the columns using the standard Hidden option, Document Inspector, using a macro, or Go to special functionality. It is not so difficult to unhide the hidden columns. It means that two columns (E and F) are hidden here. Look in the column header that we have column G just next to column D. You can also get to know the total number of hidden columns by seeing the Excel column header. You can unhide the hidden column by increasing the size of the hidden column from the double line to the right.Īdditionally, there is one more way to know that the hidden columns. See double lines in the below screenshot:
HOW TO UNHIDE A COLUMN IN EXCEL DOCUMENT HOW TO
How to let the user know that column is hiddenĪ double line between two columns donates to the hidden columns in the header of the Excel worksheet. This chapter will show the methods to unhide the columns in Excel. You can unhide the column and its data whenever you want the visible it again. When you hide a column, the data is not visible to the users but is not deleted.
A double line between two columns donates to the hidden columns in the header of the Excel worksheet. Hiding the columns is a solution rather than deleting them. The Excel users often hide the columns when they don't want to show complete information stored in an Excel sheet. Next → ← prev How to unhide columns in Excel?
0 kommentar(er)
