Office for Mac Issues

Fix Cannot Type in Excel Cells or Formula Bar on Mac

John WilsonJohn Wilson Nov 10, 2026 869 views

Question details

The user is unable to enter text or data into Excel worksheet cells or the formula bar on a Mac, despite the keyboard working perfectly in other applications and Excel's search box.

How to Fix Cannot Type in Excel Cells or Formula Bar on a Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Attempting to input data or formulas into an Excel workbook on a Mac device.
Observed behavior
Keyboard input is entirely ignored in the worksheet grid and the formula bar, even when opening a new workbook. However, Excel's search box and other Mac applications accept keyboard input without issue.
Before you start

Verify that your keyboard functions normally in other Mac applications and ensure the current Excel worksheet is not locked with worksheet protection.

Solution 1

Update Excel to the Latest macOS Build

Software bugs in specific Office builds can block cell input; installing the latest updates often resolves these known glitches.

Microsoft frequently releases patches for Excel on Mac to address interface and input anomalies. Ensuring you are on the latest build is the quickest way to rule out a known software defect.

1
Check for Updates

Open Excel, click on 'Help' in the top Apple menu bar, and select 'Check for Updates'.

2
Install Available Updates

Follow the Microsoft AutoUpdate prompts to download and install the newest Excel build, then restart your Mac.

Free Microsoft Office alternative

Try WPS Office for Mac When Excel Is Unresponsive

If Microsoft Excel continues to block your keyboard input and troubleshooting feels tedious, consider switching to WPS Office. It is a free, lightweight, and highly compatible Office suite that provides a seamless spreadsheet experience on macOS without frustrating input glitches.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight installation that runs smoothly on all macOS versionsFamiliar user interface requiring no learning curve for Excel usersFree to use with built-in powerful data analysis and formula tools
microsoft office alternative - wps office

Frequently Asked Questions

Why can I type in the Excel search bar but not in cells on my Mac?

This specific behavior indicates that your Mac's keyboard is functioning properly, but Excel's internal cell input mechanism is blocked. This is typically caused by corrupted user preferences, an outdated Office build, or incompatible add-ins rather than hardware failure or a locked worksheet.

Does holding Shift while opening Excel on a Mac start it in Safe Mode?

While holding Shift can affect application launch behaviors, it does not fully isolate or disable all add-ins in Excel for Mac. To properly test for add-in interference, you must manually disable them via the 'Tools' > 'Excel Add-ins' menu.

What should I do if typing in Excel works on a new Mac user account but not my main one?

If Excel functions correctly in a new macOS user account, the issue lies within your original account's specific Excel preferences, custom startup content, or corrupted file permissions. Note that simply reinstalling Office often does not remove these lingering preference files.

How do I contact Microsoft Support for this Mac Excel issue if troubleshooting fails?

If you have tested a new user account and typing still fails, use 'Help' > 'Contact Support' within Excel. Before contacting them, prepare your exact Excel version, macOS build, input-source layout, a list of installed add-ins, and a screen recording of the typing failure.