Fix Cannot Type in Excel Cells or Formula Bar on Mac
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.

- 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.
Verify that your keyboard functions normally in other Mac applications and ensure the current Excel worksheet is not locked with worksheet protection.
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.
Open Excel, click on 'Help' in the top Apple menu bar, and select 'Check for Updates'.
Follow the Microsoft AutoUpdate prompts to download and install the newest Excel build, then restart your Mac.
Disable Excel Add-ins and Clear Startup Folders
Third-party add-ins or corrupted startup files frequently interfere with Excel's keyboard input functionality.
Test Excel in a New macOS User Account
Creating a new user profile helps determine if the typing issue is system-wide or isolated to your specific user preferences and permissions.
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.

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.




