You do not need to hold down the Alt key as pressing other keys.
Now, click on the “Unhide” option in the menu as shown below:įourth Way – Using the short key to unhide all rowsĪfter selecting all cells either by clicking on the triangle located at the top left of the sheet or press the Ctrl + A, use the following short key to unhide one or all rows: For unhiding the row number 6, select the row number 5 or 7 and right click on any of its cell. This should unhide row number 6.Īlternatively, you may drag the same line by mouse and expand the row number 6.Īfter hiding the required rows, select the adjacent row. To unhide the row number six (in our example), double click the lower side of the line that is above row number 7. The line between other visible rows is thin. Under the Visibility heading, expand the “Hide & Unhide” menu and press the “Unhide Rows” option as shown below:Īs mentioned earlier, you may notice the comparatively thick line between row 5 and 7. To unhide the row number six, the following ways can be used.įind the Cells group –> Format –> Visibility You may clearly notice a thick line between row number 5 and 7 as compared to line between other rows. Just in case, you need to learn, here is the link to its tutorial: Hide the columns and rows in Excel.įor the example, I hid the row number six as shown below:
#EXCEL HOW MANY ROWS IN THE SHEET HOW TO#
To unhide the rows, I am again assumed that you know how to hide the rows and columns. The process to unhide the hidden row is almost the same as unhiding the column. To unhide all hidden columns, first select whole sheet by pressing Ctrl+ A and then use this short key: This is using the short key to unhide the column. To unhide column(s) by single action, you may unhide one or all hidden columns. Under the “ Visibility” heading in Format button’s menu, click the “Unhide Columns” option as shown in the graphic belowįourth Way – Using shortcut key to unhide all columns Under the “ Cells” group, locate the “ Format” button and press the small arrow to open its menu. If you are comfortable using the ribbon for performing tasks rather than using contextual menu (right click) then this is how you may unhide the hidden columns. Third way: Using the Home menu in the ribbon You may also unhide the hidden column by double clicking the double line or drag the line towards right. If you look closer at the column lines after hiding a column, you will notice those are double lines and look a little thick than normal columns. Second way: Unhide by double line example Right click on either C or E column and press the “Unhide” option in the menu:
In our example, we have C and E adjacent columns to the hidden D column. To unhide the single column D by using right click, follow this: I have hidden the column D for the demo as shown in the graphic below: The first way to unhide the hidden column is using the right click option.įor the example, I assume that you have already hidden a column. Unhide a hidden column by right click example Fourth Way – Using shortcut key to unhide all columns