If the above doesn’t help you to unhide rows, there may be a chance that the hidden rows was a result from advanced filter. Learning is a series of curiosity, observation, and trials & errors.
For row height =0.68, we will see a “noticeable” row, so that we know the row is not hidden. Under Cell Size, click Row Height or Column Width, and then in the Row. This interesting behavior made me do a little test on different row heights. Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Let’s take a look at the result when I changed the row height for rows 1:16 in the screenshot below: It’s difficult to show what I did with my “shaking” hand in a static photo. While I was lost and had no clues, my “shaking” hand gave me the answer: That was one of the weird things I encountered in using Excel. Strange enough, rows 18:19 are back but not rows 2:15. To test the Hide and Unhide be working properly, I have hidden rows 18:19 (by right-click & hide) and then unhide the whole worksheet: It changed from “A1” to “A16”, which means rows 2:15 are hidden. Also I tried to press Down Arrow in A1 and observed the change in Name Box. The worksheet is not password-protected. Then I tried the normal ways to unhide the rows, but failed. In the screenshot below, rows 2:15 are hidden. I thought so too before I received a strange worksheet sent by a colleague. Just another real case to share.įor an unprotected sheet, hidden rows can be unhidden easily. Hidden rows cannot be unhidden? Why?Īlthough today is April Fools’ Day and the question sounds like an April Fool’s question, this post is not about to fool anyone. Note: Please turn on CC for English subtitles. You may read this post to understand more. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width.This above video was made just recently. Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. On the Home tab, in the Cells group, click Format. 
In the Reference box, type A1, and then click OK. On the Home tab, in the Editing group, click Find & Select, and then click Go To. In the Name Box next to the formula bar, type A1, and then press ENTER.
To select the first hidden row or column on the worksheet, do one of the following: Instead, you can use the Name box or the Go To command to select the first row and column. You can select the entire worksheet, and then unhide rows or columns ( Home tab, Cells group, Format button, Hide & Unhide command), but that displays all hidden rows and columns in your worksheet, which you may not want to do. If the first row (row 1) or column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that row or column.
0 kommentar(er)
