NOTE: For hidden columns, press the first visible column button, and drag to the left. Right-click on the first visible row button, and click Unhide.Press on the row button for the first visible row.Try the following steps, to extend the selection, and show the hidden rows: When the hidden rows are at the very top of the sheet, it's hard to select the hidden rows, in order to unhide them. This short video shows the "Extend Selection" technique, and the written steps are below the video. If unfreezing didn't fix the problem of hidden rows, this extend selection trick might help. The "hidden" rows or columns might reappear after that, when you scroll to the top or left of the worksheet. If there is an Unfreeze Pane command in the drop down list, click that, to unfreeze the locked sections.To see if freezing is the problem of hidden rows, follow these steps:
This short video shows the problem, and how to fix it. There are frozen rows or columns, and the "hidden" sections are out of view. In some cases, the rows or columns aren't really hidden. In these cases, try one of the following techniques: Usually it's easy to unhide rows or columns in an Excel worksheet, but occasionally you can run into problems. NOTE: You can also change the freezing to Top Row or First Column, instead of removing the freezing completely.Click the Unfreeze Pane command (it replaces the Freeze Pane command).To see those off-screen rows or columns, use the Unfreeze command.Īfter any type of Freeze Panes command has been used, you can use the Unfreeze Panes command to remove the freezing.If the frozen rows have other rows above them, you can't scroll up to see them.If frozen columns have other columns to the left of them, you can't scroll left to see them.Any frozen rows stay in place if you scroll up or down on the worksheet.
If you select the Freeze Top Row command, it does not automatically freeze Row 1 on the worksheet. The 3 Freeze Pane options work differently, and each option is explained below. To see the Freeze Pane options, click the arrow on the Freeze Panes button.On the Excel Ribbon, click the View tab.If you want to scroll down the worksheet, and lock the heading rows in place, so they're always visible, you can use one of the Freeze Panes commands. More Tutorials Lock Rows and Columns in Place