Share via

How do you freeze a worksheet tab in excel without scrolling

Anonymous
2023-08-11T12:41:19+00:00

Is there an easy way to freeze a worksheet tab in excel? This would freeze the worksheet in place while scrolling through the rest of the worksheets. (I do not need to lock protect anything; I do not need to freeze any panes within the excel either.) The only solutions I have found so far are making hyperlinks and using coding to accomplish this, both of which are not preferable. The coding did not work for me thus far after saving in a macro-enabled workbook. I look forward to hearing any advice you might have. Thank you for your help!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-08-11T14:06:18+00:00
    1. As you found, the best way is to write a macro code to move that sheet before the active sheet.
    2. Another way is create hyperlink in every sheet to go back to the sheet you want.
    3. Right click the corner will open a list of all the sheet, you can easily choose the sheet you want to go.

    There is no such built-in function to freeze a worksheet. You may send feature request to Micrsoft from below link.

    Excel · Community (microsoft.com)

    30+ people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest