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:
UNHIDE A COLUMN IN EXCEL 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?