Forum Discussion

Lulus's avatar
Lulus
Copper Contributor
May 09, 2025

Feature Suggestion: Ability to Pin or Freeze Non-Contiguous Rows in Excel

Dear Microsoft Excel Team,

 

I’d like to suggest a powerful productivity feature for future versions of Excel: the ability to pin or freeze non-contiguous rows so they remain visible while scrolling.

 

Currently, “Freeze Panes” only works for rows at the top of the sheet. However, in many real-world use cases — such as tracking project milestones, parent rows in grouped data, or key summary entries — users often need to keep specific non-adjacent rows visible for reference as they scroll through large datasets.

 

Suggested functionality:

  • Let users right-click a row and choose “Pin Row” or “Keep Visible”.
  • Pinned rows could float at the top of the viewport (like sticky headers) even while scrolling down.
  • Ideally, multiple rows could be pinned — not just one — and these could be toggled on or off without disrupting the structure of the worksheet.

 

This feature would dramatically improve usability for complex workbooks and align Excel more closely with modern UI patterns found in web apps and dashboards.

 

Thank you for considering this enhancement!

 

A dedicated Excel user

Resources