Question:  I have an Excel worksheet that has the first 6 rows frozen. In the first 6 rows, I have hyperlinks to different cells in column B. When I click the hyperlinks, Excel tends to show the cell at the bottom of the viewing page.

I want the cell that the hyperlink refers to be displayed in the next row after the frozen rows. Can this be done?

Answer:  Let's take a look at an example.

Below, we have an Excel spreadsheet with the first 6 rows hidden. In cell B5, we've created a hyperlink to cell B30. When we click on the hyperlink in cell B5, the spreadsheet looks as follows:

The hyperlink is at the bottom of the viewing area in the spreadsheet. We want to see row 30 directly under row 6.

To fix this, select Options under the Tools menu. When the Options window appears, click on the Transition tab. Then select the option called "Transition navigation keys". Click on the OK button.

Now when you click on the hyperlink in cell B5, your spreadsheet should look as follows: