Excel Version: 15.41(171205)
Operating System: macOS 11.0 Beta

When I write a text on a cell, the text does not appear on the actual cell but appears on the function tab.
After I type some value and press enter, the text appears normally.

image

How do I fix this so that I can edit a cell directly, not via the function tab?

I tried some methods from the web to solve the problem—

• I did right click -> Format Cells but my format is not ;;; Link
• I went view but I can't find Arrange all and Tiled Link

How do I make cells display value?

1

2 Answers

First option

Look into Excel settings
find Edit cell content in cell (or similar)
set it to Yes/True/Ticked
(from memory, cannot check, no excel available currently)

---

Second thing to try?

Reset all preferences:

5

Try to create a new Workbook and test with the same behavior in Excel. If this issue still existed, you can troubleshoot Office for Mac issues by completely uninstalling before you reinstall:

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy