Keep an Excel Text Box Visible While Scrolling
Question details
The user wants a text box to remain visible while scrolling through an Excel worksheet.

- 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.
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.
Place the text box in a frozen worksheet area
Use Freeze Panes to keep the text box visible within the worksheet while you scroll.
Drag the text box entirely into the rows or columns you want to keep visible, such as the top rows of the worksheet.
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.
Choose View > Freeze Panes > Freeze Panes. If a freeze is already applied, choose Unfreeze Panes first.
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.
Create a modeless VBA UserForm for a floating window
Use a modeless UserForm when you need a separate window that can remain open while you work in the worksheet.
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. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
- 2. Move the text box: Drag the text box into the top rows or left columns you want to keep visible.
- 3. Set the freeze boundary: Select the cell below the rows and to the right of the columns you want to freeze.
- 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.

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.




