Member Avatar for abu taher

in the attach file I want the selected area will be fixed. I mean when I page down this section not go up. this will fixed and the above thing only move. how I do it?

auto_filter.JPG 144.76 KB
  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by pcs365_4

Dani AI

Generated

asked for a way to keep a selected area visible while the rest of the sheet scrolls. pointed toward Freeze Panes — that is the right tool, but the important detail is how Excel decides what to lock.

Everything above and to the left of the active cell becomes fixed. Examples:

  • To freeze only the top row, use Freeze Top Row.
  • To freeze rows 1–3 and columns A–B, make cell C4 the active cell and then freeze panes.
  • To freeze the first column only, use Freeze First Column.

Typical workflow:

  • Select the cell that sits immediately below the rows and immediately to the right of any columns that should remain visible.
  • Use the Freeze Panes command (location varies by Excel version: View menu on modern ribbons, Window menu in older menus).
  • To remove the lock, choose Unfreeze Panes from the same menu.

Notes and troubleshooting:

  • Apply AutoFilter (filter dropdowns) to the header row, then freeze that header row so filters remain visible while scrolling.
  • If the result looks wrong, Unfreeze and reselect the correct cell (selecting a full row/column can produce unexpected freezes).
  • Split is an alternative when independent scrolling of two regions is needed.
  • For repeating headers on printed pages, use Print Titles (Page Setup / Sheet tab).

This clarifies the selection rule and offers alternatives for common needs.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.