Scrollable List Window with INDEX

Excel Formulas › Dashboards & Reporting

All versionsINDEX

Show a fixed window into a long list — like 10 rows you scroll through — without filtering. A control cell sets the start row, and INDEX pulls the window, so a scrollbar pages through big data on a compact dashboard.

Quick formula: the k-th row of a scrolling window:
=INDEX(data, start_row + k - 1)
A start-row control plus an offset k returns each visible row; tie the start to a scrollbar form control.

Functions used (tap for the full reference guide):

INDEX

The example

Rows 11–20 shown; scrollbar at 11.

AB
1SlotValue
2Row 1 of window= INDEX(data, start)

The formula

The formula:

=INDEX(data, $start_cell + ROW()-window_top) // start + offset = visible row

How it works

How it works:

  1. A control cell (linked to a scrollbar form control) holds the start row.
  2. Each visible slot is INDEX(data, start + offset) — offset 0, 1, 2… down the window.
  3. Use ROW() - window_top_row to generate the offset automatically as you fill down.
  4. The scrollbar changes the start cell, paging the window through the full list.

A window beats a filter for browsing. Filters hide rows; a scrolling window keeps a fixed-size, fixed-position block on the dashboard while the user pages through thousands of records with a scrollbar. Cap the start so the window can’t run past the end: MIN(start, rows - window_size + 1), and guard with IFERROR for clean blanks.

Try it: interactive demo

Live demo

Start row of a 5-item window into A–Z.

Variations

Cap the start

Don’t overrun:

=MIN(start, ROWS(data) - window + 1)

Two columns

Name & value:

=INDEX(names, start+k-1) & " — " & INDEX(values, start+k-1)

Safe blank

Past the end:

=IFERROR(INDEX(data, start+k-1), "")

Pitfalls & errors

Cap the start. Limit it so the window can’t scroll past the last row.

Lock the control. Use an absolute reference to the start cell in every window formula.

Guard the end. Wrap in IFERROR so the tail shows blanks, not #REF!.

Practice workbook

📊
Download the free Scrollable List Window with INDEX practice workbook
A scrollable-window sheet with the cap, two-column, and safe-blank variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I make a scrollable list window in Excel?
Link a scrollbar to a start-row cell and use =INDEX(data, start + k - 1) for each visible slot.
How do I stop the window scrolling past the end?
Cap the start: =MIN(start, ROWS(data) - window_size + 1), and wrap rows in IFERROR for clean blanks.
Why use a window instead of a filter?
A window keeps a fixed block on the dashboard while you page through large data, rather than hiding rows.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: OFFSET dynamic range · INDEX & MATCH 2D · Average last N values

Function references: INDEX