In my Excel, I want to pin several rows.

You see the first three rows:

enter image description here

when I scroll up, the first three rows will be hidden:

enter image description here

Is it possible to pin(let it in the fixed place) it, when scroll, it will still shows?

  • Are you sure that you are not looking to Freeze the Pane(Rows)? And if literally not, VBA(Macro) can hide certain Rows to Scroll and Hide!! Jun 24, 2019 at 4:55

1 Answer 1


Try to use Freeze Pane function, please select Row 4 and go to View- Freeze Panes- Select Freeze Panes:

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .