Step 1 : Take your mouse cursor at the place in the row heading which has hidden row. You can perform similar steps to hide the column.įollow the below steps to unhide the row in excel : You would notice that the row number hides as shown in the screenshot below : Release the mouse cursor when the row is invisible. Step 2 : Left click on your mouse and drag the mouse upwards towards the upper line of the row. Your mouse cursor would convert to a line with arrows on both its side as shown in the screenshot below : Step 1 : Take your mouse cursor at the bottom line of the row heading number (which you want to hide). One of the disadvantage of this method is that you can hide only one row/column at a time.įollow the below steps to hide the row in excel : This is the easiest method to hide and unhide row or column in excel worksheet. Now click on the “Unhide Columns” option from the list. Navigate to the “Hide & Unhide” option from “Format” drop down list as demonstrated above. 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.
![how to unhide columns in excel how to unhide columns in excel](https://www.isumsoft.com/images/office/hide-or-unhide-cells-rows-or-columns-in-excel/unhide-all-rows-or-columns.png)
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.
![how to unhide columns in excel how to unhide columns in excel](https://www.excelhow.net/wp-content/uploads/2019/01/hide-unused-rows-and-columns3.gif)
Similarly, to hide the column, select the column (that you want to hide). It has just hidden the row (It is just not visible).
![how to unhide columns in excel how to unhide columns in excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2018/07/how-hide-column-excel-online-4.jpg)
You would notice that Row number 4 hides in the excel worksheet.
#How to unhide columns in excel serial numbers
After that press, Ctrl+Shift+9 buttons simultaneously from the keyboard or just right-click anywhere on sheet and select unhide.Īnd for unhiding all rows at once, after selecting the whole sheet, right-click on the top area of the rows where the serial numbers are given (A, B, C.) and select unhide.From the list of available options, click on the option “Hide”. To unhide all hidden columns in any Excel sheets, go to the top left corner of your sheet area and click on + icon to select the whole sheet or alternatively you can use Ctrl+A shortcut. To unhide the entire column, highlight the upper and lower column, for example in the above screenshot we hid 12th number column and to get it back we use mouse pointer for highlighting above and lower ones and after that, we will right-click on it to select the unhide option or use keyboard shortcut Ctrl+Shift+9. Hide entire column, select, right-click and hide. For more info see the below two screenshots.If you want to use a keyboard shortcut to unhide column then after highlighting press Ctrl+Shift+9. To unhide just like we did for rows, select and highlight the upper and lower column of the hidden one and right to select unhide option.Select hide option or you can use shortcut key Ctrl+9 to hide the column.Go to the Excel sheet where you want to hide a column in Excel.Hide or Unhide a complete Column in Excel Now, right on it and select the unhide option. To unhide a row, use your mouse click on left row drag your mouse towards the right row of the hidden one. Just right click on top of the row and select the Hide option. There you will see an option unhide, select that and you will get your row back.Now to unhide the row which you have hidden, use mouse pointer and highlight the left and right side of the hidden one and then right-click.This will hide the selected complete row.You can also use a keyboard shortcut to hide rows that is- Ctrl + 0 (zero). Now a pop-up menu will open, at the lower side you will find an option “ Hide” select that.
#How to unhide columns in excel serial number
On your Excel to hide any complete row, go to it and right-click on top of it where the serial number series is given such as A, B, C, D and so on.
![how to unhide columns in excel how to unhide columns in excel](https://www.jquery-az.com/wp-content/uploads/2019/07/51.2-Excel-hide.png)
If you already on that move to the next step. Unhide all columns and rows in excel Hide or Unhide a complete Row in Excel