Office Settings & Configuration

Keep an Excel Text Box Visible While Scrolling

Natalie TaylorNatalie Taylor Nov 22, 2026 868 views

Question details

The user wants a text box to remain visible while scrolling through an Excel worksheet.

How to Keep an Excel Text Box Visible While Scrolling
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains a text box that the user wants to keep in view while navigating the sheet.
Observed behavior
The text box scrolls with the worksheet even when its property is set to Don't move or size with cells.
Before you start

Decide whether the text box can fit in rows or columns you can freeze, or whether you need a separate floating window. The Don't move or size with cells setting controls changes to rows and columns, not worksheet scrolling.

Solution 1Recommended

Place the text box in a frozen worksheet area

Use Freeze Panes to keep the text box visible within the worksheet while you scroll.

1
Position the text box

Drag the text box entirely into the rows or columns you want to keep visible, such as the top rows of the worksheet.

2
Select the freeze boundary

Select the cell immediately below the rows and to the right of the columns you want to freeze. For example, select B4 to freeze rows 1–3 and column A.

3
Freeze the panes

Choose View > Freeze Panes > Freeze Panes. If a freeze is already applied, choose Unfreeze Panes first.

4
Test scrolling

Scroll through the worksheet and check that the text box stays visible. If you scroll in both directions, keep it inside the intersection of the frozen rows and columns.

Frozen area limitation: The text box stays within the frozen worksheet area; it is not an independent window that floats above Excel.
Keep worksheet content in view

Keep a Text Box in View with WPS Spreadsheets

In WPS Spreadsheets, place the text box in a frozen worksheet area and use Freeze Panes to keep that area visible while scrolling. Check the result in your version, since object behavior can vary.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
  2. 2. Move the text box: Drag the text box into the top rows or left columns you want to keep visible.
  3. 3. Set the freeze boundary: Select the cell below the rows and to the right of the columns you want to freeze.
  4. 4. Freeze and test: Choose View > Freeze Panes, then scroll to check that the text box remains visible. Adjust its position or the freeze boundary if needed.
Freeze worksheet rows and columns around a text boxOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my text box still scroll when I select Don't move or size with cells?

That property controls how the text box responds to changes in rows and columns. It does not lock the box to the screen while the worksheet scrolls.

Can I keep the text box visible when scrolling both horizontally and vertically?

Place it in the intersection of frozen rows and columns. Select the cell below and to the right of that area, then choose View > Freeze Panes > Freeze Panes.

Can Excel make a worksheet text box float independently of the sheet?

Freeze Panes keeps the box in a worksheet area, not in an independent window. For a separate window, create a VBA UserForm and show it with UserForm1.Show vbModeless in a desktop version of Excel that supports VBA.

What file format should I use for the UserForm macro?

In Excel, choose File > Save As and select Excel Macro-Enabled Workbook (.xlsm) to retain the VBA code and UserForm.