Document Editing Problems

Fix Cannot Type in Excel Formula Bar When Text Box is Selected

Amos Gikunda Sep 28, 2026 876 views

Question details

The user is unable to type text into the Excel formula bar while a text box or shape is currently selected.

How to Fix Cannot Type in Excel Formula Bar When a Text Box is Selected

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to input or edit text for a selected text box using the top formula bar.
Observed behavior: Typing in the formula bar does not work when a text box is selected, even though it works perfectly when regular cells are selected.

Before you start

Ensure your keyboard is functioning properly and verify that your worksheet is not protected by checking the Review tab.

Solution 1Recommended

Type Directly Inside the Text Box

Learn the intended method for entering text into shapes and objects in Excel.

In Excel, the formula bar is specifically designed for editing cell contents and formulas. It is not intended for typing plain text into objects. When a text box or shape is selected, the formula bar enters a locked state for standard typing, though it can still be used for cell linking.

Select the text box

Click directly on the border or inside the text box you want to edit on your worksheet.

Activate the text cursor

If the text cursor is not blinking, double-click inside the text box to enter text editing mode.

Type your text

Enter your desired text directly into the text box on the worksheet, ignoring the formula bar completely.

Dynamic Cell Linking: To display a cell's value inside a text box, select the text box border, click the formula bar, type '=', click the target cell, and press Enter.

Solution 2

Deselect the Object to Use the Formula Bar

Restore the formula bar's normal functionality by returning your selection to a standard worksheet cell.

Edit Spreadsheets Seamlessly

Use WPS Spreadsheet for Easy Data and Object Editing

WPS Office provides a highly intuitive spreadsheet tool that makes working with cells, complex formulas, and floating objects like text boxes seamless and efficient.

1. Open your file in WPS Office: Launch WPS Office and open your existing spreadsheet document.
2. Insert or select a text box: Navigate to the Insert tab on the ribbon, select Text Box, and draw it on your sheet. Click inside it to type text directly.
3. Use the formula bar for cells: Click on any grid cell, then click the formula bar at the top to enter formulas, keeping object editing and cell data perfectly separate.

Fully compatible with Microsoft Excel (.xlsx) filesIntuitive interface for managing both cells and graphic objectsAdvanced formula bar with built-in function guidesFree and lightweight office suite for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Can I link a text box to a cell value using the formula bar?

Yes. Select the outer border of the text box, click inside the formula bar, type the equals sign (=), and click the cell you want to link to. Press Enter, and the text box will dynamically display that cell's contents.

Why is my formula bar completely missing in Excel?

The formula bar might be hidden in your view settings. Go to the View tab on the ribbon and ensure the 'Formula Bar' checkbox is checked to make it visible again.

Can I use formulas directly inside a text box?

No, you cannot write and calculate formulas like '=A1+B1' directly inside a text box. You must perform the calculation in a regular worksheet cell first, and then link the text box to that specific cell using the formula bar.

Document & File Issues