Similarly, to unhide the column, select the column on the either side of the hidden column. Now select the “Unhide Rows” option from the list as shown in the screenshot below : Navigate your mouse to the option “Hide & Unhide”. Under the group “Cells”, click on the option “Format”. Step 1 : Select the row(s) that you want to hide. Click on the option “Unhide” from this drop-down list.Įxcel has also provided options on the Menu Bar to hide and unhide columns in excel worksheet.
You would notice that the hidden row number 4 is now visible with all its data. This would open a list of options.įrom the list of option, select the option “Unhide”.
Therefore, we need to select the rows from row number 3 to row number 5. In our case, row number 4 is the hidden row. Step 1 : Select the rows on either side of the hidden row. In order to unhide or show the hidden row or column in excel, follow the below procedure : The data in the row or column does not delete. Click on the option “Hide” from the list of available options.Īs mentioned above, when you hide any row or column in excel worksheet, it is just not visible. Similarly, to hide the column, select the column (that you want to hide). It has just hidden the row (It is just not visible). You would notice that Row number 4 hides in the excel worksheet. From the list of available options, click on the option “Hide”.
0 kommentar(er)
